ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
146 rows where deaths = 909 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- California 29
- Ohio 19
- Arizona 12
- New Jersey 8
- Missouri 7
- New Mexico 7
- Rhode Island 7
- Colorado 6
- Illinois 6
- Maryland 6
- Pennsylvania 5
- Texas 5
- Arkansas 4
- Louisiana 4
- South Carolina 4
- Alabama 2
- Florida 2
- Indiana 2
- Minnesota 2
- North Carolina 2
- Connecticut 1
- Delaware 1
- District of Columbia 1
- Kentucky 1
- Massachusetts 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499680 | 2499680 | 2022-05-13 | Navajo | Arizona | 4017 | 38394 | 909 |
2496422 | 2496422 | 2022-05-12 | Navajo | Arizona | 4017 | 38394 | 909 |
2493164 | 2493164 | 2022-05-11 | Navajo | Arizona | 4017 | 38394 | 909 |
2473711 | 2473711 | 2022-05-05 | Imperial | California | 6025 | 66511 | 909 |
2470454 | 2470454 | 2022-05-04 | Imperial | California | 6025 | 66511 | 909 |
2467198 | 2467198 | 2022-05-03 | Imperial | California | 6025 | 66511 | 909 |
2463943 | 2463943 | 2022-05-02 | Imperial | California | 6025 | 66466 | 909 |
2460687 | 2460687 | 2022-05-01 | Imperial | California | 6025 | 66466 | 909 |
2457431 | 2457431 | 2022-04-30 | Imperial | California | 6025 | 66466 | 909 |
2454175 | 2454175 | 2022-04-29 | Imperial | California | 6025 | 66466 | 909 |
2450919 | 2450919 | 2022-04-28 | Imperial | California | 6025 | 66925 | 909 |
2447663 | 2447663 | 2022-04-27 | Imperial | California | 6025 | 66925 | 909 |
2444407 | 2444407 | 2022-04-26 | Imperial | California | 6025 | 66925 | 909 |
2441151 | 2441151 | 2022-04-25 | Imperial | California | 6025 | 66879 | 909 |
2437895 | 2437895 | 2022-04-24 | Imperial | California | 6025 | 66879 | 909 |
2434639 | 2434639 | 2022-04-23 | Imperial | California | 6025 | 66879 | 909 |
2431383 | 2431383 | 2022-04-22 | Imperial | California | 6025 | 66879 | 909 |
2428127 | 2428127 | 2022-04-21 | Imperial | California | 6025 | 66723 | 909 |
2424871 | 2424871 | 2022-04-20 | Imperial | California | 6025 | 66723 | 909 |
2421615 | 2421615 | 2022-04-19 | Imperial | California | 6025 | 66723 | 909 |
2418359 | 2418359 | 2022-04-18 | Imperial | California | 6025 | 66689 | 909 |
2415103 | 2415103 | 2022-04-17 | Imperial | California | 6025 | 66689 | 909 |
2411847 | 2411847 | 2022-04-16 | Imperial | California | 6025 | 66689 | 909 |
2408591 | 2408591 | 2022-04-15 | Imperial | California | 6025 | 66689 | 909 |
2405335 | 2405335 | 2022-04-14 | Imperial | California | 6025 | 66671 | 909 |
2402080 | 2402080 | 2022-04-13 | Imperial | California | 6025 | 66395 | 909 |
2398825 | 2398825 | 2022-04-12 | Imperial | California | 6025 | 66395 | 909 |
2395570 | 2395570 | 2022-04-11 | Imperial | California | 6025 | 66395 | 909 |
2392314 | 2392314 | 2022-04-10 | Imperial | California | 6025 | 66395 | 909 |
2389058 | 2389058 | 2022-04-09 | Imperial | California | 6025 | 66395 | 909 |
2385803 | 2385803 | 2022-04-08 | Imperial | California | 6025 | 66395 | 909 |
2310827 | 2310827 | 2022-03-16 | Montgomery | Alabama | 1101 | 54575 | 909 |
2307574 | 2307574 | 2022-03-15 | Montgomery | Alabama | 1101 | 54563 | 909 |
2214766 | 2214766 | 2022-02-14 | Greene | Missouri | 29077 | 69371 | 909 |
2211514 | 2211514 | 2022-02-13 | Greene | Missouri | 29077 | 69082 | 909 |
2208261 | 2208261 | 2022-02-12 | Greene | Missouri | 29077 | 69082 | 909 |
2205008 | 2205008 | 2022-02-11 | Greene | Missouri | 29077 | 69082 | 909 |
2201755 | 2201755 | 2022-02-10 | Greene | Missouri | 29077 | 68884 | 909 |
2198501 | 2198501 | 2022-02-09 | Greene | Missouri | 29077 | 68701 | 909 |
2195247 | 2195247 | 2022-02-08 | Greene | Missouri | 29077 | 68547 | 909 |
2160572 | 2160572 | 2022-01-28 | Brazoria | Texas | 48039 | 87650 | 909 |
2124249 | 2124249 | 2022-01-17 | Mahoning | Ohio | 39099 | 49735 | 909 |
2120997 | 2120997 | 2022-01-16 | Mahoning | Ohio | 39099 | 49325 | 909 |
2117745 | 2117745 | 2022-01-15 | Mahoning | Ohio | 39099 | 48842 | 909 |
2114494 | 2114494 | 2022-01-14 | Mahoning | Ohio | 39099 | 47700 | 909 |
2101447 | 2101447 | 2022-01-10 | Butler | Ohio | 39017 | 70018 | 909 |
2098196 | 2098196 | 2022-01-09 | Butler | Ohio | 39017 | 69440 | 909 |
2094944 | 2094944 | 2022-01-08 | Butler | Ohio | 39017 | 68779 | 909 |
2091692 | 2091692 | 2022-01-07 | Butler | Ohio | 39017 | 68213 | 909 |
2084928 | 2084928 | 2022-01-05 | Somerset | New Jersey | 34035 | 52289 | 909 |
2081676 | 2081676 | 2022-01-04 | Somerset | New Jersey | 34035 | 50965 | 909 |
1986308 | 1986308 | 2021-12-06 | Allen | Indiana | 18003 | 68064 | 909 |
1984795 | 1984795 | 2021-12-05 | Horry | South Carolina | 45051 | 63869 | 909 |
1981545 | 1981545 | 2021-12-04 | Horry | South Carolina | 45051 | 63869 | 909 |
1978295 | 1978295 | 2021-12-03 | Horry | South Carolina | 45051 | 63869 | 909 |
1974882 | 1974882 | 2021-12-02 | Chester | Pennsylvania | 42029 | 55993 | 909 |
1975045 | 1975045 | 2021-12-02 | Horry | South Carolina | 45051 | 63791 | 909 |
1944038 | 1944038 | 2021-11-23 | Unknown | Illinois | 0 | 909 | |
1925840 | 1925840 | 2021-11-17 | Wake | North Carolina | 37183 | 134024 | 909 |
1922591 | 1922591 | 2021-11-16 | Wake | North Carolina | 37183 | 133667 | 909 |
1875209 | 1875209 | 2021-11-02 | Yuma | Arizona | 4027 | 41707 | 909 |
1871960 | 1871960 | 2021-11-01 | Yuma | Arizona | 4027 | 41680 | 909 |
1872020 | 1872020 | 2021-11-01 | Pulaski | Arkansas | 5119 | 58841 | 909 |
1868711 | 1868711 | 2021-10-31 | Yuma | Arizona | 4027 | 41645 | 909 |
1868771 | 1868771 | 2021-10-31 | Pulaski | Arkansas | 5119 | 58826 | 909 |
1865462 | 1865462 | 2021-10-30 | Yuma | Arizona | 4027 | 41588 | 909 |
1865522 | 1865522 | 2021-10-30 | Pulaski | Arkansas | 5119 | 58798 | 909 |
1862213 | 1862213 | 2021-10-29 | Yuma | Arizona | 4027 | 41554 | 909 |
1859024 | 1859024 | 2021-10-28 | Pulaski | Arkansas | 5119 | 58725 | 909 |
1790732 | 1790732 | 2021-10-07 | Yuma | Arizona | 4027 | 40920 | 909 |
1787483 | 1787483 | 2021-10-06 | Yuma | Arizona | 4027 | 40893 | 909 |
1784234 | 1784234 | 2021-10-05 | Yuma | Arizona | 4027 | 40864 | 909 |
1784385 | 1784385 | 2021-10-05 | Denver | Colorado | 8031 | 86737 | 909 |
1781136 | 1781136 | 2021-10-04 | Denver | Colorado | 8031 | 86475 | 909 |
1778271 | 1778271 | 2021-10-03 | Kane | Illinois | 17089 | 66733 | 909 |
1775021 | 1775021 | 2021-10-02 | Kane | Illinois | 17089 | 66733 | 909 |
1771771 | 1771771 | 2021-10-01 | Kane | Illinois | 17089 | 66733 | 909 |
1768522 | 1768522 | 2021-09-30 | Kane | Illinois | 17089 | 66595 | 909 |
1765273 | 1765273 | 2021-09-29 | Kane | Illinois | 17089 | 66507 | 909 |
1741990 | 1741990 | 2021-09-22 | Mohave | Arizona | 4015 | 30534 | 909 |
1717687 | 1717687 | 2021-09-14 | Burlington | New Jersey | 34005 | 50120 | 909 |
1714439 | 1714439 | 2021-09-13 | Burlington | New Jersey | 34005 | 50030 | 909 |
1691065 | 1691065 | 2021-09-06 | Orleans | Louisiana | 22071 | 44037 | 909 |
1687815 | 1687815 | 2021-09-05 | Orleans | Louisiana | 22071 | 44037 | 909 |
1684565 | 1684565 | 2021-09-04 | Orleans | Louisiana | 22071 | 44037 | 909 |
1681314 | 1681314 | 2021-09-03 | Orleans | Louisiana | 22071 | 44037 | 909 |
1679576 | 1679576 | 2021-09-02 | Collin | Texas | 48085 | 111426 | 909 |
1625258 | 1625258 | 2021-08-17 | New Castle | Delaware | 10003 | 67618 | 909 |
1624493 | 1624493 | 2021-08-16 | Nueces | Texas | 48355 | 48204 | 909 |
1586222 | 1586222 | 2021-08-05 | El Paso | Colorado | 8041 | 77258 | 909 |
1582972 | 1582972 | 2021-08-04 | El Paso | Colorado | 8041 | 77024 | 909 |
1579722 | 1579722 | 2021-08-03 | El Paso | Colorado | 8041 | 76758 | 909 |
1576474 | 1576474 | 2021-08-02 | El Paso | Colorado | 8041 | 76581 | 909 |
1515894 | 1515894 | 2021-07-14 | Ramsey | Minnesota | 27123 | 52755 | 909 |
1458971 | 1458971 | 2021-06-26 | Salt Lake | Utah | 49035 | 153320 | 909 |
1328375 | 1328375 | 2021-05-17 | Stark | Ohio | 39151 | 32661 | 909 |
1325129 | 1325129 | 2021-05-16 | Stark | Ohio | 39151 | 32623 | 909 |
1321883 | 1321883 | 2021-05-15 | Stark | Ohio | 39151 | 32589 | 909 |
1318637 | 1318637 | 2021-05-14 | Stark | Ohio | 39151 | 32544 | 909 |
1237469 | 1237469 | 2021-04-19 | Summit | Ohio | 39153 | 45557 | 909 |
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);