ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Scotland" and state = "Missouri" 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 |
---|---|---|---|---|---|---|---|
2501171 | 2501171 | 2022-05-13 | Scotland | Missouri | 29199 | 680 | 18 |
2497913 | 2497913 | 2022-05-12 | Scotland | Missouri | 29199 | 680 | 18 |
2494655 | 2494655 | 2022-05-11 | Scotland | Missouri | 29199 | 680 | 18 |
2491397 | 2491397 | 2022-05-10 | Scotland | Missouri | 29199 | 680 | 18 |
2488139 | 2488139 | 2022-05-09 | Scotland | Missouri | 29199 | 680 | 18 |
2484882 | 2484882 | 2022-05-08 | Scotland | Missouri | 29199 | 680 | 18 |
2481624 | 2481624 | 2022-05-07 | Scotland | Missouri | 29199 | 680 | 18 |
2478366 | 2478366 | 2022-05-06 | Scotland | Missouri | 29199 | 680 | 18 |
2475108 | 2475108 | 2022-05-05 | Scotland | Missouri | 29199 | 681 | 18 |
2471851 | 2471851 | 2022-05-04 | Scotland | Missouri | 29199 | 681 | 18 |
2468595 | 2468595 | 2022-05-03 | Scotland | Missouri | 29199 | 681 | 18 |
2465339 | 2465339 | 2022-05-02 | Scotland | Missouri | 29199 | 681 | 18 |
2462084 | 2462084 | 2022-05-01 | Scotland | Missouri | 29199 | 681 | 18 |
2458828 | 2458828 | 2022-04-30 | Scotland | Missouri | 29199 | 681 | 18 |
2455572 | 2455572 | 2022-04-29 | Scotland | Missouri | 29199 | 681 | 18 |
2452316 | 2452316 | 2022-04-28 | Scotland | Missouri | 29199 | 681 | 18 |
2449060 | 2449060 | 2022-04-27 | Scotland | Missouri | 29199 | 681 | 18 |
2445803 | 2445803 | 2022-04-26 | Scotland | Missouri | 29199 | 681 | 18 |
2442548 | 2442548 | 2022-04-25 | Scotland | Missouri | 29199 | 681 | 18 |
2439292 | 2439292 | 2022-04-24 | Scotland | Missouri | 29199 | 681 | 18 |
2436036 | 2436036 | 2022-04-23 | Scotland | Missouri | 29199 | 681 | 18 |
2432780 | 2432780 | 2022-04-22 | Scotland | Missouri | 29199 | 681 | 18 |
2429524 | 2429524 | 2022-04-21 | Scotland | Missouri | 29199 | 681 | 18 |
2426268 | 2426268 | 2022-04-20 | Scotland | Missouri | 29199 | 681 | 18 |
2423012 | 2423012 | 2022-04-19 | Scotland | Missouri | 29199 | 681 | 18 |
2419755 | 2419755 | 2022-04-18 | Scotland | Missouri | 29199 | 681 | 18 |
2416500 | 2416500 | 2022-04-17 | Scotland | Missouri | 29199 | 681 | 18 |
2413244 | 2413244 | 2022-04-16 | Scotland | Missouri | 29199 | 681 | 18 |
2409988 | 2409988 | 2022-04-15 | Scotland | Missouri | 29199 | 681 | 18 |
2406732 | 2406732 | 2022-04-14 | Scotland | Missouri | 29199 | 681 | 18 |
2403476 | 2403476 | 2022-04-13 | Scotland | Missouri | 29199 | 681 | 18 |
2400221 | 2400221 | 2022-04-12 | Scotland | Missouri | 29199 | 681 | 18 |
2396966 | 2396966 | 2022-04-11 | Scotland | Missouri | 29199 | 681 | 18 |
2393711 | 2393711 | 2022-04-10 | Scotland | Missouri | 29199 | 681 | 18 |
2390455 | 2390455 | 2022-04-09 | Scotland | Missouri | 29199 | 681 | 18 |
2387199 | 2387199 | 2022-04-08 | Scotland | Missouri | 29199 | 681 | 18 |
2383944 | 2383944 | 2022-04-07 | Scotland | Missouri | 29199 | 681 | 18 |
2380689 | 2380689 | 2022-04-06 | Scotland | Missouri | 29199 | 681 | 18 |
2377434 | 2377434 | 2022-04-05 | Scotland | Missouri | 29199 | 681 | 18 |
2374181 | 2374181 | 2022-04-04 | Scotland | Missouri | 29199 | 681 | 18 |
2370929 | 2370929 | 2022-04-03 | Scotland | Missouri | 29199 | 681 | 18 |
2367676 | 2367676 | 2022-04-02 | Scotland | Missouri | 29199 | 681 | 18 |
2364423 | 2364423 | 2022-04-01 | Scotland | Missouri | 29199 | 681 | 18 |
2361169 | 2361169 | 2022-03-31 | Scotland | Missouri | 29199 | 681 | 18 |
2357915 | 2357915 | 2022-03-30 | Scotland | Missouri | 29199 | 682 | 18 |
2354662 | 2354662 | 2022-03-29 | Scotland | Missouri | 29199 | 682 | 18 |
2351409 | 2351409 | 2022-03-28 | Scotland | Missouri | 29199 | 682 | 18 |
2348157 | 2348157 | 2022-03-27 | Scotland | Missouri | 29199 | 682 | 18 |
2344904 | 2344904 | 2022-03-26 | Scotland | Missouri | 29199 | 682 | 18 |
2341651 | 2341651 | 2022-03-25 | Scotland | Missouri | 29199 | 682 | 18 |
2338398 | 2338398 | 2022-03-24 | Scotland | Missouri | 29199 | 682 | 18 |
2335144 | 2335144 | 2022-03-23 | Scotland | Missouri | 29199 | 683 | 18 |
2331890 | 2331890 | 2022-03-22 | Scotland | Missouri | 29199 | 682 | 18 |
2328637 | 2328637 | 2022-03-21 | Scotland | Missouri | 29199 | 682 | 18 |
2325385 | 2325385 | 2022-03-20 | Scotland | Missouri | 29199 | 682 | 18 |
2322131 | 2322131 | 2022-03-19 | Scotland | Missouri | 29199 | 682 | 18 |
2318877 | 2318877 | 2022-03-18 | Scotland | Missouri | 29199 | 682 | 18 |
2315624 | 2315624 | 2022-03-17 | Scotland | Missouri | 29199 | 682 | 18 |
2312371 | 2312371 | 2022-03-16 | Scotland | Missouri | 29199 | 682 | 18 |
2309118 | 2309118 | 2022-03-15 | Scotland | Missouri | 29199 | 682 | 18 |
2305866 | 2305866 | 2022-03-14 | Scotland | Missouri | 29199 | 682 | 18 |
2302615 | 2302615 | 2022-03-13 | Scotland | Missouri | 29199 | 682 | 18 |
2299363 | 2299363 | 2022-03-12 | Scotland | Missouri | 29199 | 682 | 18 |
2296111 | 2296111 | 2022-03-11 | Scotland | Missouri | 29199 | 682 | 18 |
2292859 | 2292859 | 2022-03-10 | Scotland | Missouri | 29199 | 682 | 18 |
2289607 | 2289607 | 2022-03-09 | Scotland | Missouri | 29199 | 682 | 18 |
2286355 | 2286355 | 2022-03-08 | Scotland | Missouri | 29199 | 682 | 18 |
2283103 | 2283103 | 2022-03-07 | Scotland | Missouri | 29199 | 682 | 18 |
2279850 | 2279850 | 2022-03-06 | Scotland | Missouri | 29199 | 682 | 18 |
2276597 | 2276597 | 2022-03-05 | Scotland | Missouri | 29199 | 682 | 18 |
2273344 | 2273344 | 2022-03-04 | Scotland | Missouri | 29199 | 682 | 18 |
2270092 | 2270092 | 2022-03-03 | Scotland | Missouri | 29199 | 683 | 18 |
2266839 | 2266839 | 2022-03-02 | Scotland | Missouri | 29199 | 683 | 18 |
2263588 | 2263588 | 2022-03-01 | Scotland | Missouri | 29199 | 682 | 18 |
2260337 | 2260337 | 2022-02-28 | Scotland | Missouri | 29199 | 682 | 18 |
2257086 | 2257086 | 2022-02-27 | Scotland | Missouri | 29199 | 682 | 18 |
2253835 | 2253835 | 2022-02-26 | Scotland | Missouri | 29199 | 682 | 18 |
2250584 | 2250584 | 2022-02-25 | Scotland | Missouri | 29199 | 682 | 18 |
2247333 | 2247333 | 2022-02-24 | Scotland | Missouri | 29199 | 682 | 18 |
2244082 | 2244082 | 2022-02-23 | Scotland | Missouri | 29199 | 681 | 17 |
2240831 | 2240831 | 2022-02-22 | Scotland | Missouri | 29199 | 680 | 17 |
2237580 | 2237580 | 2022-02-21 | Scotland | Missouri | 29199 | 680 | 17 |
2234329 | 2234329 | 2022-02-20 | Scotland | Missouri | 29199 | 680 | 17 |
2231078 | 2231078 | 2022-02-19 | Scotland | Missouri | 29199 | 680 | 17 |
2227827 | 2227827 | 2022-02-18 | Scotland | Missouri | 29199 | 680 | 17 |
2224576 | 2224576 | 2022-02-17 | Scotland | Missouri | 29199 | 677 | 17 |
2221325 | 2221325 | 2022-02-16 | Scotland | Missouri | 29199 | 672 | 17 |
2218074 | 2218074 | 2022-02-15 | Scotland | Missouri | 29199 | 672 | 17 |
2214823 | 2214823 | 2022-02-14 | Scotland | Missouri | 29199 | 669 | 17 |
2211571 | 2211571 | 2022-02-13 | Scotland | Missouri | 29199 | 667 | 17 |
2208318 | 2208318 | 2022-02-12 | Scotland | Missouri | 29199 | 667 | 17 |
2205065 | 2205065 | 2022-02-11 | Scotland | Missouri | 29199 | 667 | 17 |
2201812 | 2201812 | 2022-02-10 | Scotland | Missouri | 29199 | 667 | 17 |
2198558 | 2198558 | 2022-02-09 | Scotland | Missouri | 29199 | 664 | 17 |
2195304 | 2195304 | 2022-02-08 | Scotland | Missouri | 29199 | 657 | 17 |
2192050 | 2192050 | 2022-02-07 | Scotland | Missouri | 29199 | 649 | 17 |
2188797 | 2188797 | 2022-02-06 | Scotland | Missouri | 29199 | 648 | 17 |
2185544 | 2185544 | 2022-02-05 | Scotland | Missouri | 29199 | 647 | 17 |
2182292 | 2182292 | 2022-02-04 | Scotland | Missouri | 29199 | 646 | 17 |
2179040 | 2179040 | 2022-02-03 | Scotland | Missouri | 29199 | 645 | 17 |
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);