ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Coconino", fips = 4005 and state = "Arizona" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499673 | 2499673 | 2022-05-13 | Coconino | Arizona | 4005 | 44091 | 478 |
2496415 | 2496415 | 2022-05-12 | Coconino | Arizona | 4005 | 44091 | 478 |
2493157 | 2493157 | 2022-05-11 | Coconino | Arizona | 4005 | 44091 | 478 |
2489899 | 2489899 | 2022-05-10 | Coconino | Arizona | 4005 | 43931 | 478 |
2486642 | 2486642 | 2022-05-09 | Coconino | Arizona | 4005 | 43931 | 478 |
2483384 | 2483384 | 2022-05-08 | Coconino | Arizona | 4005 | 43931 | 478 |
2480126 | 2480126 | 2022-05-07 | Coconino | Arizona | 4005 | 43931 | 478 |
2476868 | 2476868 | 2022-05-06 | Coconino | Arizona | 4005 | 43931 | 478 |
2473610 | 2473610 | 2022-05-05 | Coconino | Arizona | 4005 | 43931 | 478 |
2470353 | 2470353 | 2022-05-04 | Coconino | Arizona | 4005 | 43931 | 478 |
2467097 | 2467097 | 2022-05-03 | Coconino | Arizona | 4005 | 43766 | 477 |
2463842 | 2463842 | 2022-05-02 | Coconino | Arizona | 4005 | 43766 | 477 |
2460586 | 2460586 | 2022-05-01 | Coconino | Arizona | 4005 | 43766 | 477 |
2457330 | 2457330 | 2022-04-30 | Coconino | Arizona | 4005 | 43766 | 477 |
2454074 | 2454074 | 2022-04-29 | Coconino | Arizona | 4005 | 43766 | 477 |
2450818 | 2450818 | 2022-04-28 | Coconino | Arizona | 4005 | 43766 | 477 |
2447562 | 2447562 | 2022-04-27 | Coconino | Arizona | 4005 | 43766 | 477 |
2444306 | 2444306 | 2022-04-26 | Coconino | Arizona | 4005 | 43638 | 472 |
2441050 | 2441050 | 2022-04-25 | Coconino | Arizona | 4005 | 43638 | 472 |
2437794 | 2437794 | 2022-04-24 | Coconino | Arizona | 4005 | 43638 | 472 |
2434538 | 2434538 | 2022-04-23 | Coconino | Arizona | 4005 | 43638 | 472 |
2431282 | 2431282 | 2022-04-22 | Coconino | Arizona | 4005 | 43638 | 472 |
2428026 | 2428026 | 2022-04-21 | Coconino | Arizona | 4005 | 43638 | 472 |
2424770 | 2424770 | 2022-04-20 | Coconino | Arizona | 4005 | 43638 | 472 |
2421514 | 2421514 | 2022-04-19 | Coconino | Arizona | 4005 | 43590 | 472 |
2418258 | 2418258 | 2022-04-18 | Coconino | Arizona | 4005 | 43590 | 472 |
2415002 | 2415002 | 2022-04-17 | Coconino | Arizona | 4005 | 43590 | 472 |
2411746 | 2411746 | 2022-04-16 | Coconino | Arizona | 4005 | 43590 | 472 |
2408490 | 2408490 | 2022-04-15 | Coconino | Arizona | 4005 | 43590 | 472 |
2405234 | 2405234 | 2022-04-14 | Coconino | Arizona | 4005 | 43590 | 472 |
2401979 | 2401979 | 2022-04-13 | Coconino | Arizona | 4005 | 43590 | 472 |
2398724 | 2398724 | 2022-04-12 | Coconino | Arizona | 4005 | 43529 | 472 |
2395469 | 2395469 | 2022-04-11 | Coconino | Arizona | 4005 | 43529 | 472 |
2392213 | 2392213 | 2022-04-10 | Coconino | Arizona | 4005 | 43529 | 472 |
2388957 | 2388957 | 2022-04-09 | Coconino | Arizona | 4005 | 43529 | 472 |
2385702 | 2385702 | 2022-04-08 | Coconino | Arizona | 4005 | 43529 | 472 |
2382447 | 2382447 | 2022-04-07 | Coconino | Arizona | 4005 | 43529 | 472 |
2379192 | 2379192 | 2022-04-06 | Coconino | Arizona | 4005 | 43529 | 472 |
2375938 | 2375938 | 2022-04-05 | Coconino | Arizona | 4005 | 43404 | 469 |
2372686 | 2372686 | 2022-04-04 | Coconino | Arizona | 4005 | 43404 | 469 |
2369433 | 2369433 | 2022-04-03 | Coconino | Arizona | 4005 | 43404 | 469 |
2366180 | 2366180 | 2022-04-02 | Coconino | Arizona | 4005 | 43404 | 469 |
2362927 | 2362927 | 2022-04-01 | Coconino | Arizona | 4005 | 43404 | 469 |
2359673 | 2359673 | 2022-03-31 | Coconino | Arizona | 4005 | 43404 | 469 |
2356419 | 2356419 | 2022-03-30 | Coconino | Arizona | 4005 | 43404 | 469 |
2353166 | 2353166 | 2022-03-29 | Coconino | Arizona | 4005 | 43311 | 463 |
2349914 | 2349914 | 2022-03-28 | Coconino | Arizona | 4005 | 43311 | 463 |
2346661 | 2346661 | 2022-03-27 | Coconino | Arizona | 4005 | 43311 | 463 |
2343408 | 2343408 | 2022-03-26 | Coconino | Arizona | 4005 | 43311 | 463 |
2340155 | 2340155 | 2022-03-25 | Coconino | Arizona | 4005 | 43311 | 463 |
2336902 | 2336902 | 2022-03-24 | Coconino | Arizona | 4005 | 43311 | 463 |
2333648 | 2333648 | 2022-03-23 | Coconino | Arizona | 4005 | 43311 | 463 |
2330394 | 2330394 | 2022-03-22 | Coconino | Arizona | 4005 | 43272 | 459 |
2327142 | 2327142 | 2022-03-21 | Coconino | Arizona | 4005 | 43272 | 459 |
2323889 | 2323889 | 2022-03-20 | Coconino | Arizona | 4005 | 43272 | 459 |
2320635 | 2320635 | 2022-03-19 | Coconino | Arizona | 4005 | 43272 | 459 |
2317381 | 2317381 | 2022-03-18 | Coconino | Arizona | 4005 | 43272 | 459 |
2314128 | 2314128 | 2022-03-17 | Coconino | Arizona | 4005 | 43272 | 459 |
2310875 | 2310875 | 2022-03-16 | Coconino | Arizona | 4005 | 43272 | 459 |
2307622 | 2307622 | 2022-03-15 | Coconino | Arizona | 4005 | 43213 | 456 |
2304371 | 2304371 | 2022-03-14 | Coconino | Arizona | 4005 | 43213 | 456 |
2301119 | 2301119 | 2022-03-13 | Coconino | Arizona | 4005 | 43213 | 456 |
2297867 | 2297867 | 2022-03-12 | Coconino | Arizona | 4005 | 43213 | 456 |
2294615 | 2294615 | 2022-03-11 | Coconino | Arizona | 4005 | 43213 | 456 |
2291363 | 2291363 | 2022-03-10 | Coconino | Arizona | 4005 | 43213 | 456 |
2288111 | 2288111 | 2022-03-09 | Coconino | Arizona | 4005 | 43213 | 456 |
2284859 | 2284859 | 2022-03-08 | Coconino | Arizona | 4005 | 43086 | 454 |
2281607 | 2281607 | 2022-03-07 | Coconino | Arizona | 4005 | 43086 | 454 |
2278354 | 2278354 | 2022-03-06 | Coconino | Arizona | 4005 | 43086 | 454 |
2275101 | 2275101 | 2022-03-05 | Coconino | Arizona | 4005 | 43086 | 454 |
2271848 | 2271848 | 2022-03-04 | Coconino | Arizona | 4005 | 43086 | 454 |
2268596 | 2268596 | 2022-03-03 | Coconino | Arizona | 4005 | 43086 | 454 |
2265343 | 2265343 | 2022-03-02 | Coconino | Arizona | 4005 | 43086 | 454 |
2262093 | 2262093 | 2022-03-01 | Coconino | Arizona | 4005 | 43023 | 453 |
2258842 | 2258842 | 2022-02-28 | Coconino | Arizona | 4005 | 43023 | 453 |
2255591 | 2255591 | 2022-02-27 | Coconino | Arizona | 4005 | 43023 | 453 |
2252340 | 2252340 | 2022-02-26 | Coconino | Arizona | 4005 | 43023 | 453 |
2249089 | 2249089 | 2022-02-25 | Coconino | Arizona | 4005 | 42996 | 453 |
2245838 | 2245838 | 2022-02-24 | Coconino | Arizona | 4005 | 42963 | 453 |
2242587 | 2242587 | 2022-02-23 | Coconino | Arizona | 4005 | 42910 | 453 |
2239336 | 2239336 | 2022-02-22 | Coconino | Arizona | 4005 | 42888 | 453 |
2236085 | 2236085 | 2022-02-21 | Coconino | Arizona | 4005 | 42855 | 452 |
2232834 | 2232834 | 2022-02-20 | Coconino | Arizona | 4005 | 42853 | 452 |
2229583 | 2229583 | 2022-02-19 | Coconino | Arizona | 4005 | 42825 | 452 |
2226332 | 2226332 | 2022-02-18 | Coconino | Arizona | 4005 | 42761 | 452 |
2223081 | 2223081 | 2022-02-17 | Coconino | Arizona | 4005 | 42720 | 451 |
2219830 | 2219830 | 2022-02-16 | Coconino | Arizona | 4005 | 42650 | 449 |
2216579 | 2216579 | 2022-02-15 | Coconino | Arizona | 4005 | 42581 | 448 |
2213328 | 2213328 | 2022-02-14 | Coconino | Arizona | 4005 | 42555 | 448 |
2210076 | 2210076 | 2022-02-13 | Coconino | Arizona | 4005 | 42515 | 448 |
2206823 | 2206823 | 2022-02-12 | Coconino | Arizona | 4005 | 42290 | 448 |
2203570 | 2203570 | 2022-02-11 | Coconino | Arizona | 4005 | 42207 | 448 |
2200316 | 2200316 | 2022-02-10 | Coconino | Arizona | 4005 | 42096 | 445 |
2197062 | 2197062 | 2022-02-09 | Coconino | Arizona | 4005 | 42007 | 445 |
2193807 | 2193807 | 2022-02-08 | Coconino | Arizona | 4005 | 41602 | 445 |
2190554 | 2190554 | 2022-02-07 | Coconino | Arizona | 4005 | 41531 | 444 |
2187301 | 2187301 | 2022-02-06 | Coconino | Arizona | 4005 | 41461 | 444 |
2184048 | 2184048 | 2022-02-05 | Coconino | Arizona | 4005 | 41343 | 444 |
2180796 | 2180796 | 2022-02-04 | Coconino | Arizona | 4005 | 41214 | 442 |
2177545 | 2177545 | 2022-02-03 | Coconino | Arizona | 4005 | 41046 | 441 |
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);