ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,419 rows where county = "Prairie" 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 |
---|---|---|---|---|---|---|---|
2499744 | 2499744 | 2022-05-13 | Prairie | Arkansas | 5117 | 1965 | 43 |
2501232 | 2501232 | 2022-05-13 | Prairie | Montana | 30079 | 263 | 3 |
2496486 | 2496486 | 2022-05-12 | Prairie | Arkansas | 5117 | 1964 | 43 |
2497974 | 2497974 | 2022-05-12 | Prairie | Montana | 30079 | 263 | 3 |
2493228 | 2493228 | 2022-05-11 | Prairie | Arkansas | 5117 | 1964 | 43 |
2494716 | 2494716 | 2022-05-11 | Prairie | Montana | 30079 | 263 | 3 |
2489970 | 2489970 | 2022-05-10 | Prairie | Arkansas | 5117 | 1964 | 43 |
2491458 | 2491458 | 2022-05-10 | Prairie | Montana | 30079 | 263 | 3 |
2486713 | 2486713 | 2022-05-09 | Prairie | Arkansas | 5117 | 1963 | 43 |
2488200 | 2488200 | 2022-05-09 | Prairie | Montana | 30079 | 263 | 3 |
2483455 | 2483455 | 2022-05-08 | Prairie | Arkansas | 5117 | 1963 | 43 |
2484943 | 2484943 | 2022-05-08 | Prairie | Montana | 30079 | 263 | 3 |
2480197 | 2480197 | 2022-05-07 | Prairie | Arkansas | 5117 | 1963 | 43 |
2481685 | 2481685 | 2022-05-07 | Prairie | Montana | 30079 | 263 | 3 |
2476939 | 2476939 | 2022-05-06 | Prairie | Arkansas | 5117 | 1963 | 43 |
2478427 | 2478427 | 2022-05-06 | Prairie | Montana | 30079 | 263 | 3 |
2473681 | 2473681 | 2022-05-05 | Prairie | Arkansas | 5117 | 1963 | 43 |
2475169 | 2475169 | 2022-05-05 | Prairie | Montana | 30079 | 263 | 3 |
2470424 | 2470424 | 2022-05-04 | Prairie | Arkansas | 5117 | 1963 | 43 |
2471912 | 2471912 | 2022-05-04 | Prairie | Montana | 30079 | 263 | 3 |
2467168 | 2467168 | 2022-05-03 | Prairie | Arkansas | 5117 | 1963 | 43 |
2468656 | 2468656 | 2022-05-03 | Prairie | Montana | 30079 | 263 | 3 |
2463913 | 2463913 | 2022-05-02 | Prairie | Arkansas | 5117 | 1963 | 43 |
2465400 | 2465400 | 2022-05-02 | Prairie | Montana | 30079 | 263 | 3 |
2460657 | 2460657 | 2022-05-01 | Prairie | Arkansas | 5117 | 1963 | 43 |
2462145 | 2462145 | 2022-05-01 | Prairie | Montana | 30079 | 263 | 3 |
2457401 | 2457401 | 2022-04-30 | Prairie | Arkansas | 5117 | 1963 | 43 |
2458889 | 2458889 | 2022-04-30 | Prairie | Montana | 30079 | 263 | 3 |
2454145 | 2454145 | 2022-04-29 | Prairie | Arkansas | 5117 | 1963 | 43 |
2455633 | 2455633 | 2022-04-29 | Prairie | Montana | 30079 | 263 | 3 |
2450889 | 2450889 | 2022-04-28 | Prairie | Arkansas | 5117 | 1963 | 43 |
2452377 | 2452377 | 2022-04-28 | Prairie | Montana | 30079 | 263 | 3 |
2447633 | 2447633 | 2022-04-27 | Prairie | Arkansas | 5117 | 1963 | 43 |
2449121 | 2449121 | 2022-04-27 | Prairie | Montana | 30079 | 263 | 3 |
2444377 | 2444377 | 2022-04-26 | Prairie | Arkansas | 5117 | 1963 | 43 |
2445864 | 2445864 | 2022-04-26 | Prairie | Montana | 30079 | 263 | 3 |
2441121 | 2441121 | 2022-04-25 | Prairie | Arkansas | 5117 | 1963 | 43 |
2442609 | 2442609 | 2022-04-25 | Prairie | Montana | 30079 | 263 | 3 |
2437865 | 2437865 | 2022-04-24 | Prairie | Arkansas | 5117 | 1963 | 43 |
2439353 | 2439353 | 2022-04-24 | Prairie | Montana | 30079 | 263 | 3 |
2434609 | 2434609 | 2022-04-23 | Prairie | Arkansas | 5117 | 1963 | 43 |
2436097 | 2436097 | 2022-04-23 | Prairie | Montana | 30079 | 263 | 3 |
2431353 | 2431353 | 2022-04-22 | Prairie | Arkansas | 5117 | 1963 | 43 |
2432841 | 2432841 | 2022-04-22 | Prairie | Montana | 30079 | 263 | 3 |
2428097 | 2428097 | 2022-04-21 | Prairie | Arkansas | 5117 | 1963 | 43 |
2429585 | 2429585 | 2022-04-21 | Prairie | Montana | 30079 | 263 | 3 |
2424841 | 2424841 | 2022-04-20 | Prairie | Arkansas | 5117 | 1963 | 43 |
2426329 | 2426329 | 2022-04-20 | Prairie | Montana | 30079 | 263 | 3 |
2421585 | 2421585 | 2022-04-19 | Prairie | Arkansas | 5117 | 1963 | 43 |
2423073 | 2423073 | 2022-04-19 | Prairie | Montana | 30079 | 263 | 3 |
2418329 | 2418329 | 2022-04-18 | Prairie | Arkansas | 5117 | 1962 | 43 |
2419816 | 2419816 | 2022-04-18 | Prairie | Montana | 30079 | 263 | 3 |
2415073 | 2415073 | 2022-04-17 | Prairie | Arkansas | 5117 | 1962 | 43 |
2416561 | 2416561 | 2022-04-17 | Prairie | Montana | 30079 | 263 | 3 |
2411817 | 2411817 | 2022-04-16 | Prairie | Arkansas | 5117 | 1962 | 43 |
2413305 | 2413305 | 2022-04-16 | Prairie | Montana | 30079 | 263 | 3 |
2408561 | 2408561 | 2022-04-15 | Prairie | Arkansas | 5117 | 1962 | 43 |
2410049 | 2410049 | 2022-04-15 | Prairie | Montana | 30079 | 263 | 3 |
2405305 | 2405305 | 2022-04-14 | Prairie | Arkansas | 5117 | 1962 | 43 |
2406793 | 2406793 | 2022-04-14 | Prairie | Montana | 30079 | 263 | 3 |
2402050 | 2402050 | 2022-04-13 | Prairie | Arkansas | 5117 | 1961 | 43 |
2403537 | 2403537 | 2022-04-13 | Prairie | Montana | 30079 | 263 | 3 |
2398795 | 2398795 | 2022-04-12 | Prairie | Arkansas | 5117 | 1961 | 42 |
2400282 | 2400282 | 2022-04-12 | Prairie | Montana | 30079 | 263 | 3 |
2395540 | 2395540 | 2022-04-11 | Prairie | Arkansas | 5117 | 1961 | 42 |
2397027 | 2397027 | 2022-04-11 | Prairie | Montana | 30079 | 263 | 3 |
2392284 | 2392284 | 2022-04-10 | Prairie | Arkansas | 5117 | 1961 | 42 |
2393772 | 2393772 | 2022-04-10 | Prairie | Montana | 30079 | 263 | 3 |
2389028 | 2389028 | 2022-04-09 | Prairie | Arkansas | 5117 | 1961 | 42 |
2390516 | 2390516 | 2022-04-09 | Prairie | Montana | 30079 | 263 | 3 |
2385773 | 2385773 | 2022-04-08 | Prairie | Arkansas | 5117 | 1961 | 42 |
2387260 | 2387260 | 2022-04-08 | Prairie | Montana | 30079 | 263 | 3 |
2382518 | 2382518 | 2022-04-07 | Prairie | Arkansas | 5117 | 1959 | 42 |
2384005 | 2384005 | 2022-04-07 | Prairie | Montana | 30079 | 263 | 3 |
2379263 | 2379263 | 2022-04-06 | Prairie | Arkansas | 5117 | 1959 | 42 |
2380750 | 2380750 | 2022-04-06 | Prairie | Montana | 30079 | 262 | 3 |
2376009 | 2376009 | 2022-04-05 | Prairie | Arkansas | 5117 | 1959 | 42 |
2377495 | 2377495 | 2022-04-05 | Prairie | Montana | 30079 | 262 | 3 |
2372757 | 2372757 | 2022-04-04 | Prairie | Arkansas | 5117 | 1959 | 42 |
2374242 | 2374242 | 2022-04-04 | Prairie | Montana | 30079 | 262 | 3 |
2369504 | 2369504 | 2022-04-03 | Prairie | Arkansas | 5117 | 1959 | 42 |
2370990 | 2370990 | 2022-04-03 | Prairie | Montana | 30079 | 262 | 3 |
2366251 | 2366251 | 2022-04-02 | Prairie | Arkansas | 5117 | 1959 | 42 |
2367737 | 2367737 | 2022-04-02 | Prairie | Montana | 30079 | 262 | 3 |
2362998 | 2362998 | 2022-04-01 | Prairie | Arkansas | 5117 | 1959 | 42 |
2364484 | 2364484 | 2022-04-01 | Prairie | Montana | 30079 | 262 | 3 |
2359744 | 2359744 | 2022-03-31 | Prairie | Arkansas | 5117 | 1959 | 42 |
2361230 | 2361230 | 2022-03-31 | Prairie | Montana | 30079 | 262 | 3 |
2356490 | 2356490 | 2022-03-30 | Prairie | Arkansas | 5117 | 1959 | 41 |
2357976 | 2357976 | 2022-03-30 | Prairie | Montana | 30079 | 262 | 3 |
2353237 | 2353237 | 2022-03-29 | Prairie | Arkansas | 5117 | 1959 | 41 |
2354723 | 2354723 | 2022-03-29 | Prairie | Montana | 30079 | 262 | 3 |
2349985 | 2349985 | 2022-03-28 | Prairie | Arkansas | 5117 | 1959 | 41 |
2351470 | 2351470 | 2022-03-28 | Prairie | Montana | 30079 | 262 | 3 |
2346732 | 2346732 | 2022-03-27 | Prairie | Arkansas | 5117 | 1959 | 41 |
2348218 | 2348218 | 2022-03-27 | Prairie | Montana | 30079 | 262 | 3 |
2343479 | 2343479 | 2022-03-26 | Prairie | Arkansas | 5117 | 1959 | 41 |
2344965 | 2344965 | 2022-03-26 | Prairie | Montana | 30079 | 262 | 3 |
2340226 | 2340226 | 2022-03-25 | Prairie | Arkansas | 5117 | 1959 | 41 |
2341712 | 2341712 | 2022-03-25 | Prairie | Montana | 30079 | 262 | 3 |
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);