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

785 rows where county = "Grant" and state = "Indiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Indiana · 785 ✖

fips 1

county 1

  • Grant · 785 ✖
Link rowid date ▲ county state fips cases deaths
2500306 2500306 2022-05-13 Grant Indiana 18053 17380 354
2497048 2497048 2022-05-12 Grant Indiana 18053 17369 353
2493790 2493790 2022-05-11 Grant Indiana 18053 17369 353
2490532 2490532 2022-05-10 Grant Indiana 18053 17366 352
2487275 2487275 2022-05-09 Grant Indiana 18053 17366 352
2484017 2484017 2022-05-08 Grant Indiana 18053 17352 352
2480759 2480759 2022-05-07 Grant Indiana 18053 17352 352
2477501 2477501 2022-05-06 Grant Indiana 18053 17352 352
2474243 2474243 2022-05-05 Grant Indiana 18053 17352 352
2470986 2470986 2022-05-04 Grant Indiana 18053 17352 352
2467730 2467730 2022-05-03 Grant Indiana 18053 17348 351
2464475 2464475 2022-05-02 Grant Indiana 18053 17348 351
2461219 2461219 2022-05-01 Grant Indiana 18053 17347 351
2457963 2457963 2022-04-30 Grant Indiana 18053 17347 351
2454707 2454707 2022-04-29 Grant Indiana 18053 17347 351
2451451 2451451 2022-04-28 Grant Indiana 18053 17341 351
2448195 2448195 2022-04-27 Grant Indiana 18053 17341 351
2444939 2444939 2022-04-26 Grant Indiana 18053 17334 350
2441683 2441683 2022-04-25 Grant Indiana 18053 17334 350
2438427 2438427 2022-04-24 Grant Indiana 18053 17320 350
2435171 2435171 2022-04-23 Grant Indiana 18053 17320 350
2431915 2431915 2022-04-22 Grant Indiana 18053 17320 350
2428659 2428659 2022-04-21 Grant Indiana 18053 17317 350
2425403 2425403 2022-04-20 Grant Indiana 18053 17317 350
2422147 2422147 2022-04-19 Grant Indiana 18053 17316 350
2418891 2418891 2022-04-18 Grant Indiana 18053 17316 350
2415635 2415635 2022-04-17 Grant Indiana 18053 17303 349
2412379 2412379 2022-04-16 Grant Indiana 18053 17303 349
2409123 2409123 2022-04-15 Grant Indiana 18053 17303 349
2405867 2405867 2022-04-14 Grant Indiana 18053 17303 349
2402612 2402612 2022-04-13 Grant Indiana 18053 17303 349
2399357 2399357 2022-04-12 Grant Indiana 18053 17300 348
2396102 2396102 2022-04-11 Grant Indiana 18053 17300 348
2392846 2392846 2022-04-10 Grant Indiana 18053 17294 347
2389590 2389590 2022-04-09 Grant Indiana 18053 17294 347
2386335 2386335 2022-04-08 Grant Indiana 18053 17294 347
2383080 2383080 2022-04-07 Grant Indiana 18053 17293 347
2379825 2379825 2022-04-06 Grant Indiana 18053 17293 347
2376571 2376571 2022-04-05 Grant Indiana 18053 17284 347
2373319 2373319 2022-04-04 Grant Indiana 18053 17284 347
2370066 2370066 2022-04-03 Grant Indiana 18053 17280 347
2366813 2366813 2022-04-02 Grant Indiana 18053 17280 347
2363560 2363560 2022-04-01 Grant Indiana 18053 17280 347
2360306 2360306 2022-03-31 Grant Indiana 18053 17271 345
2357052 2357052 2022-03-30 Grant Indiana 18053 17271 345
2353799 2353799 2022-03-29 Grant Indiana 18053 17684 345
2350547 2350547 2022-03-28 Grant Indiana 18053 17683 345
2347294 2347294 2022-03-27 Grant Indiana 18053 17678 346
2344041 2344041 2022-03-26 Grant Indiana 18053 17678 346
2340788 2340788 2022-03-25 Grant Indiana 18053 17678 346
2337535 2337535 2022-03-24 Grant Indiana 18053 17676 346
2334281 2334281 2022-03-23 Grant Indiana 18053 17674 346
2331027 2331027 2022-03-22 Grant Indiana 18053 17676 346
2327775 2327775 2022-03-21 Grant Indiana 18053 17672 346
2324522 2324522 2022-03-20 Grant Indiana 18053 17662 346
2321268 2321268 2022-03-19 Grant Indiana 18053 17662 346
2318014 2318014 2022-03-18 Grant Indiana 18053 17662 346
2314761 2314761 2022-03-17 Grant Indiana 18053 17663 346
2311508 2311508 2022-03-16 Grant Indiana 18053 17660 346
2308255 2308255 2022-03-15 Grant Indiana 18053 17657 346
2305004 2305004 2022-03-14 Grant Indiana 18053 17654 346
2301752 2301752 2022-03-13 Grant Indiana 18053 17649 345
2298500 2298500 2022-03-12 Grant Indiana 18053 17649 345
2295248 2295248 2022-03-11 Grant Indiana 18053 17649 345
2291996 2291996 2022-03-10 Grant Indiana 18053 17649 344
2288744 2288744 2022-03-09 Grant Indiana 18053 17646 344
2285493 2285493 2022-03-08 Grant Indiana 18053 17644 343
2282241 2282241 2022-03-07 Grant Indiana 18053 17640 343
2278988 2278988 2022-03-06 Grant Indiana 18053 17633 343
2275735 2275735 2022-03-05 Grant Indiana 18053 17633 343
2272482 2272482 2022-03-04 Grant Indiana 18053 17633 343
2269230 2269230 2022-03-03 Grant Indiana 18053 17625 342
2265977 2265977 2022-03-02 Grant Indiana 18053 17617 342
2262726 2262726 2022-03-01 Grant Indiana 18053 17614 342
2259475 2259475 2022-02-28 Grant Indiana 18053 17612 341
2256224 2256224 2022-02-27 Grant Indiana 18053 17598 339
2252973 2252973 2022-02-26 Grant Indiana 18053 17598 339
2249722 2249722 2022-02-25 Grant Indiana 18053 17598 339
2246471 2246471 2022-02-24 Grant Indiana 18053 17594 338
2243220 2243220 2022-02-23 Grant Indiana 18053 17584 338
2239969 2239969 2022-02-22 Grant Indiana 18053 17574 338
2236718 2236718 2022-02-21 Grant Indiana 18053 17567 338
2233467 2233467 2022-02-20 Grant Indiana 18053 17553 337
2230216 2230216 2022-02-19 Grant Indiana 18053 17553 337
2226965 2226965 2022-02-18 Grant Indiana 18053 17553 337
2223714 2223714 2022-02-17 Grant Indiana 18053 17539 337
2220463 2220463 2022-02-16 Grant Indiana 18053 17528 335
2217212 2217212 2022-02-15 Grant Indiana 18053 17515 334
2213961 2213961 2022-02-14 Grant Indiana 18053 17496 333
2210709 2210709 2022-02-13 Grant Indiana 18053 17445 333
2207456 2207456 2022-02-12 Grant Indiana 18053 17445 333
2204203 2204203 2022-02-11 Grant Indiana 18053 17445 333
2200950 2200950 2022-02-10 Grant Indiana 18053 17416 330
2197696 2197696 2022-02-09 Grant Indiana 18053 17365 329
2194442 2194442 2022-02-08 Grant Indiana 18053 17365 329
2191188 2191188 2022-02-07 Grant Indiana 18053 17321 327
2187935 2187935 2022-02-06 Grant Indiana 18053 17278 327
2184682 2184682 2022-02-05 Grant Indiana 18053 17278 327
2181430 2181430 2022-02-04 Grant Indiana 18053 17278 327
2178179 2178179 2022-02-03 Grant Indiana 18053 17220 327

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