ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 11001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499897 | 2499897 | 2022-05-13 | District of Columbia | District of Columbia | 11001 | 143943 | 1340 |
2496639 | 2496639 | 2022-05-12 | District of Columbia | District of Columbia | 11001 | 143943 | 1340 |
2493381 | 2493381 | 2022-05-11 | District of Columbia | District of Columbia | 11001 | 143005 | 1340 |
2490123 | 2490123 | 2022-05-10 | District of Columbia | District of Columbia | 11001 | 143005 | 1340 |
2486866 | 2486866 | 2022-05-09 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2483608 | 2483608 | 2022-05-08 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2480350 | 2480350 | 2022-05-07 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2477092 | 2477092 | 2022-05-06 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2473834 | 2473834 | 2022-05-05 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2470577 | 2470577 | 2022-05-04 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2467321 | 2467321 | 2022-05-03 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2464066 | 2464066 | 2022-05-02 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2460810 | 2460810 | 2022-05-01 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2457554 | 2457554 | 2022-04-30 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2454298 | 2454298 | 2022-04-29 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2451042 | 2451042 | 2022-04-28 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2447786 | 2447786 | 2022-04-27 | District of Columbia | District of Columbia | 11001 | 141943 | 1340 |
2444530 | 2444530 | 2022-04-26 | District of Columbia | District of Columbia | 11001 | 141355 | 1335 |
2441274 | 2441274 | 2022-04-25 | District of Columbia | District of Columbia | 11001 | 141355 | 1335 |
2438018 | 2438018 | 2022-04-24 | District of Columbia | District of Columbia | 11001 | 141355 | 1335 |
2434762 | 2434762 | 2022-04-23 | District of Columbia | District of Columbia | 11001 | 141355 | 1335 |
2431506 | 2431506 | 2022-04-22 | District of Columbia | District of Columbia | 11001 | 140845 | 1333 |
2428250 | 2428250 | 2022-04-21 | District of Columbia | District of Columbia | 11001 | 140845 | 1333 |
2424994 | 2424994 | 2022-04-20 | District of Columbia | District of Columbia | 11001 | 140674 | 1333 |
2421738 | 2421738 | 2022-04-19 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2418482 | 2418482 | 2022-04-18 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2415226 | 2415226 | 2022-04-17 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2411970 | 2411970 | 2022-04-16 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2408714 | 2408714 | 2022-04-15 | District of Columbia | District of Columbia | 11001 | 139772 | 1333 |
2405458 | 2405458 | 2022-04-14 | District of Columbia | District of Columbia | 11001 | 139160 | 1333 |
2402203 | 2402203 | 2022-04-13 | District of Columbia | District of Columbia | 11001 | 139160 | 1333 |
2398948 | 2398948 | 2022-04-12 | District of Columbia | District of Columbia | 11001 | 138939 | 1333 |
2395693 | 2395693 | 2022-04-11 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2392437 | 2392437 | 2022-04-10 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2389181 | 2389181 | 2022-04-09 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2385926 | 2385926 | 2022-04-08 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2382671 | 2382671 | 2022-04-07 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2379416 | 2379416 | 2022-04-06 | District of Columbia | District of Columbia | 11001 | 137603 | 1331 |
2376162 | 2376162 | 2022-04-05 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2372910 | 2372910 | 2022-04-04 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2369657 | 2369657 | 2022-04-03 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2366404 | 2366404 | 2022-04-02 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2363151 | 2363151 | 2022-04-01 | District of Columbia | District of Columbia | 11001 | 136886 | 1333 |
2359897 | 2359897 | 2022-03-31 | District of Columbia | District of Columbia | 11001 | 136598 | 1331 |
2356643 | 2356643 | 2022-03-30 | District of Columbia | District of Columbia | 11001 | 136598 | 1331 |
2353390 | 2353390 | 2022-03-29 | District of Columbia | District of Columbia | 11001 | 136506 | 1331 |
2350138 | 2350138 | 2022-03-28 | District of Columbia | District of Columbia | 11001 | 136322 | 1331 |
2346885 | 2346885 | 2022-03-27 | District of Columbia | District of Columbia | 11001 | 136322 | 1331 |
2343632 | 2343632 | 2022-03-26 | District of Columbia | District of Columbia | 11001 | 136322 | 1331 |
2340379 | 2340379 | 2022-03-25 | District of Columbia | District of Columbia | 11001 | 136213 | 1331 |
2337126 | 2337126 | 2022-03-24 | District of Columbia | District of Columbia | 11001 | 136062 | 1329 |
2333872 | 2333872 | 2022-03-23 | District of Columbia | District of Columbia | 11001 | 135955 | 1329 |
2330618 | 2330618 | 2022-03-22 | District of Columbia | District of Columbia | 11001 | 135884 | 1329 |
2327366 | 2327366 | 2022-03-21 | District of Columbia | District of Columbia | 11001 | 135752 | 1327 |
2324113 | 2324113 | 2022-03-20 | District of Columbia | District of Columbia | 11001 | 135752 | 1327 |
2320859 | 2320859 | 2022-03-19 | District of Columbia | District of Columbia | 11001 | 135752 | 1327 |
2317605 | 2317605 | 2022-03-18 | District of Columbia | District of Columbia | 11001 | 135681 | 1327 |
2314352 | 2314352 | 2022-03-17 | District of Columbia | District of Columbia | 11001 | 135575 | 1327 |
2311099 | 2311099 | 2022-03-16 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2307846 | 2307846 | 2022-03-15 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2304595 | 2304595 | 2022-03-14 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2301343 | 2301343 | 2022-03-13 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2298091 | 2298091 | 2022-03-12 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2294839 | 2294839 | 2022-03-11 | District of Columbia | District of Columbia | 11001 | 135223 | 1326 |
2291587 | 2291587 | 2022-03-10 | District of Columbia | District of Columbia | 11001 | 135086 | 1324 |
2288335 | 2288335 | 2022-03-09 | District of Columbia | District of Columbia | 11001 | 135086 | 1324 |
2285084 | 2285084 | 2022-03-08 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2281832 | 2281832 | 2022-03-07 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2278579 | 2278579 | 2022-03-06 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2275326 | 2275326 | 2022-03-05 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2272073 | 2272073 | 2022-03-04 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2268821 | 2268821 | 2022-03-03 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2265568 | 2265568 | 2022-03-02 | District of Columbia | District of Columbia | 11001 | 134678 | 1321 |
2262317 | 2262317 | 2022-03-01 | District of Columbia | District of Columbia | 11001 | 134623 | 1319 |
2259066 | 2259066 | 2022-02-28 | District of Columbia | District of Columbia | 11001 | 134564 | 1318 |
2255815 | 2255815 | 2022-02-27 | District of Columbia | District of Columbia | 11001 | 134326 | 1317 |
2252564 | 2252564 | 2022-02-26 | District of Columbia | District of Columbia | 11001 | 134326 | 1317 |
2249313 | 2249313 | 2022-02-25 | District of Columbia | District of Columbia | 11001 | 134326 | 1317 |
2246062 | 2246062 | 2022-02-24 | District of Columbia | District of Columbia | 11001 | 134214 | 1317 |
2242811 | 2242811 | 2022-02-23 | District of Columbia | District of Columbia | 11001 | 134114 | 1317 |
2239560 | 2239560 | 2022-02-22 | District of Columbia | District of Columbia | 11001 | 134066 | 1315 |
2236309 | 2236309 | 2022-02-21 | District of Columbia | District of Columbia | 11001 | 133697 | 1314 |
2233058 | 2233058 | 2022-02-20 | District of Columbia | District of Columbia | 11001 | 133697 | 1314 |
2229807 | 2229807 | 2022-02-19 | District of Columbia | District of Columbia | 11001 | 133697 | 1314 |
2226556 | 2226556 | 2022-02-18 | District of Columbia | District of Columbia | 11001 | 133697 | 1314 |
2223305 | 2223305 | 2022-02-17 | District of Columbia | District of Columbia | 11001 | 133587 | 1313 |
2220054 | 2220054 | 2022-02-16 | District of Columbia | District of Columbia | 11001 | 133459 | 1311 |
2216803 | 2216803 | 2022-02-15 | District of Columbia | District of Columbia | 11001 | 133339 | 1309 |
2213552 | 2213552 | 2022-02-14 | District of Columbia | District of Columbia | 11001 | 133295 | 1309 |
2210300 | 2210300 | 2022-02-13 | District of Columbia | District of Columbia | 11001 | 132820 | 1309 |
2207047 | 2207047 | 2022-02-12 | District of Columbia | District of Columbia | 11001 | 132820 | 1309 |
2203794 | 2203794 | 2022-02-11 | District of Columbia | District of Columbia | 11001 | 132820 | 1309 |
2200541 | 2200541 | 2022-02-10 | District of Columbia | District of Columbia | 11001 | 132628 | 1305 |
2197287 | 2197287 | 2022-02-09 | District of Columbia | District of Columbia | 11001 | 132384 | 1305 |
2194033 | 2194033 | 2022-02-08 | District of Columbia | District of Columbia | 11001 | 132257 | 1304 |
2190779 | 2190779 | 2022-02-07 | District of Columbia | District of Columbia | 11001 | 132170 | 1304 |
2187526 | 2187526 | 2022-02-06 | District of Columbia | District of Columbia | 11001 | 131543 | 1293 |
2184273 | 2184273 | 2022-02-05 | District of Columbia | District of Columbia | 11001 | 131543 | 1293 |
2181021 | 2181021 | 2022-02-04 | District of Columbia | District of Columbia | 11001 | 131543 | 1293 |
2177770 | 2177770 | 2022-02-03 | District of Columbia | District of Columbia | 11001 | 131284 | 1291 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);