ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
893 rows where deaths = 267 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 58
- Virginia 54
- North Carolina 53
- Florida 51
- Georgia 51
- Illinois 50
- Michigan 50
- Texas 47
- California 45
- Ohio 41
- Alabama 30
- Pennsylvania 30
- Wisconsin 26
- Louisiana 24
- Indiana 23
- New Mexico 23
- South Carolina 23
- Arkansas 20
- New Jersey 20
- Maryland 16
- Mississippi 16
- Colorado 15
- Oregon 14
- Washington 14
- Kentucky 12
- Arizona 10
- West Virginia 10
- Missouri 9
- New York 9
- Nebraska 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501665 | 2501665 | 2022-05-13 | Erie | Ohio | 39043 | 19730 | 267 |
2502126 | 2502126 | 2022-05-13 | Coffee | Tennessee | 47031 | 16994 | 267 |
2502583 | 2502583 | 2022-05-13 | Lynchburg city | Virginia | 51680 | 19760 | 267 |
2498407 | 2498407 | 2022-05-12 | Erie | Ohio | 39043 | 19730 | 267 |
2498868 | 2498868 | 2022-05-12 | Coffee | Tennessee | 47031 | 16994 | 267 |
2499325 | 2499325 | 2022-05-12 | Lynchburg city | Virginia | 51680 | 19747 | 267 |
2495149 | 2495149 | 2022-05-11 | Erie | Ohio | 39043 | 19621 | 267 |
2495610 | 2495610 | 2022-05-11 | Coffee | Tennessee | 47031 | 16994 | 267 |
2496067 | 2496067 | 2022-05-11 | Lynchburg city | Virginia | 51680 | 19758 | 267 |
2491891 | 2491891 | 2022-05-10 | Erie | Ohio | 39043 | 19621 | 267 |
2492352 | 2492352 | 2022-05-10 | Coffee | Tennessee | 47031 | 16968 | 267 |
2492809 | 2492809 | 2022-05-10 | Lynchburg city | Virginia | 51680 | 19801 | 267 |
2488633 | 2488633 | 2022-05-09 | Erie | Ohio | 39043 | 19621 | 267 |
2489094 | 2489094 | 2022-05-09 | Coffee | Tennessee | 47031 | 16968 | 267 |
2485376 | 2485376 | 2022-05-08 | Erie | Ohio | 39043 | 19621 | 267 |
2485837 | 2485837 | 2022-05-08 | Coffee | Tennessee | 47031 | 16968 | 267 |
2482118 | 2482118 | 2022-05-07 | Erie | Ohio | 39043 | 19621 | 267 |
2482579 | 2482579 | 2022-05-07 | Coffee | Tennessee | 47031 | 16968 | 267 |
2478860 | 2478860 | 2022-05-06 | Erie | Ohio | 39043 | 19621 | 267 |
2479321 | 2479321 | 2022-05-06 | Coffee | Tennessee | 47031 | 16968 | 267 |
2475602 | 2475602 | 2022-05-05 | Erie | Ohio | 39043 | 19621 | 267 |
2476063 | 2476063 | 2022-05-05 | Coffee | Tennessee | 47031 | 16968 | 267 |
2472806 | 2472806 | 2022-05-04 | Coffee | Tennessee | 47031 | 16968 | 267 |
2467453 | 2467453 | 2022-05-03 | Gordon | Georgia | 13129 | 16624 | 267 |
2467699 | 2467699 | 2022-05-03 | Whiteside | Illinois | 17195 | 15556 | 267 |
2469550 | 2469550 | 2022-05-03 | Coffee | Tennessee | 47031 | 16960 | 267 |
2464198 | 2464198 | 2022-05-02 | Gordon | Georgia | 13129 | 16624 | 267 |
2464444 | 2464444 | 2022-05-02 | Whiteside | Illinois | 17195 | 15551 | 267 |
2466294 | 2466294 | 2022-05-02 | Coffee | Tennessee | 47031 | 16960 | 267 |
2460942 | 2460942 | 2022-05-01 | Gordon | Georgia | 13129 | 16620 | 267 |
2461188 | 2461188 | 2022-05-01 | Whiteside | Illinois | 17195 | 15527 | 267 |
2463039 | 2463039 | 2022-05-01 | Coffee | Tennessee | 47031 | 16960 | 267 |
2457686 | 2457686 | 2022-04-30 | Gordon | Georgia | 13129 | 16620 | 267 |
2457932 | 2457932 | 2022-04-30 | Whiteside | Illinois | 17195 | 15527 | 267 |
2459783 | 2459783 | 2022-04-30 | Coffee | Tennessee | 47031 | 16960 | 267 |
2454430 | 2454430 | 2022-04-29 | Gordon | Georgia | 13129 | 16620 | 267 |
2454676 | 2454676 | 2022-04-29 | Whiteside | Illinois | 17195 | 15527 | 267 |
2456527 | 2456527 | 2022-04-29 | Coffee | Tennessee | 47031 | 16960 | 267 |
2451174 | 2451174 | 2022-04-28 | Gordon | Georgia | 13129 | 16620 | 267 |
2451420 | 2451420 | 2022-04-28 | Whiteside | Illinois | 17195 | 15503 | 267 |
2453271 | 2453271 | 2022-04-28 | Coffee | Tennessee | 47031 | 16960 | 267 |
2447918 | 2447918 | 2022-04-27 | Gordon | Georgia | 13129 | 16620 | 267 |
2448164 | 2448164 | 2022-04-27 | Whiteside | Illinois | 17195 | 15477 | 267 |
2449583 | 2449583 | 2022-04-27 | Marion | Ohio | 39101 | 19874 | 267 |
2450015 | 2450015 | 2022-04-27 | Coffee | Tennessee | 47031 | 16960 | 267 |
2444908 | 2444908 | 2022-04-26 | Whiteside | Illinois | 17195 | 15459 | 267 |
2446326 | 2446326 | 2022-04-26 | Marion | Ohio | 39101 | 19874 | 267 |
2446758 | 2446758 | 2022-04-26 | Coffee | Tennessee | 47031 | 16947 | 267 |
2441652 | 2441652 | 2022-04-25 | Whiteside | Illinois | 17195 | 15451 | 267 |
2443071 | 2443071 | 2022-04-25 | Marion | Ohio | 39101 | 19874 | 267 |
2443503 | 2443503 | 2022-04-25 | Coffee | Tennessee | 47031 | 16947 | 267 |
2443959 | 2443959 | 2022-04-25 | Lynchburg city | Virginia | 51680 | 19809 | 267 |
2438396 | 2438396 | 2022-04-24 | Whiteside | Illinois | 17195 | 15427 | 267 |
2439815 | 2439815 | 2022-04-24 | Marion | Ohio | 39101 | 19874 | 267 |
2440247 | 2440247 | 2022-04-24 | Coffee | Tennessee | 47031 | 16947 | 267 |
2440703 | 2440703 | 2022-04-24 | Lynchburg city | Virginia | 51680 | 19804 | 267 |
2435140 | 2435140 | 2022-04-23 | Whiteside | Illinois | 17195 | 15427 | 267 |
2436559 | 2436559 | 2022-04-23 | Marion | Ohio | 39101 | 19874 | 267 |
2436991 | 2436991 | 2022-04-23 | Coffee | Tennessee | 47031 | 16947 | 267 |
2437447 | 2437447 | 2022-04-23 | Lynchburg city | Virginia | 51680 | 19804 | 267 |
2431884 | 2431884 | 2022-04-22 | Whiteside | Illinois | 17195 | 15427 | 267 |
2433303 | 2433303 | 2022-04-22 | Marion | Ohio | 39101 | 19874 | 267 |
2433735 | 2433735 | 2022-04-22 | Coffee | Tennessee | 47031 | 16947 | 267 |
2433807 | 2433807 | 2022-04-22 | Unknown | Tennessee | 18984 | 267 | |
2434191 | 2434191 | 2022-04-22 | Lynchburg city | Virginia | 51680 | 19804 | 267 |
2428628 | 2428628 | 2022-04-21 | Whiteside | Illinois | 17195 | 15420 | 267 |
2430047 | 2430047 | 2022-04-21 | Marion | Ohio | 39101 | 19874 | 267 |
2430479 | 2430479 | 2022-04-21 | Coffee | Tennessee | 47031 | 16947 | 267 |
2425372 | 2425372 | 2022-04-20 | Whiteside | Illinois | 17195 | 15415 | 267 |
2427223 | 2427223 | 2022-04-20 | Coffee | Tennessee | 47031 | 16947 | 267 |
2422116 | 2422116 | 2022-04-19 | Whiteside | Illinois | 17195 | 15403 | 267 |
2423967 | 2423967 | 2022-04-19 | Coffee | Tennessee | 47031 | 16941 | 267 |
2418860 | 2418860 | 2022-04-18 | Whiteside | Illinois | 17195 | 15400 | 267 |
2420416 | 2420416 | 2022-04-18 | Linn | Oregon | 41043 | 26547 | 267 |
2420711 | 2420711 | 2022-04-18 | Coffee | Tennessee | 47031 | 16941 | 267 |
2415604 | 2415604 | 2022-04-17 | Whiteside | Illinois | 17195 | 15386 | 267 |
2416756 | 2416756 | 2022-04-17 | Valencia | New Mexico | 35061 | 19066 | 267 |
2417161 | 2417161 | 2022-04-17 | Linn | Oregon | 41043 | 26547 | 267 |
2417455 | 2417455 | 2022-04-17 | Coffee | Tennessee | 47031 | 16941 | 267 |
2412348 | 2412348 | 2022-04-16 | Whiteside | Illinois | 17195 | 15386 | 267 |
2413500 | 2413500 | 2022-04-16 | Valencia | New Mexico | 35061 | 19066 | 267 |
2413905 | 2413905 | 2022-04-16 | Linn | Oregon | 41043 | 26547 | 267 |
2414199 | 2414199 | 2022-04-16 | Coffee | Tennessee | 47031 | 16941 | 267 |
2409092 | 2409092 | 2022-04-15 | Whiteside | Illinois | 17195 | 15386 | 267 |
2410244 | 2410244 | 2022-04-15 | Valencia | New Mexico | 35061 | 19066 | 267 |
2410649 | 2410649 | 2022-04-15 | Linn | Oregon | 41043 | 26547 | 267 |
2410943 | 2410943 | 2022-04-15 | Coffee | Tennessee | 47031 | 16941 | 267 |
2405836 | 2405836 | 2022-04-14 | Whiteside | Illinois | 17195 | 15376 | 267 |
2406988 | 2406988 | 2022-04-14 | Valencia | New Mexico | 35061 | 19063 | 267 |
2407393 | 2407393 | 2022-04-14 | Linn | Oregon | 41043 | 26533 | 267 |
2407687 | 2407687 | 2022-04-14 | Coffee | Tennessee | 47031 | 16941 | 267 |
2402581 | 2402581 | 2022-04-13 | Whiteside | Illinois | 17195 | 15375 | 267 |
2403732 | 2403732 | 2022-04-13 | Valencia | New Mexico | 35061 | 19060 | 267 |
2404431 | 2404431 | 2022-04-13 | Coffee | Tennessee | 47031 | 16941 | 267 |
2399326 | 2399326 | 2022-04-12 | Whiteside | Illinois | 17195 | 15369 | 267 |
2400477 | 2400477 | 2022-04-12 | Valencia | New Mexico | 35061 | 19055 | 267 |
2396071 | 2396071 | 2022-04-11 | Whiteside | Illinois | 17195 | 15363 | 267 |
2392815 | 2392815 | 2022-04-10 | Whiteside | Illinois | 17195 | 15353 | 267 |
2393960 | 2393960 | 2022-04-10 | Santa Fe | New Mexico | 35049 | 28612 | 267 |
2389559 | 2389559 | 2022-04-09 | Whiteside | Illinois | 17195 | 15353 | 267 |
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);