ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,561 rows where county = "Pottawatomie" 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 |
---|---|---|---|---|---|---|---|
2500547 | 2500547 | 2022-05-13 | Pottawatomie | Kansas | 20149 | 5785 | 58 |
2501795 | 2501795 | 2022-05-13 | Pottawatomie | Oklahoma | 40125 | 20703 | 284 |
2497289 | 2497289 | 2022-05-12 | Pottawatomie | Kansas | 20149 | 5760 | 58 |
2498537 | 2498537 | 2022-05-12 | Pottawatomie | Oklahoma | 40125 | 20703 | 284 |
2494031 | 2494031 | 2022-05-11 | Pottawatomie | Kansas | 20149 | 5760 | 58 |
2495279 | 2495279 | 2022-05-11 | Pottawatomie | Oklahoma | 40125 | 20679 | 284 |
2490773 | 2490773 | 2022-05-10 | Pottawatomie | Kansas | 20149 | 5760 | 58 |
2492021 | 2492021 | 2022-05-10 | Pottawatomie | Oklahoma | 40125 | 20679 | 284 |
2487516 | 2487516 | 2022-05-09 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2488763 | 2488763 | 2022-05-09 | Pottawatomie | Oklahoma | 40125 | 20679 | 284 |
2484258 | 2484258 | 2022-05-08 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2485506 | 2485506 | 2022-05-08 | Pottawatomie | Oklahoma | 40125 | 20679 | 284 |
2481000 | 2481000 | 2022-05-07 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2482248 | 2482248 | 2022-05-07 | Pottawatomie | Oklahoma | 40125 | 20679 | 284 |
2477742 | 2477742 | 2022-05-06 | Pottawatomie | Kansas | 20149 | 5760 | 57 |
2478990 | 2478990 | 2022-05-06 | Pottawatomie | Oklahoma | 40125 | 20679 | 284 |
2474484 | 2474484 | 2022-05-05 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2475732 | 2475732 | 2022-05-05 | Pottawatomie | Oklahoma | 40125 | 20679 | 284 |
2471227 | 2471227 | 2022-05-04 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2472475 | 2472475 | 2022-05-04 | Pottawatomie | Oklahoma | 40125 | 20644 | 283 |
2467971 | 2467971 | 2022-05-03 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2469219 | 2469219 | 2022-05-03 | Pottawatomie | Oklahoma | 40125 | 20644 | 283 |
2464716 | 2464716 | 2022-05-02 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2465963 | 2465963 | 2022-05-02 | Pottawatomie | Oklahoma | 40125 | 20644 | 283 |
2461460 | 2461460 | 2022-05-01 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2462708 | 2462708 | 2022-05-01 | Pottawatomie | Oklahoma | 40125 | 20644 | 283 |
2458204 | 2458204 | 2022-04-30 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2459452 | 2459452 | 2022-04-30 | Pottawatomie | Oklahoma | 40125 | 20644 | 283 |
2454948 | 2454948 | 2022-04-29 | Pottawatomie | Kansas | 20149 | 5754 | 57 |
2456196 | 2456196 | 2022-04-29 | Pottawatomie | Oklahoma | 40125 | 20644 | 283 |
2451692 | 2451692 | 2022-04-28 | Pottawatomie | Kansas | 20149 | 5741 | 57 |
2452940 | 2452940 | 2022-04-28 | Pottawatomie | Oklahoma | 40125 | 20644 | 283 |
2448436 | 2448436 | 2022-04-27 | Pottawatomie | Kansas | 20149 | 5741 | 57 |
2449684 | 2449684 | 2022-04-27 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2445180 | 2445180 | 2022-04-26 | Pottawatomie | Kansas | 20149 | 5741 | 56 |
2446427 | 2446427 | 2022-04-26 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2441924 | 2441924 | 2022-04-25 | Pottawatomie | Kansas | 20149 | 5742 | 56 |
2443172 | 2443172 | 2022-04-25 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2438668 | 2438668 | 2022-04-24 | Pottawatomie | Kansas | 20149 | 5742 | 56 |
2439916 | 2439916 | 2022-04-24 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2435412 | 2435412 | 2022-04-23 | Pottawatomie | Kansas | 20149 | 5742 | 56 |
2436660 | 2436660 | 2022-04-23 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2432156 | 2432156 | 2022-04-22 | Pottawatomie | Kansas | 20149 | 5742 | 56 |
2433404 | 2433404 | 2022-04-22 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2428900 | 2428900 | 2022-04-21 | Pottawatomie | Kansas | 20149 | 5742 | 56 |
2430148 | 2430148 | 2022-04-21 | Pottawatomie | Oklahoma | 40125 | 20620 | 282 |
2425644 | 2425644 | 2022-04-20 | Pottawatomie | Kansas | 20149 | 5742 | 56 |
2426892 | 2426892 | 2022-04-20 | Pottawatomie | Oklahoma | 40125 | 20612 | 281 |
2422388 | 2422388 | 2022-04-19 | Pottawatomie | Kansas | 20149 | 5742 | 55 |
2423636 | 2423636 | 2022-04-19 | Pottawatomie | Oklahoma | 40125 | 20612 | 281 |
2419132 | 2419132 | 2022-04-18 | Pottawatomie | Kansas | 20149 | 5742 | 55 |
2420379 | 2420379 | 2022-04-18 | Pottawatomie | Oklahoma | 40125 | 20612 | 281 |
2415876 | 2415876 | 2022-04-17 | Pottawatomie | Kansas | 20149 | 5742 | 55 |
2417124 | 2417124 | 2022-04-17 | Pottawatomie | Oklahoma | 40125 | 20612 | 281 |
2412620 | 2412620 | 2022-04-16 | Pottawatomie | Kansas | 20149 | 5742 | 55 |
2413868 | 2413868 | 2022-04-16 | Pottawatomie | Oklahoma | 40125 | 20612 | 281 |
2409364 | 2409364 | 2022-04-15 | Pottawatomie | Kansas | 20149 | 5742 | 55 |
2410612 | 2410612 | 2022-04-15 | Pottawatomie | Oklahoma | 40125 | 20612 | 281 |
2406108 | 2406108 | 2022-04-14 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2407356 | 2407356 | 2022-04-14 | Pottawatomie | Oklahoma | 40125 | 20612 | 281 |
2402852 | 2402852 | 2022-04-13 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2404100 | 2404100 | 2022-04-13 | Pottawatomie | Oklahoma | 40125 | 20603 | 280 |
2399598 | 2399598 | 2022-04-12 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2400845 | 2400845 | 2022-04-12 | Pottawatomie | Oklahoma | 40125 | 20603 | 280 |
2396342 | 2396342 | 2022-04-11 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2397590 | 2397590 | 2022-04-11 | Pottawatomie | Oklahoma | 40125 | 20603 | 280 |
2393087 | 2393087 | 2022-04-10 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2394335 | 2394335 | 2022-04-10 | Pottawatomie | Oklahoma | 40125 | 20603 | 280 |
2389831 | 2389831 | 2022-04-09 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2391079 | 2391079 | 2022-04-09 | Pottawatomie | Oklahoma | 40125 | 20603 | 280 |
2386575 | 2386575 | 2022-04-08 | Pottawatomie | Kansas | 20149 | 5737 | 55 |
2387823 | 2387823 | 2022-04-08 | Pottawatomie | Oklahoma | 40125 | 20603 | 280 |
2383321 | 2383321 | 2022-04-07 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2384568 | 2384568 | 2022-04-07 | Pottawatomie | Oklahoma | 40125 | 20603 | 280 |
2380066 | 2380066 | 2022-04-06 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2381313 | 2381313 | 2022-04-06 | Pottawatomie | Oklahoma | 40125 | 20582 | 277 |
2376811 | 2376811 | 2022-04-05 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2378058 | 2378058 | 2022-04-05 | Pottawatomie | Oklahoma | 40125 | 20582 | 277 |
2373559 | 2373559 | 2022-04-04 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2374804 | 2374804 | 2022-04-04 | Pottawatomie | Oklahoma | 40125 | 20582 | 277 |
2370306 | 2370306 | 2022-04-03 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2371552 | 2371552 | 2022-04-03 | Pottawatomie | Oklahoma | 40125 | 20582 | 277 |
2367053 | 2367053 | 2022-04-02 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2368299 | 2368299 | 2022-04-02 | Pottawatomie | Oklahoma | 40125 | 20582 | 277 |
2363800 | 2363800 | 2022-04-01 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2365046 | 2365046 | 2022-04-01 | Pottawatomie | Oklahoma | 40125 | 20582 | 277 |
2360546 | 2360546 | 2022-03-31 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2361793 | 2361793 | 2022-03-31 | Pottawatomie | Oklahoma | 40125 | 20582 | 277 |
2357292 | 2357292 | 2022-03-30 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2358539 | 2358539 | 2022-03-30 | Pottawatomie | Oklahoma | 40125 | 20562 | 274 |
2354039 | 2354039 | 2022-03-29 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2355285 | 2355285 | 2022-03-29 | Pottawatomie | Oklahoma | 40125 | 20562 | 274 |
2350787 | 2350787 | 2022-03-28 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2352032 | 2352032 | 2022-03-28 | Pottawatomie | Oklahoma | 40125 | 20562 | 274 |
2347534 | 2347534 | 2022-03-27 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2348780 | 2348780 | 2022-03-27 | Pottawatomie | Oklahoma | 40125 | 20562 | 274 |
2344281 | 2344281 | 2022-03-26 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2345527 | 2345527 | 2022-03-26 | Pottawatomie | Oklahoma | 40125 | 20562 | 274 |
2341028 | 2341028 | 2022-03-25 | Pottawatomie | Kansas | 20149 | 5730 | 55 |
2342274 | 2342274 | 2022-03-25 | Pottawatomie | Oklahoma | 40125 | 20562 | 274 |
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);