ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Johnston" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501767 | 2501767 | 2022-05-13 | Johnston | Oklahoma | 40069 | 3041 | 54 |
2498509 | 2498509 | 2022-05-12 | Johnston | Oklahoma | 40069 | 3041 | 54 |
2495251 | 2495251 | 2022-05-11 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2491993 | 2491993 | 2022-05-10 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2488735 | 2488735 | 2022-05-09 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2485478 | 2485478 | 2022-05-08 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2482220 | 2482220 | 2022-05-07 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2478962 | 2478962 | 2022-05-06 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2475704 | 2475704 | 2022-05-05 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2472447 | 2472447 | 2022-05-04 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2469191 | 2469191 | 2022-05-03 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2465935 | 2465935 | 2022-05-02 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2462680 | 2462680 | 2022-05-01 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2459424 | 2459424 | 2022-04-30 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2456168 | 2456168 | 2022-04-29 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2452912 | 2452912 | 2022-04-28 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2449656 | 2449656 | 2022-04-27 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2446399 | 2446399 | 2022-04-26 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2443144 | 2443144 | 2022-04-25 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2439888 | 2439888 | 2022-04-24 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2436632 | 2436632 | 2022-04-23 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2433376 | 2433376 | 2022-04-22 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2430120 | 2430120 | 2022-04-21 | Johnston | Oklahoma | 40069 | 3034 | 54 |
2426864 | 2426864 | 2022-04-20 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2423608 | 2423608 | 2022-04-19 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2420351 | 2420351 | 2022-04-18 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2417096 | 2417096 | 2022-04-17 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2413840 | 2413840 | 2022-04-16 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2410584 | 2410584 | 2022-04-15 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2407328 | 2407328 | 2022-04-14 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2404072 | 2404072 | 2022-04-13 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2400817 | 2400817 | 2022-04-12 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2397562 | 2397562 | 2022-04-11 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2394307 | 2394307 | 2022-04-10 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2391051 | 2391051 | 2022-04-09 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2387795 | 2387795 | 2022-04-08 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2384540 | 2384540 | 2022-04-07 | Johnston | Oklahoma | 40069 | 3029 | 53 |
2381285 | 2381285 | 2022-04-06 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2378030 | 2378030 | 2022-04-05 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2374776 | 2374776 | 2022-04-04 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2371524 | 2371524 | 2022-04-03 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2368271 | 2368271 | 2022-04-02 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2365018 | 2365018 | 2022-04-01 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2361765 | 2361765 | 2022-03-31 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2358511 | 2358511 | 2022-03-30 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2355257 | 2355257 | 2022-03-29 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2352004 | 2352004 | 2022-03-28 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2348752 | 2348752 | 2022-03-27 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2345499 | 2345499 | 2022-03-26 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2342246 | 2342246 | 2022-03-25 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2338993 | 2338993 | 2022-03-24 | Johnston | Oklahoma | 40069 | 3030 | 53 |
2335739 | 2335739 | 2022-03-23 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2332485 | 2332485 | 2022-03-22 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2329232 | 2329232 | 2022-03-21 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2325980 | 2325980 | 2022-03-20 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2322727 | 2322727 | 2022-03-19 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2319473 | 2319473 | 2022-03-18 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2316219 | 2316219 | 2022-03-17 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2312966 | 2312966 | 2022-03-16 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2309713 | 2309713 | 2022-03-15 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2306460 | 2306460 | 2022-03-14 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2303209 | 2303209 | 2022-03-13 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2299957 | 2299957 | 2022-03-12 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2296705 | 2296705 | 2022-03-11 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2293453 | 2293453 | 2022-03-10 | Johnston | Oklahoma | 40069 | 3024 | 52 |
2290201 | 2290201 | 2022-03-09 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2286949 | 2286949 | 2022-03-08 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2283697 | 2283697 | 2022-03-07 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2280445 | 2280445 | 2022-03-06 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2277192 | 2277192 | 2022-03-05 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2273939 | 2273939 | 2022-03-04 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2270686 | 2270686 | 2022-03-03 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2267434 | 2267434 | 2022-03-02 | Johnston | Oklahoma | 40069 | 2998 | 51 |
2264181 | 2264181 | 2022-03-01 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2260931 | 2260931 | 2022-02-28 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2257680 | 2257680 | 2022-02-27 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2254429 | 2254429 | 2022-02-26 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2251178 | 2251178 | 2022-02-25 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2247927 | 2247927 | 2022-02-24 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2244676 | 2244676 | 2022-02-23 | Johnston | Oklahoma | 40069 | 2981 | 49 |
2241425 | 2241425 | 2022-02-22 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2238174 | 2238174 | 2022-02-21 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2234923 | 2234923 | 2022-02-20 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2231672 | 2231672 | 2022-02-19 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2228421 | 2228421 | 2022-02-18 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2225170 | 2225170 | 2022-02-17 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2221919 | 2221919 | 2022-02-16 | Johnston | Oklahoma | 40069 | 2943 | 49 |
2218668 | 2218668 | 2022-02-15 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2215417 | 2215417 | 2022-02-14 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2212166 | 2212166 | 2022-02-13 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2208913 | 2208913 | 2022-02-12 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2205660 | 2205660 | 2022-02-11 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2202407 | 2202407 | 2022-02-10 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2199153 | 2199153 | 2022-02-09 | Johnston | Oklahoma | 40069 | 2913 | 49 |
2195899 | 2195899 | 2022-02-08 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2192645 | 2192645 | 2022-02-07 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2189391 | 2189391 | 2022-02-06 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2186138 | 2186138 | 2022-02-05 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2182886 | 2182886 | 2022-02-04 | Johnston | Oklahoma | 40069 | 2859 | 49 |
2179634 | 2179634 | 2022-02-03 | Johnston | Oklahoma | 40069 | 2859 | 49 |
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);