ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
745 rows where deaths = 303 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 73
- Ohio 64
- North Dakota 60
- Texas 53
- Tennessee 47
- Michigan 31
- California 27
- Georgia 26
- Pennsylvania 26
- Virginia 26
- Alabama 25
- South Carolina 25
- Indiana 21
- Louisiana 18
- Florida 17
- Illinois 17
- Minnesota 15
- Mississippi 14
- New Hampshire 13
- Oklahoma 13
- Maryland 12
- Kentucky 11
- Wisconsin 11
- Arkansas 10
- Connecticut 10
- Massachusetts 10
- New Jersey 9
- Missouri 8
- New York 8
- Arizona 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501593 | 2501593 | 2022-05-13 | Burleigh | North Dakota | 38015 | 35087 | 303 |
2502440 | 2502440 | 2022-05-13 | Val Verde | Texas | 48465 | 14368 | 303 |
2498335 | 2498335 | 2022-05-12 | Burleigh | North Dakota | 38015 | 35021 | 303 |
2495077 | 2495077 | 2022-05-11 | Burleigh | North Dakota | 38015 | 35021 | 303 |
2491819 | 2491819 | 2022-05-10 | Burleigh | North Dakota | 38015 | 35021 | 303 |
2488437 | 2488437 | 2022-05-09 | Schenectady | New York | 36093 | 35040 | 303 |
2488561 | 2488561 | 2022-05-09 | Burleigh | North Dakota | 38015 | 35021 | 303 |
2485180 | 2485180 | 2022-05-08 | Schenectady | New York | 36093 | 34997 | 303 |
2485304 | 2485304 | 2022-05-08 | Burleigh | North Dakota | 38015 | 35021 | 303 |
2481922 | 2481922 | 2022-05-07 | Schenectady | New York | 36093 | 34909 | 303 |
2482046 | 2482046 | 2022-05-07 | Burleigh | North Dakota | 38015 | 35021 | 303 |
2478664 | 2478664 | 2022-05-06 | Schenectady | New York | 36093 | 34781 | 303 |
2478788 | 2478788 | 2022-05-06 | Burleigh | North Dakota | 38015 | 35021 | 303 |
2475406 | 2475406 | 2022-05-05 | Schenectady | New York | 36093 | 34676 | 303 |
2475530 | 2475530 | 2022-05-05 | Burleigh | North Dakota | 38015 | 34974 | 303 |
2472149 | 2472149 | 2022-05-04 | Schenectady | New York | 36093 | 34543 | 303 |
2472273 | 2472273 | 2022-05-04 | Burleigh | North Dakota | 38015 | 34974 | 303 |
2469007 | 2469007 | 2022-05-03 | Wilson | North Carolina | 37195 | 21753 | 303 |
2469017 | 2469017 | 2022-05-03 | Burleigh | North Dakota | 38015 | 34974 | 303 |
2464061 | 2464061 | 2022-05-02 | Windham | Connecticut | 9015 | 26157 | 303 |
2465751 | 2465751 | 2022-05-02 | Wilson | North Carolina | 37195 | 21753 | 303 |
2465761 | 2465761 | 2022-05-02 | Burleigh | North Dakota | 38015 | 34974 | 303 |
2460805 | 2460805 | 2022-05-01 | Windham | Connecticut | 9015 | 26099 | 303 |
2462289 | 2462289 | 2022-05-01 | Cape May | New Jersey | 34009 | 22330 | 303 |
2462496 | 2462496 | 2022-05-01 | Wilson | North Carolina | 37195 | 21753 | 303 |
2462506 | 2462506 | 2022-05-01 | Burleigh | North Dakota | 38015 | 34974 | 303 |
2457549 | 2457549 | 2022-04-30 | Windham | Connecticut | 9015 | 26099 | 303 |
2459033 | 2459033 | 2022-04-30 | Cape May | New Jersey | 34009 | 22312 | 303 |
2459240 | 2459240 | 2022-04-30 | Wilson | North Carolina | 37195 | 21753 | 303 |
2459250 | 2459250 | 2022-04-30 | Burleigh | North Dakota | 38015 | 34974 | 303 |
2454293 | 2454293 | 2022-04-29 | Windham | Connecticut | 9015 | 26099 | 303 |
2455777 | 2455777 | 2022-04-29 | Cape May | New Jersey | 34009 | 22286 | 303 |
2455984 | 2455984 | 2022-04-29 | Wilson | North Carolina | 37195 | 21753 | 303 |
2455994 | 2455994 | 2022-04-29 | Burleigh | North Dakota | 38015 | 34974 | 303 |
2452521 | 2452521 | 2022-04-28 | Cape May | New Jersey | 34009 | 22254 | 303 |
2452728 | 2452728 | 2022-04-28 | Wilson | North Carolina | 37195 | 21753 | 303 |
2452738 | 2452738 | 2022-04-28 | Burleigh | North Dakota | 38015 | 34951 | 303 |
2449265 | 2449265 | 2022-04-27 | Cape May | New Jersey | 34009 | 22218 | 303 |
2449472 | 2449472 | 2022-04-27 | Wilson | North Carolina | 37195 | 21753 | 303 |
2449482 | 2449482 | 2022-04-27 | Burleigh | North Dakota | 38015 | 34951 | 303 |
2446008 | 2446008 | 2022-04-26 | Cape May | New Jersey | 34009 | 22185 | 303 |
2446215 | 2446215 | 2022-04-26 | Wilson | North Carolina | 37195 | 21707 | 303 |
2446225 | 2446225 | 2022-04-26 | Burleigh | North Dakota | 38015 | 34951 | 303 |
2442960 | 2442960 | 2022-04-25 | Wilson | North Carolina | 37195 | 21707 | 303 |
2442970 | 2442970 | 2022-04-25 | Burleigh | North Dakota | 38015 | 34951 | 303 |
2439704 | 2439704 | 2022-04-24 | Wilson | North Carolina | 37195 | 21707 | 303 |
2439714 | 2439714 | 2022-04-24 | Burleigh | North Dakota | 38015 | 34951 | 303 |
2436448 | 2436448 | 2022-04-23 | Wilson | North Carolina | 37195 | 21707 | 303 |
2436458 | 2436458 | 2022-04-23 | Burleigh | North Dakota | 38015 | 34951 | 303 |
2433192 | 2433192 | 2022-04-22 | Wilson | North Carolina | 37195 | 21707 | 303 |
2433202 | 2433202 | 2022-04-22 | Burleigh | North Dakota | 38015 | 34951 | 303 |
2429936 | 2429936 | 2022-04-21 | Wilson | North Carolina | 37195 | 21707 | 303 |
2429946 | 2429946 | 2022-04-21 | Burleigh | North Dakota | 38015 | 34930 | 303 |
2426680 | 2426680 | 2022-04-20 | Wilson | North Carolina | 37195 | 21707 | 303 |
2426690 | 2426690 | 2022-04-20 | Burleigh | North Dakota | 38015 | 34930 | 303 |
2423424 | 2423424 | 2022-04-19 | Wilson | North Carolina | 37195 | 21656 | 303 |
2423434 | 2423434 | 2022-04-19 | Burleigh | North Dakota | 38015 | 34930 | 303 |
2424022 | 2424022 | 2022-04-19 | Putnam | Tennessee | 47141 | 25096 | 303 |
2420167 | 2420167 | 2022-04-18 | Wilson | North Carolina | 37195 | 21656 | 303 |
2420177 | 2420177 | 2022-04-18 | Burleigh | North Dakota | 38015 | 34930 | 303 |
2420766 | 2420766 | 2022-04-18 | Putnam | Tennessee | 47141 | 25096 | 303 |
2416912 | 2416912 | 2022-04-17 | Wilson | North Carolina | 37195 | 21656 | 303 |
2416922 | 2416922 | 2022-04-17 | Burleigh | North Dakota | 38015 | 34930 | 303 |
2417510 | 2417510 | 2022-04-17 | Putnam | Tennessee | 47141 | 25096 | 303 |
2413656 | 2413656 | 2022-04-16 | Wilson | North Carolina | 37195 | 21656 | 303 |
2413666 | 2413666 | 2022-04-16 | Burleigh | North Dakota | 38015 | 34930 | 303 |
2414254 | 2414254 | 2022-04-16 | Putnam | Tennessee | 47141 | 25096 | 303 |
2410400 | 2410400 | 2022-04-15 | Wilson | North Carolina | 37195 | 21656 | 303 |
2410410 | 2410410 | 2022-04-15 | Burleigh | North Dakota | 38015 | 34930 | 303 |
2410998 | 2410998 | 2022-04-15 | Putnam | Tennessee | 47141 | 25096 | 303 |
2407144 | 2407144 | 2022-04-14 | Wilson | North Carolina | 37195 | 21656 | 303 |
2407154 | 2407154 | 2022-04-14 | Burleigh | North Dakota | 38015 | 34905 | 303 |
2407742 | 2407742 | 2022-04-14 | Putnam | Tennessee | 47141 | 25096 | 303 |
2403888 | 2403888 | 2022-04-13 | Wilson | North Carolina | 37195 | 21656 | 303 |
2403898 | 2403898 | 2022-04-13 | Burleigh | North Dakota | 38015 | 34905 | 303 |
2403955 | 2403955 | 2022-04-13 | Belmont | Ohio | 39013 | 15667 | 303 |
2404486 | 2404486 | 2022-04-13 | Putnam | Tennessee | 47141 | 25096 | 303 |
2400633 | 2400633 | 2022-04-12 | Wilson | North Carolina | 37195 | 21621 | 303 |
2400643 | 2400643 | 2022-04-12 | Burleigh | North Dakota | 38015 | 34905 | 303 |
2400700 | 2400700 | 2022-04-12 | Belmont | Ohio | 39013 | 15667 | 303 |
2397378 | 2397378 | 2022-04-11 | Wilson | North Carolina | 37195 | 21621 | 303 |
2397388 | 2397388 | 2022-04-11 | Burleigh | North Dakota | 38015 | 34905 | 303 |
2397445 | 2397445 | 2022-04-11 | Belmont | Ohio | 39013 | 15667 | 303 |
2394123 | 2394123 | 2022-04-10 | Wilson | North Carolina | 37195 | 21621 | 303 |
2394133 | 2394133 | 2022-04-10 | Burleigh | North Dakota | 38015 | 34905 | 303 |
2394190 | 2394190 | 2022-04-10 | Belmont | Ohio | 39013 | 15667 | 303 |
2390867 | 2390867 | 2022-04-09 | Wilson | North Carolina | 37195 | 21621 | 303 |
2390877 | 2390877 | 2022-04-09 | Burleigh | North Dakota | 38015 | 34905 | 303 |
2390934 | 2390934 | 2022-04-09 | Belmont | Ohio | 39013 | 15667 | 303 |
2387611 | 2387611 | 2022-04-08 | Wilson | North Carolina | 37195 | 21621 | 303 |
2387621 | 2387621 | 2022-04-08 | Burleigh | North Dakota | 38015 | 34905 | 303 |
2387678 | 2387678 | 2022-04-08 | Belmont | Ohio | 39013 | 15667 | 303 |
2384356 | 2384356 | 2022-04-07 | Wilson | North Carolina | 37195 | 21621 | 303 |
2384366 | 2384366 | 2022-04-07 | Burleigh | North Dakota | 38015 | 34886 | 303 |
2384423 | 2384423 | 2022-04-07 | Belmont | Ohio | 39013 | 15667 | 303 |
2381101 | 2381101 | 2022-04-06 | Wilson | North Carolina | 37195 | 21621 | 303 |
2381111 | 2381111 | 2022-04-06 | Burleigh | North Dakota | 38015 | 34886 | 303 |
2377846 | 2377846 | 2022-04-05 | Wilson | North Carolina | 37195 | 21616 | 303 |
2377856 | 2377856 | 2022-04-05 | Burleigh | North Dakota | 38015 | 34886 | 303 |
2374593 | 2374593 | 2022-04-04 | Wilson | North Carolina | 37195 | 21611 | 303 |
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);