ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,555 rows where county = "Hill" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 2

fips 2

county 1

  • Hill · 1,555 ✖
Link rowid date ▲ county state fips cases deaths
2501213 2501213 2022-05-13 Hill Montana 30041 4574 73
2502315 2502315 2022-05-13 Hill Texas 48217 8991 192
2497955 2497955 2022-05-12 Hill Montana 30041 4570 73
2499057 2499057 2022-05-12 Hill Texas 48217 8991 192
2494697 2494697 2022-05-11 Hill Montana 30041 4570 73
2495799 2495799 2022-05-11 Hill Texas 48217 8990 192
2491439 2491439 2022-05-10 Hill Montana 30041 4570 73
2492541 2492541 2022-05-10 Hill Texas 48217 8990 192
2488181 2488181 2022-05-09 Hill Montana 30041 4570 73
2489283 2489283 2022-05-09 Hill Texas 48217 8990 192
2484924 2484924 2022-05-08 Hill Montana 30041 4570 73
2486026 2486026 2022-05-08 Hill Texas 48217 8990 192
2481666 2481666 2022-05-07 Hill Montana 30041 4570 73
2482768 2482768 2022-05-07 Hill Texas 48217 8988 192
2478408 2478408 2022-05-06 Hill Montana 30041 4570 73
2479510 2479510 2022-05-06 Hill Texas 48217 8987 192
2475150 2475150 2022-05-05 Hill Montana 30041 4570 73
2476252 2476252 2022-05-05 Hill Texas 48217 8986 192
2471893 2471893 2022-05-04 Hill Montana 30041 4570 73
2472995 2472995 2022-05-04 Hill Texas 48217 8986 192
2468637 2468637 2022-05-03 Hill Montana 30041 4570 73
2469739 2469739 2022-05-03 Hill Texas 48217 8986 192
2465381 2465381 2022-05-02 Hill Montana 30041 4570 73
2466483 2466483 2022-05-02 Hill Texas 48217 8986 192
2462126 2462126 2022-05-01 Hill Montana 30041 4570 73
2463228 2463228 2022-05-01 Hill Texas 48217 8986 192
2458870 2458870 2022-04-30 Hill Montana 30041 4570 73
2459972 2459972 2022-04-30 Hill Texas 48217 8986 192
2455614 2455614 2022-04-29 Hill Montana 30041 4570 73
2456716 2456716 2022-04-29 Hill Texas 48217 8986 192
2452358 2452358 2022-04-28 Hill Montana 30041 4567 73
2453460 2453460 2022-04-28 Hill Texas 48217 8986 192
2449102 2449102 2022-04-27 Hill Montana 30041 4567 73
2450204 2450204 2022-04-27 Hill Texas 48217 8985 192
2445845 2445845 2022-04-26 Hill Montana 30041 4566 73
2446947 2446947 2022-04-26 Hill Texas 48217 8984 192
2442590 2442590 2022-04-25 Hill Montana 30041 4554 73
2443692 2443692 2022-04-25 Hill Texas 48217 8984 192
2439334 2439334 2022-04-24 Hill Montana 30041 4548 71
2440436 2440436 2022-04-24 Hill Texas 48217 8984 192
2436078 2436078 2022-04-23 Hill Montana 30041 4548 71
2437180 2437180 2022-04-23 Hill Texas 48217 8984 192
2432822 2432822 2022-04-22 Hill Montana 30041 4548 71
2433924 2433924 2022-04-22 Hill Texas 48217 8980 192
2429566 2429566 2022-04-21 Hill Montana 30041 4546 71
2430668 2430668 2022-04-21 Hill Texas 48217 8926 192
2426310 2426310 2022-04-20 Hill Montana 30041 4545 71
2427412 2427412 2022-04-20 Hill Texas 48217 8925 192
2423054 2423054 2022-04-19 Hill Montana 30041 4545 71
2424156 2424156 2022-04-19 Hill Texas 48217 8924 192
2419797 2419797 2022-04-18 Hill Montana 30041 4542 71
2420900 2420900 2022-04-18 Hill Texas 48217 8923 192
2416542 2416542 2022-04-17 Hill Montana 30041 4542 71
2417644 2417644 2022-04-17 Hill Texas 48217 8922 192
2413286 2413286 2022-04-16 Hill Montana 30041 4542 71
2414388 2414388 2022-04-16 Hill Texas 48217 8922 192
2410030 2410030 2022-04-15 Hill Montana 30041 4542 71
2411132 2411132 2022-04-15 Hill Texas 48217 8922 192
2406774 2406774 2022-04-14 Hill Montana 30041 4540 71
2407876 2407876 2022-04-14 Hill Texas 48217 8922 192
2403518 2403518 2022-04-13 Hill Montana 30041 4540 71
2404620 2404620 2022-04-13 Hill Texas 48217 8921 192
2400263 2400263 2022-04-12 Hill Montana 30041 4540 71
2401365 2401365 2022-04-12 Hill Texas 48217 8920 192
2397008 2397008 2022-04-11 Hill Montana 30041 4539 71
2398110 2398110 2022-04-11 Hill Texas 48217 8915 192
2393753 2393753 2022-04-10 Hill Montana 30041 4539 71
2394855 2394855 2022-04-10 Hill Texas 48217 8915 192
2390497 2390497 2022-04-09 Hill Montana 30041 4539 71
2391599 2391599 2022-04-09 Hill Texas 48217 8915 192
2387241 2387241 2022-04-08 Hill Montana 30041 4539 71
2388343 2388343 2022-04-08 Hill Texas 48217 8914 191
2383986 2383986 2022-04-07 Hill Montana 30041 4539 71
2385088 2385088 2022-04-07 Hill Texas 48217 8912 191
2380731 2380731 2022-04-06 Hill Montana 30041 4539 71
2381833 2381833 2022-04-06 Hill Texas 48217 8911 191
2377476 2377476 2022-04-05 Hill Montana 30041 4539 71
2378578 2378578 2022-04-05 Hill Texas 48217 8909 191
2374223 2374223 2022-04-04 Hill Montana 30041 4537 71
2375324 2375324 2022-04-04 Hill Texas 48217 8906 191
2370971 2370971 2022-04-03 Hill Montana 30041 4537 71
2372072 2372072 2022-04-03 Hill Texas 48217 8906 191
2367718 2367718 2022-04-02 Hill Montana 30041 4537 71
2368819 2368819 2022-04-02 Hill Texas 48217 8906 191
2364465 2364465 2022-04-01 Hill Montana 30041 4537 71
2365566 2365566 2022-04-01 Hill Texas 48217 8903 191
2361211 2361211 2022-03-31 Hill Montana 30041 4536 71
2362313 2362313 2022-03-31 Hill Texas 48217 8901 191
2357957 2357957 2022-03-30 Hill Montana 30041 4536 71
2359059 2359059 2022-03-30 Hill Texas 48217 8897 191
2354704 2354704 2022-03-29 Hill Montana 30041 4536 71
2355805 2355805 2022-03-29 Hill Texas 48217 8893 191
2351451 2351451 2022-03-28 Hill Montana 30041 4536 71
2352552 2352552 2022-03-28 Hill Texas 48217 8869 191
2348199 2348199 2022-03-27 Hill Montana 30041 4536 71
2349300 2349300 2022-03-27 Hill Texas 48217 8869 191
2344946 2344946 2022-03-26 Hill Montana 30041 4536 71
2346047 2346047 2022-03-26 Hill Texas 48217 8869 191
2341693 2341693 2022-03-25 Hill Montana 30041 4536 71
2342794 2342794 2022-03-25 Hill Texas 48217 8869 191

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);