ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,417 rows where deaths = 212 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 150
- Georgia 86
- Pennsylvania 79
- Ohio 75
- Maryland 73
- Michigan 67
- Tennessee 67
- Alabama 62
- Oklahoma 59
- Louisiana 55
- Virginia 55
- North Carolina 50
- South Carolina 45
- Illinois 44
- Indiana 41
- Arkansas 36
- Missouri 33
- Florida 31
- California 30
- Kentucky 30
- New Jersey 23
- Utah 22
- Washington 21
- Wisconsin 20
- North Dakota 18
- Colorado 17
- Arizona 15
- New York 13
- Nevada 12
- Mississippi 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499717 | 2499717 | 2022-05-13 | Independence | Arkansas | 5063 | 10639 | 212 |
2499770 | 2499770 | 2022-05-13 | El Dorado | California | 6017 | 30508 | 212 |
2501908 | 2501908 | 2022-05-13 | Warren | Pennsylvania | 42123 | 7506 | 212 |
2502443 | 2502443 | 2022-05-13 | Walker | Texas | 48471 | 19223 | 212 |
2496459 | 2496459 | 2022-05-12 | Independence | Arkansas | 5063 | 10637 | 212 |
2496512 | 2496512 | 2022-05-12 | El Dorado | California | 6017 | 30428 | 212 |
2498650 | 2498650 | 2022-05-12 | Warren | Pennsylvania | 42123 | 7506 | 212 |
2499185 | 2499185 | 2022-05-12 | Walker | Texas | 48471 | 18579 | 212 |
2493201 | 2493201 | 2022-05-11 | Independence | Arkansas | 5063 | 10634 | 212 |
2493254 | 2493254 | 2022-05-11 | El Dorado | California | 6017 | 30428 | 212 |
2495392 | 2495392 | 2022-05-11 | Warren | Pennsylvania | 42123 | 7506 | 212 |
2495927 | 2495927 | 2022-05-11 | Walker | Texas | 48471 | 18575 | 212 |
2489943 | 2489943 | 2022-05-10 | Independence | Arkansas | 5063 | 10632 | 212 |
2489996 | 2489996 | 2022-05-10 | El Dorado | California | 6017 | 30428 | 212 |
2492669 | 2492669 | 2022-05-10 | Walker | Texas | 48471 | 18568 | 212 |
2486686 | 2486686 | 2022-05-09 | Independence | Arkansas | 5063 | 10631 | 212 |
2489411 | 2489411 | 2022-05-09 | Walker | Texas | 48471 | 18567 | 212 |
2483428 | 2483428 | 2022-05-08 | Independence | Arkansas | 5063 | 10630 | 212 |
2486153 | 2486153 | 2022-05-08 | Walker | Texas | 48471 | 18558 | 212 |
2480170 | 2480170 | 2022-05-07 | Independence | Arkansas | 5063 | 10630 | 212 |
2482895 | 2482895 | 2022-05-07 | Walker | Texas | 48471 | 18554 | 212 |
2476912 | 2476912 | 2022-05-06 | Independence | Arkansas | 5063 | 10627 | 212 |
2479637 | 2479637 | 2022-05-06 | Walker | Texas | 48471 | 18552 | 212 |
2473654 | 2473654 | 2022-05-05 | Independence | Arkansas | 5063 | 10624 | 212 |
2476379 | 2476379 | 2022-05-05 | Walker | Texas | 48471 | 18546 | 212 |
2470397 | 2470397 | 2022-05-04 | Independence | Arkansas | 5063 | 10621 | 212 |
2473122 | 2473122 | 2022-05-04 | Walker | Texas | 48471 | 18543 | 212 |
2467141 | 2467141 | 2022-05-03 | Independence | Arkansas | 5063 | 10617 | 212 |
2469866 | 2469866 | 2022-05-03 | Walker | Texas | 48471 | 18529 | 212 |
2463886 | 2463886 | 2022-05-02 | Independence | Arkansas | 5063 | 10616 | 212 |
2466610 | 2466610 | 2022-05-02 | Walker | Texas | 48471 | 18525 | 212 |
2460630 | 2460630 | 2022-05-01 | Independence | Arkansas | 5063 | 10615 | 212 |
2463355 | 2463355 | 2022-05-01 | Walker | Texas | 48471 | 18524 | 212 |
2460099 | 2460099 | 2022-04-30 | Walker | Texas | 48471 | 18522 | 212 |
2456843 | 2456843 | 2022-04-29 | Walker | Texas | 48471 | 18519 | 212 |
2453587 | 2453587 | 2022-04-28 | Walker | Texas | 48471 | 18517 | 212 |
2450331 | 2450331 | 2022-04-27 | Walker | Texas | 48471 | 18511 | 212 |
2447074 | 2447074 | 2022-04-26 | Walker | Texas | 48471 | 18509 | 212 |
2443819 | 2443819 | 2022-04-25 | Walker | Texas | 48471 | 18502 | 212 |
2440563 | 2440563 | 2022-04-24 | Walker | Texas | 48471 | 18501 | 212 |
2440568 | 2440568 | 2022-04-24 | Wharton | Texas | 48481 | 9137 | 212 |
2437307 | 2437307 | 2022-04-23 | Walker | Texas | 48471 | 18499 | 212 |
2437312 | 2437312 | 2022-04-23 | Wharton | Texas | 48481 | 9137 | 212 |
2434051 | 2434051 | 2022-04-22 | Walker | Texas | 48471 | 18492 | 212 |
2434056 | 2434056 | 2022-04-22 | Wharton | Texas | 48481 | 9137 | 212 |
2430795 | 2430795 | 2022-04-21 | Walker | Texas | 48471 | 18486 | 212 |
2430800 | 2430800 | 2022-04-21 | Wharton | Texas | 48481 | 9134 | 212 |
2430870 | 2430870 | 2022-04-21 | Augusta | Virginia | 51015 | 18778 | 212 |
2427539 | 2427539 | 2022-04-20 | Walker | Texas | 48471 | 18476 | 212 |
2427544 | 2427544 | 2022-04-20 | Wharton | Texas | 48481 | 9133 | 212 |
2424283 | 2424283 | 2022-04-19 | Walker | Texas | 48471 | 18473 | 212 |
2424288 | 2424288 | 2022-04-19 | Wharton | Texas | 48481 | 9130 | 212 |
2424368 | 2424368 | 2022-04-19 | Campbell | Virginia | 51031 | 12318 | 212 |
2424493 | 2424493 | 2022-04-19 | Franklin | Washington | 53021 | 32509 | 212 |
2421027 | 2421027 | 2022-04-18 | Walker | Texas | 48471 | 18469 | 212 |
2421032 | 2421032 | 2022-04-18 | Wharton | Texas | 48481 | 9126 | 212 |
2421112 | 2421112 | 2022-04-18 | Campbell | Virginia | 51031 | 12217 | 212 |
2421237 | 2421237 | 2022-04-18 | Franklin | Washington | 53021 | 32509 | 212 |
2417771 | 2417771 | 2022-04-17 | Walker | Texas | 48471 | 18453 | 212 |
2417776 | 2417776 | 2022-04-17 | Wharton | Texas | 48481 | 9120 | 212 |
2417981 | 2417981 | 2022-04-17 | Franklin | Washington | 53021 | 32501 | 212 |
2414515 | 2414515 | 2022-04-16 | Walker | Texas | 48471 | 18453 | 212 |
2414520 | 2414520 | 2022-04-16 | Wharton | Texas | 48481 | 9120 | 212 |
2414725 | 2414725 | 2022-04-16 | Franklin | Washington | 53021 | 32501 | 212 |
2411259 | 2411259 | 2022-04-15 | Walker | Texas | 48471 | 18453 | 212 |
2411264 | 2411264 | 2022-04-15 | Wharton | Texas | 48481 | 9120 | 212 |
2411469 | 2411469 | 2022-04-15 | Franklin | Washington | 53021 | 32501 | 212 |
2408003 | 2408003 | 2022-04-14 | Walker | Texas | 48471 | 18453 | 212 |
2408008 | 2408008 | 2022-04-14 | Wharton | Texas | 48481 | 9120 | 212 |
2408213 | 2408213 | 2022-04-14 | Franklin | Washington | 53021 | 32497 | 212 |
2404747 | 2404747 | 2022-04-13 | Walker | Texas | 48471 | 18447 | 212 |
2404752 | 2404752 | 2022-04-13 | Wharton | Texas | 48481 | 9116 | 212 |
2404957 | 2404957 | 2022-04-13 | Franklin | Washington | 53021 | 32497 | 212 |
2401492 | 2401492 | 2022-04-12 | Walker | Texas | 48471 | 18438 | 212 |
2401497 | 2401497 | 2022-04-12 | Wharton | Texas | 48481 | 9113 | 212 |
2398237 | 2398237 | 2022-04-11 | Walker | Texas | 48471 | 18436 | 212 |
2393133 | 2393133 | 2022-04-10 | Bullitt | Kentucky | 21029 | 21261 | 212 |
2394982 | 2394982 | 2022-04-10 | Walker | Texas | 48471 | 18436 | 212 |
2389877 | 2389877 | 2022-04-09 | Bullitt | Kentucky | 21029 | 21261 | 212 |
2391726 | 2391726 | 2022-04-09 | Walker | Texas | 48471 | 18436 | 212 |
2386621 | 2386621 | 2022-04-08 | Bullitt | Kentucky | 21029 | 21261 | 212 |
2383366 | 2383366 | 2022-04-07 | Bullitt | Kentucky | 21029 | 21261 | 212 |
2384619 | 2384619 | 2022-04-07 | Yamhill | Oregon | 41071 | 17744 | 212 |
2380111 | 2380111 | 2022-04-06 | Bullitt | Kentucky | 21029 | 21261 | 212 |
2381178 | 2381178 | 2022-04-06 | Crawford | Ohio | 39033 | 11171 | 212 |
2381364 | 2381364 | 2022-04-06 | Yamhill | Oregon | 41071 | 17737 | 212 |
2376856 | 2376856 | 2022-04-05 | Bullitt | Kentucky | 21029 | 21261 | 212 |
2377923 | 2377923 | 2022-04-05 | Crawford | Ohio | 39033 | 11171 | 212 |
2378109 | 2378109 | 2022-04-05 | Yamhill | Oregon | 41071 | 17736 | 212 |
2373604 | 2373604 | 2022-04-04 | Bullitt | Kentucky | 21029 | 21261 | 212 |
2374669 | 2374669 | 2022-04-04 | Crawford | Ohio | 39033 | 11171 | 212 |
2374855 | 2374855 | 2022-04-04 | Yamhill | Oregon | 41071 | 17733 | 212 |
2370558 | 2370558 | 2022-04-03 | St. Mary's | Maryland | 24037 | 18850 | 212 |
2371417 | 2371417 | 2022-04-03 | Crawford | Ohio | 39033 | 11171 | 212 |
2367305 | 2367305 | 2022-04-02 | St. Mary's | Maryland | 24037 | 18850 | 212 |
2368164 | 2368164 | 2022-04-02 | Crawford | Ohio | 39033 | 11171 | 212 |
2364052 | 2364052 | 2022-04-01 | St. Mary's | Maryland | 24037 | 18850 | 212 |
2364911 | 2364911 | 2022-04-01 | Crawford | Ohio | 39033 | 11171 | 212 |
2360798 | 2360798 | 2022-03-31 | St. Mary's | Maryland | 24037 | 18845 | 212 |
2361658 | 2361658 | 2022-03-31 | Crawford | Ohio | 39033 | 11171 | 212 |
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);