ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where deaths = 891 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- New York 45
- Florida 24
- Pennsylvania 24
- New Jersey 10
- Texas 10
- Georgia 8
- California 6
- Louisiana 5
- Oregon 5
- Minnesota 2
- Missouri 2
- New Hampshire 2
- Utah 2
- Alabama 1
- Arizona 1
- Arkansas 1
- Colorado 1
- Idaho 1
- Illinois 1
- Indiana 1
- Massachusetts 1
- North Carolina 1
- South Carolina 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467510 | 2467510 | 2022-05-03 | Richmond | Georgia | 13245 | 50396 | 891 |
2464255 | 2464255 | 2022-05-02 | Richmond | Georgia | 13245 | 50396 | 891 |
2460999 | 2460999 | 2022-05-01 | Richmond | Georgia | 13245 | 50394 | 891 |
2457743 | 2457743 | 2022-04-30 | Richmond | Georgia | 13245 | 50394 | 891 |
2454487 | 2454487 | 2022-04-29 | Richmond | Georgia | 13245 | 50394 | 891 |
2451231 | 2451231 | 2022-04-28 | Richmond | Georgia | 13245 | 50394 | 891 |
2447975 | 2447975 | 2022-04-27 | Richmond | Georgia | 13245 | 50394 | 891 |
2449756 | 2449756 | 2022-04-27 | Cumberland | Pennsylvania | 42041 | 51202 | 891 |
2446499 | 2446499 | 2022-04-26 | Cumberland | Pennsylvania | 42041 | 51185 | 891 |
2443244 | 2443244 | 2022-04-25 | Cumberland | Pennsylvania | 42041 | 51166 | 891 |
2439988 | 2439988 | 2022-04-24 | Cumberland | Pennsylvania | 42041 | 51146 | 891 |
2436732 | 2436732 | 2022-04-23 | Cumberland | Pennsylvania | 42041 | 51136 | 891 |
2433476 | 2433476 | 2022-04-22 | Cumberland | Pennsylvania | 42041 | 51104 | 891 |
2430220 | 2430220 | 2022-04-21 | Cumberland | Pennsylvania | 42041 | 51082 | 891 |
2426964 | 2426964 | 2022-04-20 | Cumberland | Pennsylvania | 42041 | 51066 | 891 |
2423308 | 2423308 | 2022-04-19 | Rockland | New York | 36087 | 93483 | 891 |
2423708 | 2423708 | 2022-04-19 | Cumberland | Pennsylvania | 42041 | 51049 | 891 |
2420051 | 2420051 | 2022-04-18 | Rockland | New York | 36087 | 93413 | 891 |
2420452 | 2420452 | 2022-04-18 | Cumberland | Pennsylvania | 42041 | 51040 | 891 |
2416796 | 2416796 | 2022-04-17 | Rockland | New York | 36087 | 93347 | 891 |
2417196 | 2417196 | 2022-04-17 | Cumberland | Pennsylvania | 42041 | 51031 | 891 |
2413540 | 2413540 | 2022-04-16 | Rockland | New York | 36087 | 93286 | 891 |
2413940 | 2413940 | 2022-04-16 | Cumberland | Pennsylvania | 42041 | 51023 | 891 |
2410284 | 2410284 | 2022-04-15 | Rockland | New York | 36087 | 93194 | 891 |
2410684 | 2410684 | 2022-04-15 | Cumberland | Pennsylvania | 42041 | 51009 | 891 |
2407028 | 2407028 | 2022-04-14 | Rockland | New York | 36087 | 93103 | 891 |
2407428 | 2407428 | 2022-04-14 | Cumberland | Pennsylvania | 42041 | 50986 | 891 |
2403772 | 2403772 | 2022-04-13 | Rockland | New York | 36087 | 93010 | 891 |
2404172 | 2404172 | 2022-04-13 | Cumberland | Pennsylvania | 42041 | 50964 | 891 |
2400517 | 2400517 | 2022-04-12 | Rockland | New York | 36087 | 92905 | 891 |
2400917 | 2400917 | 2022-04-12 | Cumberland | Pennsylvania | 42041 | 50953 | 891 |
2397262 | 2397262 | 2022-04-11 | Rockland | New York | 36087 | 92841 | 891 |
2394007 | 2394007 | 2022-04-10 | Rockland | New York | 36087 | 92783 | 891 |
2390751 | 2390751 | 2022-04-09 | Rockland | New York | 36087 | 92705 | 891 |
2387495 | 2387495 | 2022-04-08 | Rockland | New York | 36087 | 92620 | 891 |
2384240 | 2384240 | 2022-04-07 | Rockland | New York | 36087 | 92550 | 891 |
2380985 | 2380985 | 2022-04-06 | Rockland | New York | 36087 | 92460 | 891 |
2377730 | 2377730 | 2022-04-05 | Rockland | New York | 36087 | 92405 | 891 |
2374477 | 2374477 | 2022-04-04 | Rockland | New York | 36087 | 92377 | 891 |
2371225 | 2371225 | 2022-04-03 | Rockland | New York | 36087 | 92343 | 891 |
2367972 | 2367972 | 2022-04-02 | Rockland | New York | 36087 | 92283 | 891 |
2364719 | 2364719 | 2022-04-01 | Rockland | New York | 36087 | 92205 | 891 |
2361465 | 2361465 | 2022-03-31 | Rockland | New York | 36087 | 92126 | 891 |
2358211 | 2358211 | 2022-03-30 | Rockland | New York | 36087 | 92056 | 891 |
2354957 | 2354957 | 2022-03-29 | Rockland | New York | 36087 | 92011 | 891 |
2351704 | 2351704 | 2022-03-28 | Rockland | New York | 36087 | 91979 | 891 |
2348452 | 2348452 | 2022-03-27 | Rockland | New York | 36087 | 91947 | 891 |
2345199 | 2345199 | 2022-03-26 | Rockland | New York | 36087 | 91906 | 891 |
2341946 | 2341946 | 2022-03-25 | Rockland | New York | 36087 | 91871 | 891 |
2338693 | 2338693 | 2022-03-24 | Rockland | New York | 36087 | 91830 | 891 |
2335339 | 2335339 | 2022-03-23 | Hillsborough | New Hampshire | 33011 | 96490 | 891 |
2335439 | 2335439 | 2022-03-23 | Rockland | New York | 36087 | 91787 | 891 |
2332085 | 2332085 | 2022-03-22 | Hillsborough | New Hampshire | 33011 | 96408 | 891 |
2332185 | 2332185 | 2022-03-22 | Rockland | New York | 36087 | 91739 | 891 |
2328932 | 2328932 | 2022-03-21 | Rockland | New York | 36087 | 91718 | 891 |
2325680 | 2325680 | 2022-03-20 | Rockland | New York | 36087 | 91700 | 891 |
2322427 | 2322427 | 2022-03-19 | Rockland | New York | 36087 | 91671 | 891 |
2319173 | 2319173 | 2022-03-18 | Rockland | New York | 36087 | 91629 | 891 |
2315919 | 2315919 | 2022-03-17 | Rockland | New York | 36087 | 91600 | 891 |
2312666 | 2312666 | 2022-03-16 | Rockland | New York | 36087 | 91531 | 891 |
2313766 | 2313766 | 2022-03-16 | Henrico | Virginia | 51087 | 63759 | 891 |
2309413 | 2309413 | 2022-03-15 | Rockland | New York | 36087 | 91503 | 891 |
2306160 | 2306160 | 2022-03-14 | Rockland | New York | 36087 | 91475 | 891 |
2302909 | 2302909 | 2022-03-13 | Rockland | New York | 36087 | 91460 | 891 |
2299657 | 2299657 | 2022-03-12 | Rockland | New York | 36087 | 91442 | 891 |
2296405 | 2296405 | 2022-03-11 | Rockland | New York | 36087 | 91415 | 891 |
2297305 | 2297305 | 2022-03-11 | McLennan | Texas | 48309 | 56795 | 891 |
2294053 | 2294053 | 2022-03-10 | McLennan | Texas | 48309 | 56731 | 891 |
2288063 | 2288063 | 2022-03-09 | Montgomery | Alabama | 1101 | 54517 | 891 |
2290801 | 2290801 | 2022-03-09 | McLennan | Texas | 48309 | 56677 | 891 |
2287549 | 2287549 | 2022-03-08 | McLennan | Texas | 48309 | 56631 | 891 |
2284297 | 2284297 | 2022-03-07 | McLennan | Texas | 48309 | 56589 | 891 |
2281045 | 2281045 | 2022-03-06 | McLennan | Texas | 48309 | 56576 | 891 |
2277792 | 2277792 | 2022-03-05 | McLennan | Texas | 48309 | 56572 | 891 |
2216812 | 2216812 | 2022-02-15 | Citrus | Florida | 12017 | 28654 | 891 |
2213561 | 2213561 | 2022-02-14 | Citrus | Florida | 12017 | 28654 | 891 |
2210309 | 2210309 | 2022-02-13 | Citrus | Florida | 12017 | 28654 | 891 |
2207056 | 2207056 | 2022-02-12 | Citrus | Florida | 12017 | 28654 | 891 |
2203803 | 2203803 | 2022-02-11 | Citrus | Florida | 12017 | 28654 | 891 |
2200550 | 2200550 | 2022-02-10 | Citrus | Florida | 12017 | 27941 | 891 |
2197296 | 2197296 | 2022-02-09 | Citrus | Florida | 12017 | 27941 | 891 |
2146706 | 2146706 | 2022-01-24 | Atlantic | New Jersey | 34001 | 64499 | 891 |
2143451 | 2143451 | 2022-01-23 | Atlantic | New Jersey | 34001 | 64317 | 891 |
2140285 | 2140285 | 2022-01-22 | Orange | New York | 36071 | 100622 | 891 |
2137794 | 2137794 | 2022-01-21 | Brazoria | Texas | 48039 | 84607 | 891 |
2125946 | 2125946 | 2022-01-18 | Ada | Idaho | 16001 | 95547 | 891 |
2084997 | 2084997 | 2022-01-05 | Onondaga | New York | 36067 | 76730 | 891 |
2081745 | 2081745 | 2022-01-04 | Onondaga | New York | 36067 | 74960 | 891 |
2078493 | 2078493 | 2022-01-03 | Onondaga | New York | 36067 | 73874 | 891 |
2033368 | 2033368 | 2021-12-20 | Multnomah | Oregon | 41051 | 62698 | 891 |
2030118 | 2030118 | 2021-12-19 | Multnomah | Oregon | 41051 | 62375 | 891 |
2026867 | 2026867 | 2021-12-18 | Multnomah | Oregon | 41051 | 62375 | 891 |
2023616 | 2023616 | 2021-12-17 | Multnomah | Oregon | 41051 | 62375 | 891 |
2020365 | 2020365 | 2021-12-16 | Multnomah | Oregon | 41051 | 62173 | 891 |
2008736 | 2008736 | 2021-12-13 | Seminole | Florida | 12117 | 63663 | 891 |
2005485 | 2005485 | 2021-12-12 | Seminole | Florida | 12117 | 63663 | 891 |
2002234 | 2002234 | 2021-12-11 | Seminole | Florida | 12117 | 63663 | 891 |
1998984 | 1998984 | 2021-12-10 | Seminole | Florida | 12117 | 63663 | 891 |
1995733 | 1995733 | 2021-12-09 | Seminole | Florida | 12117 | 63412 | 891 |
1992482 | 1992482 | 2021-12-08 | Seminole | Florida | 12117 | 63412 | 891 |
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);