ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,555 rows where county = "Hale" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499607 | 2499607 | 2022-05-13 | Hale | Alabama | 1065 | 4741 | 106 |
2502301 | 2502301 | 2022-05-13 | Hale | Texas | 48189 | 6571 | 245 |
2496349 | 2496349 | 2022-05-12 | Hale | Alabama | 1065 | 4741 | 106 |
2499043 | 2499043 | 2022-05-12 | Hale | Texas | 48189 | 6571 | 245 |
2493091 | 2493091 | 2022-05-11 | Hale | Alabama | 1065 | 4741 | 106 |
2495785 | 2495785 | 2022-05-11 | Hale | Texas | 48189 | 6571 | 245 |
2489833 | 2489833 | 2022-05-10 | Hale | Alabama | 1065 | 4733 | 106 |
2492527 | 2492527 | 2022-05-10 | Hale | Texas | 48189 | 6571 | 245 |
2486576 | 2486576 | 2022-05-09 | Hale | Alabama | 1065 | 4733 | 106 |
2489269 | 2489269 | 2022-05-09 | Hale | Texas | 48189 | 6571 | 245 |
2483318 | 2483318 | 2022-05-08 | Hale | Alabama | 1065 | 4731 | 106 |
2486012 | 2486012 | 2022-05-08 | Hale | Texas | 48189 | 6570 | 245 |
2480060 | 2480060 | 2022-05-07 | Hale | Alabama | 1065 | 4731 | 106 |
2482754 | 2482754 | 2022-05-07 | Hale | Texas | 48189 | 6569 | 245 |
2476802 | 2476802 | 2022-05-06 | Hale | Alabama | 1065 | 4731 | 106 |
2479496 | 2479496 | 2022-05-06 | Hale | Texas | 48189 | 6567 | 245 |
2473544 | 2473544 | 2022-05-05 | Hale | Alabama | 1065 | 4732 | 106 |
2476238 | 2476238 | 2022-05-05 | Hale | Texas | 48189 | 6567 | 245 |
2470287 | 2470287 | 2022-05-04 | Hale | Alabama | 1065 | 4732 | 106 |
2472981 | 2472981 | 2022-05-04 | Hale | Texas | 48189 | 6567 | 245 |
2467031 | 2467031 | 2022-05-03 | Hale | Alabama | 1065 | 4732 | 106 |
2469725 | 2469725 | 2022-05-03 | Hale | Texas | 48189 | 6566 | 245 |
2463776 | 2463776 | 2022-05-02 | Hale | Alabama | 1065 | 4731 | 106 |
2466469 | 2466469 | 2022-05-02 | Hale | Texas | 48189 | 6566 | 245 |
2460520 | 2460520 | 2022-05-01 | Hale | Alabama | 1065 | 4727 | 106 |
2463214 | 2463214 | 2022-05-01 | Hale | Texas | 48189 | 6566 | 245 |
2457264 | 2457264 | 2022-04-30 | Hale | Alabama | 1065 | 4727 | 106 |
2459958 | 2459958 | 2022-04-30 | Hale | Texas | 48189 | 6565 | 245 |
2454008 | 2454008 | 2022-04-29 | Hale | Alabama | 1065 | 4727 | 106 |
2456702 | 2456702 | 2022-04-29 | Hale | Texas | 48189 | 6565 | 245 |
2450752 | 2450752 | 2022-04-28 | Hale | Alabama | 1065 | 4726 | 106 |
2453446 | 2453446 | 2022-04-28 | Hale | Texas | 48189 | 6565 | 245 |
2447496 | 2447496 | 2022-04-27 | Hale | Alabama | 1065 | 4725 | 106 |
2450190 | 2450190 | 2022-04-27 | Hale | Texas | 48189 | 6564 | 245 |
2444240 | 2444240 | 2022-04-26 | Hale | Alabama | 1065 | 4725 | 106 |
2446933 | 2446933 | 2022-04-26 | Hale | Texas | 48189 | 6563 | 245 |
2440984 | 2440984 | 2022-04-25 | Hale | Alabama | 1065 | 4723 | 106 |
2443678 | 2443678 | 2022-04-25 | Hale | Texas | 48189 | 6563 | 245 |
2437728 | 2437728 | 2022-04-24 | Hale | Alabama | 1065 | 4723 | 106 |
2440422 | 2440422 | 2022-04-24 | Hale | Texas | 48189 | 6562 | 245 |
2434472 | 2434472 | 2022-04-23 | Hale | Alabama | 1065 | 4723 | 106 |
2437166 | 2437166 | 2022-04-23 | Hale | Texas | 48189 | 6562 | 245 |
2431216 | 2431216 | 2022-04-22 | Hale | Alabama | 1065 | 4723 | 106 |
2433910 | 2433910 | 2022-04-22 | Hale | Texas | 48189 | 6562 | 245 |
2427960 | 2427960 | 2022-04-21 | Hale | Alabama | 1065 | 4722 | 106 |
2430654 | 2430654 | 2022-04-21 | Hale | Texas | 48189 | 6561 | 245 |
2424704 | 2424704 | 2022-04-20 | Hale | Alabama | 1065 | 4722 | 106 |
2427398 | 2427398 | 2022-04-20 | Hale | Texas | 48189 | 6561 | 245 |
2421448 | 2421448 | 2022-04-19 | Hale | Alabama | 1065 | 4722 | 106 |
2424142 | 2424142 | 2022-04-19 | Hale | Texas | 48189 | 6560 | 245 |
2418192 | 2418192 | 2022-04-18 | Hale | Alabama | 1065 | 4722 | 106 |
2420886 | 2420886 | 2022-04-18 | Hale | Texas | 48189 | 6559 | 245 |
2414936 | 2414936 | 2022-04-17 | Hale | Alabama | 1065 | 4722 | 106 |
2417630 | 2417630 | 2022-04-17 | Hale | Texas | 48189 | 6559 | 245 |
2411680 | 2411680 | 2022-04-16 | Hale | Alabama | 1065 | 4722 | 106 |
2414374 | 2414374 | 2022-04-16 | Hale | Texas | 48189 | 6559 | 245 |
2408424 | 2408424 | 2022-04-15 | Hale | Alabama | 1065 | 4722 | 106 |
2411118 | 2411118 | 2022-04-15 | Hale | Texas | 48189 | 6559 | 245 |
2405168 | 2405168 | 2022-04-14 | Hale | Alabama | 1065 | 4716 | 106 |
2407862 | 2407862 | 2022-04-14 | Hale | Texas | 48189 | 6559 | 245 |
2401913 | 2401913 | 2022-04-13 | Hale | Alabama | 1065 | 4714 | 105 |
2404606 | 2404606 | 2022-04-13 | Hale | Texas | 48189 | 6558 | 245 |
2398658 | 2398658 | 2022-04-12 | Hale | Alabama | 1065 | 4714 | 105 |
2401351 | 2401351 | 2022-04-12 | Hale | Texas | 48189 | 6558 | 245 |
2395403 | 2395403 | 2022-04-11 | Hale | Alabama | 1065 | 4714 | 105 |
2398096 | 2398096 | 2022-04-11 | Hale | Texas | 48189 | 6558 | 245 |
2392147 | 2392147 | 2022-04-10 | Hale | Alabama | 1065 | 4711 | 105 |
2394841 | 2394841 | 2022-04-10 | Hale | Texas | 48189 | 6558 | 245 |
2388891 | 2388891 | 2022-04-09 | Hale | Alabama | 1065 | 4711 | 105 |
2391585 | 2391585 | 2022-04-09 | Hale | Texas | 48189 | 6558 | 245 |
2385636 | 2385636 | 2022-04-08 | Hale | Alabama | 1065 | 4711 | 105 |
2388329 | 2388329 | 2022-04-08 | Hale | Texas | 48189 | 6557 | 245 |
2382381 | 2382381 | 2022-04-07 | Hale | Alabama | 1065 | 4711 | 105 |
2385074 | 2385074 | 2022-04-07 | Hale | Texas | 48189 | 6556 | 245 |
2379126 | 2379126 | 2022-04-06 | Hale | Alabama | 1065 | 4711 | 105 |
2381819 | 2381819 | 2022-04-06 | Hale | Texas | 48189 | 6555 | 245 |
2375872 | 2375872 | 2022-04-05 | Hale | Alabama | 1065 | 4711 | 105 |
2378564 | 2378564 | 2022-04-05 | Hale | Texas | 48189 | 6554 | 245 |
2372620 | 2372620 | 2022-04-04 | Hale | Alabama | 1065 | 4708 | 105 |
2375310 | 2375310 | 2022-04-04 | Hale | Texas | 48189 | 6553 | 245 |
2369367 | 2369367 | 2022-04-03 | Hale | Alabama | 1065 | 4708 | 105 |
2372058 | 2372058 | 2022-04-03 | Hale | Texas | 48189 | 6540 | 245 |
2366114 | 2366114 | 2022-04-02 | Hale | Alabama | 1065 | 4708 | 105 |
2368805 | 2368805 | 2022-04-02 | Hale | Texas | 48189 | 6540 | 245 |
2362861 | 2362861 | 2022-04-01 | Hale | Alabama | 1065 | 4708 | 105 |
2365552 | 2365552 | 2022-04-01 | Hale | Texas | 48189 | 6537 | 244 |
2359607 | 2359607 | 2022-03-31 | Hale | Alabama | 1065 | 4708 | 105 |
2362299 | 2362299 | 2022-03-31 | Hale | Texas | 48189 | 6536 | 244 |
2356353 | 2356353 | 2022-03-30 | Hale | Alabama | 1065 | 4708 | 105 |
2359045 | 2359045 | 2022-03-30 | Hale | Texas | 48189 | 6536 | 244 |
2353100 | 2353100 | 2022-03-29 | Hale | Alabama | 1065 | 4703 | 105 |
2355791 | 2355791 | 2022-03-29 | Hale | Texas | 48189 | 6536 | 244 |
2349848 | 2349848 | 2022-03-28 | Hale | Alabama | 1065 | 4697 | 104 |
2352538 | 2352538 | 2022-03-28 | Hale | Texas | 48189 | 6536 | 244 |
2346595 | 2346595 | 2022-03-27 | Hale | Alabama | 1065 | 4697 | 104 |
2349286 | 2349286 | 2022-03-27 | Hale | Texas | 48189 | 6536 | 244 |
2343342 | 2343342 | 2022-03-26 | Hale | Alabama | 1065 | 4697 | 104 |
2346033 | 2346033 | 2022-03-26 | Hale | Texas | 48189 | 6536 | 244 |
2340089 | 2340089 | 2022-03-25 | Hale | Alabama | 1065 | 4697 | 104 |
2342780 | 2342780 | 2022-03-25 | Hale | Texas | 48189 | 6535 | 244 |
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);