ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where deaths = 1215 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Georgia 14
- Florida 11
- Missouri 8
- Kansas 7
- New Jersey 6
- Massachusetts 4
- Pennsylvania 3
- Wisconsin 3
- South Carolina 2
- Washington 2
- California 1
- Connecticut 1
- Illinois 1
- Indiana 1
- Maryland 1
- Michigan 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497865 | 2497865 | 2022-05-12 | Jackson | Missouri | 29095 | 96783 | 1215 |
2494607 | 2494607 | 2022-05-11 | Jackson | Missouri | 29095 | 96783 | 1215 |
2491349 | 2491349 | 2022-05-10 | Jackson | Missouri | 29095 | 96783 | 1215 |
2487487 | 2487487 | 2022-05-09 | Johnson | Kansas | 20091 | 147803 | 1215 |
2488091 | 2488091 | 2022-05-09 | Jackson | Missouri | 29095 | 96783 | 1215 |
2484229 | 2484229 | 2022-05-08 | Johnson | Kansas | 20091 | 147803 | 1215 |
2484834 | 2484834 | 2022-05-08 | Jackson | Missouri | 29095 | 96783 | 1215 |
2480971 | 2480971 | 2022-05-07 | Johnson | Kansas | 20091 | 147803 | 1215 |
2481576 | 2481576 | 2022-05-07 | Jackson | Missouri | 29095 | 96783 | 1215 |
2477713 | 2477713 | 2022-05-06 | Johnson | Kansas | 20091 | 147803 | 1215 |
2478318 | 2478318 | 2022-05-06 | Jackson | Missouri | 29095 | 96783 | 1215 |
2474455 | 2474455 | 2022-05-05 | Johnson | Kansas | 20091 | 146955 | 1215 |
2471198 | 2471198 | 2022-05-04 | Johnson | Kansas | 20091 | 146955 | 1215 |
2467942 | 2467942 | 2022-05-03 | Johnson | Kansas | 20091 | 146955 | 1215 |
2421797 | 2421797 | 2022-04-19 | St. Lucie | Florida | 12111 | 74163 | 1215 |
2418541 | 2418541 | 2022-04-18 | St. Lucie | Florida | 12111 | 74163 | 1215 |
2415285 | 2415285 | 2022-04-17 | St. Lucie | Florida | 12111 | 74163 | 1215 |
2412029 | 2412029 | 2022-04-16 | St. Lucie | Florida | 12111 | 74163 | 1215 |
2408773 | 2408773 | 2022-04-15 | St. Lucie | Florida | 12111 | 74163 | 1215 |
2405517 | 2405517 | 2022-04-14 | St. Lucie | Florida | 12111 | 74163 | 1215 |
2402262 | 2402262 | 2022-04-13 | St. Lucie | Florida | 12111 | 74163 | 1215 |
2202022 | 2202022 | 2022-02-10 | Mercer | New Jersey | 34021 | 73554 | 1215 |
2203309 | 2203309 | 2022-02-10 | Pierce | Washington | 53053 | 181278 | 1215 |
2200055 | 2200055 | 2022-02-09 | Pierce | Washington | 53053 | 181278 | 1215 |
2150496 | 2150496 | 2022-01-25 | Westmoreland | Pennsylvania | 42129 | 73082 | 1215 |
2108843 | 2108843 | 2022-01-12 | Fairfax | Virginia | 51059 | 143380 | 1215 |
2057762 | 2057762 | 2021-12-28 | Lake | Illinois | 17097 | 99162 | 1215 |
1978123 | 1978123 | 2021-12-03 | Berks | Pennsylvania | 42011 | 65636 | 1215 |
1906804 | 1906804 | 2021-11-11 | Spartanburg | South Carolina | 45083 | 62309 | 1215 |
1903555 | 1903555 | 2021-11-10 | Spartanburg | South Carolina | 45083 | 62309 | 1215 |
1849857 | 1849857 | 2021-10-25 | Lake | Indiana | 18089 | 66710 | 1215 |
1727938 | 1727938 | 2021-09-17 | Lancaster | Pennsylvania | 42071 | 62809 | 1215 |
1563674 | 1563674 | 2021-07-29 | Gwinnett | Georgia | 13135 | 105888 | 1215 |
1560426 | 1560426 | 2021-07-28 | Gwinnett | Georgia | 13135 | 105692 | 1215 |
1557179 | 1557179 | 2021-07-27 | Gwinnett | Georgia | 13135 | 105481 | 1215 |
1553932 | 1553932 | 2021-07-26 | Gwinnett | Georgia | 13135 | 105261 | 1215 |
1550685 | 1550685 | 2021-07-25 | Gwinnett | Georgia | 13135 | 104915 | 1215 |
1547438 | 1547438 | 2021-07-24 | Gwinnett | Georgia | 13135 | 104915 | 1215 |
1544191 | 1544191 | 2021-07-23 | Gwinnett | Georgia | 13135 | 104915 | 1215 |
1540943 | 1540943 | 2021-07-22 | Gwinnett | Georgia | 13135 | 104762 | 1215 |
1537696 | 1537696 | 2021-07-21 | Gwinnett | Georgia | 13135 | 104658 | 1215 |
1534448 | 1534448 | 2021-07-20 | Gwinnett | Georgia | 13135 | 104520 | 1215 |
1531201 | 1531201 | 2021-07-19 | Gwinnett | Georgia | 13135 | 104432 | 1215 |
1527954 | 1527954 | 2021-07-18 | Gwinnett | Georgia | 13135 | 104217 | 1215 |
1524707 | 1524707 | 2021-07-17 | Gwinnett | Georgia | 13135 | 104217 | 1215 |
1521459 | 1521459 | 2021-07-16 | Gwinnett | Georgia | 13135 | 104217 | 1215 |
1289087 | 1289087 | 2021-05-05 | Morris | New Jersey | 34027 | 49696 | 1215 |
1285841 | 1285841 | 2021-05-04 | Morris | New Jersey | 34027 | 49652 | 1215 |
1282595 | 1282595 | 2021-05-03 | Morris | New Jersey | 34027 | 49590 | 1215 |
1219463 | 1219463 | 2021-04-14 | Orange | Florida | 12095 | 129838 | 1215 |
1155932 | 1155932 | 2021-03-25 | Camden | New Jersey | 34007 | 47701 | 1215 |
1022253 | 1022253 | 2021-02-12 | Baltimore | Maryland | 24005 | 49145 | 1215 |
1011259 | 1011259 | 2021-02-08 | Milwaukee | Wisconsin | 55079 | 104793 | 1215 |
1008013 | 1008013 | 2021-02-07 | Milwaukee | Wisconsin | 55079 | 104715 | 1215 |
1004767 | 1004767 | 2021-02-06 | Milwaukee | Wisconsin | 55079 | 104592 | 1215 |
996318 | 996318 | 2021-02-04 | Hampden | Massachusetts | 25013 | 37911 | 1215 |
949996 | 949996 | 2021-01-21 | Hillsborough | Florida | 12057 | 94870 | 1215 |
837660 | 837660 | 2020-12-17 | St. Louis | Missouri | 29189 | 62531 | 1215 |
820051 | 820051 | 2020-12-12 | San Bernardino | California | 6071 | 124264 | 1215 |
743179 | 743179 | 2020-11-18 | Suffolk | Massachusetts | 25025 | 33695 | 1215 |
613486 | 613486 | 2020-10-09 | Oakland | Michigan | 26125 | 21730 | 1215 |
537051 | 537051 | 2020-09-15 | Bexar | Texas | 48029 | 50143 | 1215 |
505635 | 505635 | 2020-09-06 | Broward | Florida | 12011 | 73293 | 1215 |
502401 | 502401 | 2020-09-05 | Broward | Florida | 12011 | 73112 | 1215 |
461280 | 461280 | 2020-08-23 | Essex | Massachusetts | 25009 | 18430 | 1215 |
458053 | 458053 | 2020-08-22 | Essex | Massachusetts | 25009 | 18430 | 1215 |
172702 | 172702 | 2020-05-24 | Fairfield | Connecticut | 9001 | 15114 | 1215 |
114102 | 114102 | 2020-05-04 | Bergen | New Jersey | 34003 | 16282 | 1215 |
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);