ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Pratt" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500548 | 2500548 | 2022-05-13 | Pratt | Kansas | 20151 | 1931 | 30 |
2497290 | 2497290 | 2022-05-12 | Pratt | Kansas | 20151 | 1930 | 30 |
2494032 | 2494032 | 2022-05-11 | Pratt | Kansas | 20151 | 1930 | 30 |
2490774 | 2490774 | 2022-05-10 | Pratt | Kansas | 20151 | 1930 | 30 |
2487517 | 2487517 | 2022-05-09 | Pratt | Kansas | 20151 | 1930 | 30 |
2484259 | 2484259 | 2022-05-08 | Pratt | Kansas | 20151 | 1930 | 30 |
2481001 | 2481001 | 2022-05-07 | Pratt | Kansas | 20151 | 1930 | 30 |
2477743 | 2477743 | 2022-05-06 | Pratt | Kansas | 20151 | 1930 | 30 |
2474485 | 2474485 | 2022-05-05 | Pratt | Kansas | 20151 | 1926 | 30 |
2471228 | 2471228 | 2022-05-04 | Pratt | Kansas | 20151 | 1926 | 30 |
2467972 | 2467972 | 2022-05-03 | Pratt | Kansas | 20151 | 1926 | 30 |
2464717 | 2464717 | 2022-05-02 | Pratt | Kansas | 20151 | 1926 | 30 |
2461461 | 2461461 | 2022-05-01 | Pratt | Kansas | 20151 | 1926 | 30 |
2458205 | 2458205 | 2022-04-30 | Pratt | Kansas | 20151 | 1926 | 30 |
2454949 | 2454949 | 2022-04-29 | Pratt | Kansas | 20151 | 1926 | 30 |
2451693 | 2451693 | 2022-04-28 | Pratt | Kansas | 20151 | 1924 | 30 |
2448437 | 2448437 | 2022-04-27 | Pratt | Kansas | 20151 | 1924 | 30 |
2445181 | 2445181 | 2022-04-26 | Pratt | Kansas | 20151 | 1924 | 30 |
2441925 | 2441925 | 2022-04-25 | Pratt | Kansas | 20151 | 1924 | 30 |
2438669 | 2438669 | 2022-04-24 | Pratt | Kansas | 20151 | 1924 | 30 |
2435413 | 2435413 | 2022-04-23 | Pratt | Kansas | 20151 | 1924 | 30 |
2432157 | 2432157 | 2022-04-22 | Pratt | Kansas | 20151 | 1924 | 30 |
2428901 | 2428901 | 2022-04-21 | Pratt | Kansas | 20151 | 1924 | 30 |
2425645 | 2425645 | 2022-04-20 | Pratt | Kansas | 20151 | 1924 | 30 |
2422389 | 2422389 | 2022-04-19 | Pratt | Kansas | 20151 | 1924 | 30 |
2419133 | 2419133 | 2022-04-18 | Pratt | Kansas | 20151 | 1924 | 30 |
2415877 | 2415877 | 2022-04-17 | Pratt | Kansas | 20151 | 1924 | 30 |
2412621 | 2412621 | 2022-04-16 | Pratt | Kansas | 20151 | 1924 | 30 |
2409365 | 2409365 | 2022-04-15 | Pratt | Kansas | 20151 | 1924 | 30 |
2406109 | 2406109 | 2022-04-14 | Pratt | Kansas | 20151 | 1923 | 30 |
2402853 | 2402853 | 2022-04-13 | Pratt | Kansas | 20151 | 1923 | 30 |
2399599 | 2399599 | 2022-04-12 | Pratt | Kansas | 20151 | 1923 | 30 |
2396343 | 2396343 | 2022-04-11 | Pratt | Kansas | 20151 | 1923 | 30 |
2393088 | 2393088 | 2022-04-10 | Pratt | Kansas | 20151 | 1923 | 30 |
2389832 | 2389832 | 2022-04-09 | Pratt | Kansas | 20151 | 1923 | 30 |
2386576 | 2386576 | 2022-04-08 | Pratt | Kansas | 20151 | 1923 | 30 |
2383322 | 2383322 | 2022-04-07 | Pratt | Kansas | 20151 | 1923 | 30 |
2380067 | 2380067 | 2022-04-06 | Pratt | Kansas | 20151 | 1923 | 30 |
2376812 | 2376812 | 2022-04-05 | Pratt | Kansas | 20151 | 1923 | 30 |
2373560 | 2373560 | 2022-04-04 | Pratt | Kansas | 20151 | 1923 | 30 |
2370307 | 2370307 | 2022-04-03 | Pratt | Kansas | 20151 | 1923 | 30 |
2367054 | 2367054 | 2022-04-02 | Pratt | Kansas | 20151 | 1923 | 30 |
2363801 | 2363801 | 2022-04-01 | Pratt | Kansas | 20151 | 1923 | 30 |
2360547 | 2360547 | 2022-03-31 | Pratt | Kansas | 20151 | 1923 | 30 |
2357293 | 2357293 | 2022-03-30 | Pratt | Kansas | 20151 | 1923 | 30 |
2354040 | 2354040 | 2022-03-29 | Pratt | Kansas | 20151 | 1923 | 30 |
2350788 | 2350788 | 2022-03-28 | Pratt | Kansas | 20151 | 1923 | 30 |
2347535 | 2347535 | 2022-03-27 | Pratt | Kansas | 20151 | 1923 | 30 |
2344282 | 2344282 | 2022-03-26 | Pratt | Kansas | 20151 | 1923 | 30 |
2341029 | 2341029 | 2022-03-25 | Pratt | Kansas | 20151 | 1923 | 30 |
2337776 | 2337776 | 2022-03-24 | Pratt | Kansas | 20151 | 1923 | 30 |
2334522 | 2334522 | 2022-03-23 | Pratt | Kansas | 20151 | 1923 | 30 |
2331268 | 2331268 | 2022-03-22 | Pratt | Kansas | 20151 | 1925 | 30 |
2328016 | 2328016 | 2022-03-21 | Pratt | Kansas | 20151 | 1925 | 30 |
2324763 | 2324763 | 2022-03-20 | Pratt | Kansas | 20151 | 1925 | 30 |
2321509 | 2321509 | 2022-03-19 | Pratt | Kansas | 20151 | 1925 | 30 |
2318255 | 2318255 | 2022-03-18 | Pratt | Kansas | 20151 | 1925 | 30 |
2315002 | 2315002 | 2022-03-17 | Pratt | Kansas | 20151 | 1925 | 30 |
2311749 | 2311749 | 2022-03-16 | Pratt | Kansas | 20151 | 1925 | 30 |
2308496 | 2308496 | 2022-03-15 | Pratt | Kansas | 20151 | 1925 | 30 |
2305245 | 2305245 | 2022-03-14 | Pratt | Kansas | 20151 | 1925 | 30 |
2301993 | 2301993 | 2022-03-13 | Pratt | Kansas | 20151 | 1925 | 30 |
2298741 | 2298741 | 2022-03-12 | Pratt | Kansas | 20151 | 1925 | 30 |
2295489 | 2295489 | 2022-03-11 | Pratt | Kansas | 20151 | 1925 | 30 |
2292237 | 2292237 | 2022-03-10 | Pratt | Kansas | 20151 | 1925 | 30 |
2288985 | 2288985 | 2022-03-09 | Pratt | Kansas | 20151 | 1925 | 30 |
2285734 | 2285734 | 2022-03-08 | Pratt | Kansas | 20151 | 1925 | 30 |
2282482 | 2282482 | 2022-03-07 | Pratt | Kansas | 20151 | 1925 | 30 |
2279229 | 2279229 | 2022-03-06 | Pratt | Kansas | 20151 | 1924 | 30 |
2275976 | 2275976 | 2022-03-05 | Pratt | Kansas | 20151 | 1924 | 30 |
2272723 | 2272723 | 2022-03-04 | Pratt | Kansas | 20151 | 1924 | 30 |
2269471 | 2269471 | 2022-03-03 | Pratt | Kansas | 20151 | 1923 | 30 |
2266218 | 2266218 | 2022-03-02 | Pratt | Kansas | 20151 | 1923 | 30 |
2262967 | 2262967 | 2022-03-01 | Pratt | Kansas | 20151 | 1918 | 30 |
2259716 | 2259716 | 2022-02-28 | Pratt | Kansas | 20151 | 1918 | 30 |
2256465 | 2256465 | 2022-02-27 | Pratt | Kansas | 20151 | 1918 | 30 |
2253214 | 2253214 | 2022-02-26 | Pratt | Kansas | 20151 | 1918 | 30 |
2249963 | 2249963 | 2022-02-25 | Pratt | Kansas | 20151 | 1918 | 30 |
2246712 | 2246712 | 2022-02-24 | Pratt | Kansas | 20151 | 1918 | 30 |
2243461 | 2243461 | 2022-02-23 | Pratt | Kansas | 20151 | 1918 | 30 |
2240210 | 2240210 | 2022-02-22 | Pratt | Kansas | 20151 | 1913 | 30 |
2236959 | 2236959 | 2022-02-21 | Pratt | Kansas | 20151 | 1913 | 30 |
2233708 | 2233708 | 2022-02-20 | Pratt | Kansas | 20151 | 1912 | 30 |
2230457 | 2230457 | 2022-02-19 | Pratt | Kansas | 20151 | 1912 | 30 |
2227206 | 2227206 | 2022-02-18 | Pratt | Kansas | 20151 | 1912 | 30 |
2223955 | 2223955 | 2022-02-17 | Pratt | Kansas | 20151 | 1909 | 30 |
2220704 | 2220704 | 2022-02-16 | Pratt | Kansas | 20151 | 1909 | 30 |
2217453 | 2217453 | 2022-02-15 | Pratt | Kansas | 20151 | 1897 | 30 |
2214202 | 2214202 | 2022-02-14 | Pratt | Kansas | 20151 | 1897 | 30 |
2210950 | 2210950 | 2022-02-13 | Pratt | Kansas | 20151 | 1880 | 30 |
2207697 | 2207697 | 2022-02-12 | Pratt | Kansas | 20151 | 1880 | 30 |
2204444 | 2204444 | 2022-02-11 | Pratt | Kansas | 20151 | 1880 | 30 |
2201191 | 2201191 | 2022-02-10 | Pratt | Kansas | 20151 | 1880 | 30 |
2197937 | 2197937 | 2022-02-09 | Pratt | Kansas | 20151 | 1880 | 30 |
2194683 | 2194683 | 2022-02-08 | Pratt | Kansas | 20151 | 1859 | 30 |
2191429 | 2191429 | 2022-02-07 | Pratt | Kansas | 20151 | 1859 | 30 |
2188176 | 2188176 | 2022-02-06 | Pratt | Kansas | 20151 | 1846 | 30 |
2184923 | 2184923 | 2022-02-05 | Pratt | Kansas | 20151 | 1846 | 30 |
2181671 | 2181671 | 2022-02-04 | Pratt | Kansas | 20151 | 1846 | 30 |
2178420 | 2178420 | 2022-02-03 | Pratt | Kansas | 20151 | 1836 | 30 |
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);