A real slice of the file, not a mock-up
| DCRAINTERNALNUMBER | ISSUE_DATE | PERMIT_ID | PERMIT_TYPE_NAME | PERMIT_SUBTYPE_NAME | PERMIT_CATEGORY_NAME | APPLICATION_STATUS_NAME | FULL_ADDRESS | SSL | ZONING | FEE_TYPE | FEES_PAID | CITY | STATE | LATITUDE | LONGITUDE | XCOORD | YCOORD | ZIPCODE | MARADDRESSREPOSITORYID | DCSTATADDRESSKEY | DCSTATLOCATIONKEY | WARD | ANC | SMD | DISTRICT | PSA | NEIGHBORHOODCLUSTER | HOTSPOT2006NAME | HOTSPOT2005NAME | HOTSPOT2004NAME | BUSINESSIMPROVEMENTDISTRICT | LASTMODIFIEDDATE | GLOBALID | CREATED_DATE | LAST_EDITED_DATE | OBJECTID | LAYER_YEAR |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1684339209.0 | 2023-03-26 | G84339209 | SUPPLEMENTAL | PLUMBING AND GAS | NA | NULL | 124 11TH ST NE, WASHINGTON, DC 20002 | 0965 0060 | RF-1 | 2.60 (PLUMBINGEFEE);26.00 (GASFIREPLACE) | 29 | 38.89113958 | -76.99176597 | 400714.34 | 135921.72 | 70078.0 | 6 | ANC 6A | 6A07 | FIRST | 108 | Cluster 26 | 2026-08-17 | {59DCBB16-1BED-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140402520 | 2023 | |||||||||
| 2587288882.0 | 2023-03-26 | P87288882 | SUPPLEMENTAL | PLUMBING AND GAS | NA | PERMIT ISSUED | 1750 P ST NW, WASHINGTON, DC 20036 | 0157 0113 | 73 | 38.90941699 | -77.04060685 | 396478.07 | 137951.41 | 238156.0 | 2 | ANC 2B | 2B05 | SECOND | 208 | Cluster 6 | 2023-03-28 | {59DCBB16-838A-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140429045 | 2023 | |||||||||||
| 2518631478.0 | 2023-02-13 | P18631478 | SUPPLEMENTAL | PLUMBING AND GAS | NA | COMPLETED | 500 21ST ST NE, WASHINGTON, DC 20002 | 29 | 38.89626862 | -76.97479331 | 402186.64 | 136491.39 | 15630.0 | 7 | ANC 7D | 7D05 | FIFTH | 507 | Cluster 25 | 2024-04-01 | {59DCBB16-919E-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140432649 | 2023 | ||||||||||||
| 141305804.0 | 2023-03-26 | E1305804 | SUPPLEMENTAL | ELECTRICAL | NA | EXPIRED | 2400 EAST CAPITOL ST SE, WASHINGTON, DC 20003 | 1128 0804 | 220.00 (REVISION);22.00 (ELECTRICEFEE);55.00 (INSTALL8) | 319 | 38.8897903063 | -76.9718954058 | 402438.25 | 135772.32 | 293222.0 | 7 | ANC 7D | 7D05 | FIRST | 108 | Cluster 25 | 2026-08-17 | {59DCBB16-9852-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140434365 | 2023 | ||||||||||
| 1459855397.0 | 2023-03-26 | E59855397 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 4604 43RD ST NW, WASHINGTON, DC 20016 | 1649 0051 | 31 | 38.95018176 | -77.08406094 | 392713.36 | 142479.26 | 277434.0 | 3 | ANC 3E | 3E01 | SECOND | 202 | Cluster 11 | 2023-03-31 | {59DCBB16-C71E-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140446345 | 2023 | |||||||||||
| 1412679369.0 | 2023-07-26 | E12679369 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 414 SHEPHERD ST NW, WASHINGTON, DC 20011 | 3237 0057 | 539 | 38.93971989 | -77.01795155 | 398443.68 | 141314.66 | 247909.0 | 4 | ANC 4C | 4C07 | FOURTH | 407 | Cluster 18 | 2023-07-27 | {59DCBB16-E3CE-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140453689 | 2023 | |||||||||||
| 1467433672.0 | 2023-06-13 | E67433672 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 1512 OKIE ST NE, WASHINGTON, DC 20002 | 4037 0010 | 344 | 38.91555376 | -76.9819918 | 401561.76 | 138632.05 | 312676.0 | 5 | ANC 5D | 5D02 | FIFTH | 506 | Cluster 23 | 2023-06-15 | {59DCBB17-74AA-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140490773 | 2023 | |||||||||||
| 1427934306.0 | 2023-03-26 | E27934306 | SUPPLEMENTAL | ELECTRICAL | NA | PERMIT ISSUED | 853 52ND ST NE, WASHINGTON, DC 20019 | 5198 0173 | 136 | 38.90142229 | -76.92545756 | 406465.97 | 137065.79 | 81478.0 | 7 | ANC 7C | 7C06 | SIXTH | 608 | Cluster 31 | 2023-03-28 | {59DCBB17-93B8-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140498723 | 2023 | |||||||||||
| 1660667325.0 | 2023-03-26 | G60667325 | SUPPLEMENTAL | PLUMBING AND GAS | NA | COMPLETED | 901 MASSACHUSETTS AVE NW, WASHINGTON, DC 20001 | 0370 0848 | D-4-R | 26.00 (GASLINETEST);5.20 (PLUMBINGEFEE);26.00 (GASFIREPLACE) | 57 | 38.90367009 | -77.02467863 | 397859.39 | 137313.0 | 239811.0 | 2 | ANC 2G | 2G05 | THIRD | 307 | Cluster 8 | 2026-08-17 | {59DCBB17-CF82-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140514029 | 2023 | |||||||||
| 2824212301239.0 | 2023-04-26 | SOL2301239 | CONSTRUCTION | SOLAR SYSTEM | NA | EXPIRED | 630 BURNS ST SE, WASHINGTON, DC 20019 | 5392 0054 | R-2 | 12.50 (SOLFILEFEE);12.50 (SOLAREFEE);125.00 (SOLRESPV.1);125.00 (SOLFILFEE) | 275 | 38.88091608 | -76.9434381 | 404907.71 | 134788.32 | 2928.0 | 7 | ANC 7E | 7E01 | SIXTH | 605 | Cluster 33 | 2026-08-18 | {59DCBB19-BF52-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140640957 | 2023 | |||||||||
| 142308651.0 | 2023-05-31 | E2308651 | SUPPLEMENTAL | ELECTRICAL | NA | PERMIT ISSUED | 4630 ALABAMA AVE SE, WASHINGTON, DC 20019 | 5390 0122 | R-2 | 20.00 (MISCITEM17);2.00 (ELECTRICEFEE) | 22 | 38.87995194 | -76.93953744 | 405246.23 | 134681.51 | 301910.0 | 7 | ANC 7E | 7E01 | SIXTH | 605 | Cluster 33 | 2026-08-14 | {59DCBB19-BF53-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140640958 | 2023 | |||||||||
| 142402073.0 | 2023-11-28 | E2402073 | SUPPLEMENTAL | ELECTRICAL | NA | PERMIT ISSUED | 725 ADRIAN ST SE, WASHINGTON, DC 20019 | 5391 0032 | R-2 | 79 | 38.88034422 | -76.94474307 | 404794.52 | 134724.77 | 77979.0 | 7 | ANC 7E | 7E01 | SIXTH | 605 | Cluster 33 | 2023-11-29 | {59DCBB19-BF54-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140640959 | 2023 | ||||||||||
| 251234200714.0 | 2023-10-18 | PC34200714 | POST CARD | BUILDING | NA | COMPLETED | 3620 13TH ST NW, WASHINGTON, DC 20010 | 2828 0077 | 33.00 (POSTCARD3);3.30 (BUILDEFEE) | 36 | 38.93530509 | -77.03001398 | 397397.76 | 140824.89 | 230272.0 | 1 | ANC 1A | 1A04 | FOURTH | 408 | Cluster 2 | 2026-08-14 | {59DCBB1A-3BE1-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140672844 | 2023 | ||||||||||
| 141108805.0 | 2023-03-26 | E1108805 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 90 K ST NE, WASHINGTON, DC 20002 | 0674 0853 | C-3-C | 52.00 (ELECTRICEFEE);520.00 (MISCITEM23) | 572 | 38.9028841 | -77.00658771 | 399428.58 | 137225.48 | 289039.0 | 6 | ANC 6E | 6E07 | FIFTH | 501 | Cluster 25 | NoMa BID | 2026-08-18 | {59DCBB1C-3567-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140802258 | 2023 | ||||||||
| 1411602621.0 | 2023-03-26 | E11602621 | SUPPLEMENTAL | ELECTRICAL | NA | COMPLETED | 4140 7TH ST NW, WASHINGTON, DC 20011 | 3135 0049 | 399 | 38.94177599 | -77.02189356 | 398101.98 | 141542.98 | 249712.0 | 4 | ANC 4C | 4C06 | FOURTH | 407 | Cluster 18 | 2023-03-31 | {59DCBB1C-3A5B-5195-E063-792F520A93BD} | 2026-08-25 | 2026-08-25 | 1140803526 | 2023 |
What is in the file172,942 rows pulled 26 Aug 2026
The file would be ONE of the five slices below, not all 172,942 rows. Washington DC publishes a building-permit table and overwrites it. We pulled 172,942 of those rows on 26 Aug 2026 and assembled them as one CSV, with person-name columns taken out. The five slices described here are 2026, 2025, 2024, 2023, all four years.
| Permit | Type | Issue date | Address | Status |
|---|---|---|---|---|
| G84339209 | SUPPLEMENTAL | 26 Mar 2023 | 124 11TH ST NE | NULL |
| P87288882 | SUPPLEMENTAL | 26 Mar 2023 | 1750 P ST NW | PERMIT ISSUED |
| P18631478 | SUPPLEMENTAL | 13 Feb 2023 | 500 21ST ST NE | COMPLETED |
| E1305804 | SUPPLEMENTAL | 26 Mar 2023 | 2400 EAST CAPITOL ST SE | EXPIRED |
| E59855397 | SUPPLEMENTAL | 26 Mar 2023 | 4604 43RD ST NW | COMPLETED |
| E12679369 | SUPPLEMENTAL | 26 Jul 2023 | 414 SHEPHERD ST NW | COMPLETED |
| E67433672 | SUPPLEMENTAL | 13 Jun 2023 | 1512 OKIE ST NE | COMPLETED |
| E27934306 | SUPPLEMENTAL | 26 Mar 2023 | 853 52ND ST NE | PERMIT ISSUED |
| G60667325 | SUPPLEMENTAL | 26 Mar 2023 | 901 MASSACHUSETTS AVE NW | COMPLETED |
| SOL2301239 | CONSTRUCTION | 26 Apr 2023 | 630 BURNS ST SE | EXPIRED |
| E2308651 | SUPPLEMENTAL | 31 May 2023 | 4630 ALABAMA AVE SE | PERMIT ISSUED |
| E2402073 | SUPPLEMENTAL | 28 Nov 2023 | 725 ADRIAN ST SE | PERMIT ISSUED |
Data retrieved from Open Data DC catalog (https://opendata.dc.gov)
Licence: Creative Commons Attribution 4.0 International (CC BY 4.0).
Person columns stripped (PERMIT_APPLICANT, OWNER_NAME, CREATED_USER, LAST_EDITED_USER). DESC_OF_WORK removed. Rows assembled into dated slices by USTechAutomations.
The underlying District data itself stays CC BY 4.0. The District's free portal remains at opendata.dc.gov.
172,942 is what we hold, not what the city has ever published. A row we did not pull is not in the file. The portal itself stays free.
Person columns are stripped. The outbound name guard refuses a paid file whose header names a person or a way to reach one. Those columns stay in the city's portal and stay out of what we would sell.
The city's own types in this extract5 values
These are the city's words, not ours. A type with no page of its own is still in the extract and still in the coverage page.
| City's permit type | Rows in this extract |
|---|---|
| SUPPLEMENTAL | 91,251 |
| CONSTRUCTION | 55,395 |
| POST CARD | 18,677 |
| HOME OCCUPATION | 5,944 |
| SHOP DRAWING | 1,675 |
What the file holds
- One CSV of one sliceThe same columns as the sample file, person-name fields taken out.
- The rows we actually pulled172,942 rows on 26 Aug 2026, issue dates 1 Jan 2023 to 17 Aug 2026.
- CC BY 4.0 attribution, in the fileThe same block as on this page, once, at the foot of the CSV.
Why you cannot buy it yet
Not on sale right now. Each file is currently sent by hand, so we have taken the pay button down. It comes back on sale when delivery is automatic. The sample above is free to open and read.
See the file we hold
You do not have to take our word for what is in the file. Here are 25 rows of the real thing, carrying all 38 of its columns, cut out of the dated copies we sealed ourselves. Nothing in it is made up and nothing in it is tidied up.
- Open the 25 rows as a CSVA plain spreadsheet file. It saves to your machine rather than painting itself into a browser tab, and it opens in Excel, Numbers or Google Sheets.
- The same 25 rows as JSONThe same rows again, laid out for reading with code.
Nothing on this page is for sale. The sample file is free to read, and so is every row on the page above it.
These 25 rows are a slice of the file, not the whole of it. What we cannot show you here is how far back it goes: the file goes back further than these rows do.
Not on sale right now
Not on sale right now. Each file is currently sent by hand, so we have taken the pay button down. It comes back on sale when delivery is automatic.
Email a questionNo payment is taken on this page.