ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,550 rows where county = "Scotland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338398 | 2338398 | 2022-03-24 | Scotland | Missouri | 29199 | 682 | 18 |
2338794 | 2338794 | 2022-03-24 | Scotland | North Carolina | 37165 | 9957 | 126 |
2335144 | 2335144 | 2022-03-23 | Scotland | Missouri | 29199 | 683 | 18 |
2335540 | 2335540 | 2022-03-23 | Scotland | North Carolina | 37165 | 9954 | 126 |
2331890 | 2331890 | 2022-03-22 | Scotland | Missouri | 29199 | 682 | 18 |
2332286 | 2332286 | 2022-03-22 | Scotland | North Carolina | 37165 | 9953 | 126 |
2328637 | 2328637 | 2022-03-21 | Scotland | Missouri | 29199 | 682 | 18 |
2329033 | 2329033 | 2022-03-21 | Scotland | North Carolina | 37165 | 9951 | 126 |
2325385 | 2325385 | 2022-03-20 | Scotland | Missouri | 29199 | 682 | 18 |
2325781 | 2325781 | 2022-03-20 | Scotland | North Carolina | 37165 | 9933 | 126 |
2322131 | 2322131 | 2022-03-19 | Scotland | Missouri | 29199 | 682 | 18 |
2322528 | 2322528 | 2022-03-19 | Scotland | North Carolina | 37165 | 9933 | 126 |
2318877 | 2318877 | 2022-03-18 | Scotland | Missouri | 29199 | 682 | 18 |
2319274 | 2319274 | 2022-03-18 | Scotland | North Carolina | 37165 | 9933 | 126 |
2315624 | 2315624 | 2022-03-17 | Scotland | Missouri | 29199 | 682 | 18 |
2316020 | 2316020 | 2022-03-17 | Scotland | North Carolina | 37165 | 9924 | 126 |
2312371 | 2312371 | 2022-03-16 | Scotland | Missouri | 29199 | 682 | 18 |
2312767 | 2312767 | 2022-03-16 | Scotland | North Carolina | 37165 | 9921 | 126 |
2309118 | 2309118 | 2022-03-15 | Scotland | Missouri | 29199 | 682 | 18 |
2309514 | 2309514 | 2022-03-15 | Scotland | North Carolina | 37165 | 9914 | 126 |
2305866 | 2305866 | 2022-03-14 | Scotland | Missouri | 29199 | 682 | 18 |
2306261 | 2306261 | 2022-03-14 | Scotland | North Carolina | 37165 | 9915 | 126 |
2302615 | 2302615 | 2022-03-13 | Scotland | Missouri | 29199 | 682 | 18 |
2303010 | 2303010 | 2022-03-13 | Scotland | North Carolina | 37165 | 9904 | 126 |
2299363 | 2299363 | 2022-03-12 | Scotland | Missouri | 29199 | 682 | 18 |
2299758 | 2299758 | 2022-03-12 | Scotland | North Carolina | 37165 | 9904 | 126 |
2296111 | 2296111 | 2022-03-11 | Scotland | Missouri | 29199 | 682 | 18 |
2296506 | 2296506 | 2022-03-11 | Scotland | North Carolina | 37165 | 9904 | 126 |
2292859 | 2292859 | 2022-03-10 | Scotland | Missouri | 29199 | 682 | 18 |
2293254 | 2293254 | 2022-03-10 | Scotland | North Carolina | 37165 | 9903 | 126 |
2289607 | 2289607 | 2022-03-09 | Scotland | Missouri | 29199 | 682 | 18 |
2290002 | 2290002 | 2022-03-09 | Scotland | North Carolina | 37165 | 9899 | 126 |
2286355 | 2286355 | 2022-03-08 | Scotland | Missouri | 29199 | 682 | 18 |
2286750 | 2286750 | 2022-03-08 | Scotland | North Carolina | 37165 | 9888 | 126 |
2283103 | 2283103 | 2022-03-07 | Scotland | Missouri | 29199 | 682 | 18 |
2283498 | 2283498 | 2022-03-07 | Scotland | North Carolina | 37165 | 9885 | 126 |
2279850 | 2279850 | 2022-03-06 | Scotland | Missouri | 29199 | 682 | 18 |
2280246 | 2280246 | 2022-03-06 | Scotland | North Carolina | 37165 | 9879 | 126 |
2276597 | 2276597 | 2022-03-05 | Scotland | Missouri | 29199 | 682 | 18 |
2276993 | 2276993 | 2022-03-05 | Scotland | North Carolina | 37165 | 9879 | 126 |
2273344 | 2273344 | 2022-03-04 | Scotland | Missouri | 29199 | 682 | 18 |
2273740 | 2273740 | 2022-03-04 | Scotland | North Carolina | 37165 | 9879 | 126 |
2270092 | 2270092 | 2022-03-03 | Scotland | Missouri | 29199 | 683 | 18 |
2270487 | 2270487 | 2022-03-03 | Scotland | North Carolina | 37165 | 9876 | 126 |
2266839 | 2266839 | 2022-03-02 | Scotland | Missouri | 29199 | 683 | 18 |
2267235 | 2267235 | 2022-03-02 | Scotland | North Carolina | 37165 | 9872 | 126 |
2263588 | 2263588 | 2022-03-01 | Scotland | Missouri | 29199 | 682 | 18 |
2263983 | 2263983 | 2022-03-01 | Scotland | North Carolina | 37165 | 9863 | 126 |
2260337 | 2260337 | 2022-02-28 | Scotland | Missouri | 29199 | 682 | 18 |
2260732 | 2260732 | 2022-02-28 | Scotland | North Carolina | 37165 | 9861 | 126 |
2257086 | 2257086 | 2022-02-27 | Scotland | Missouri | 29199 | 682 | 18 |
2257481 | 2257481 | 2022-02-27 | Scotland | North Carolina | 37165 | 9854 | 126 |
2253835 | 2253835 | 2022-02-26 | Scotland | Missouri | 29199 | 682 | 18 |
2254230 | 2254230 | 2022-02-26 | Scotland | North Carolina | 37165 | 9854 | 126 |
2250584 | 2250584 | 2022-02-25 | Scotland | Missouri | 29199 | 682 | 18 |
2250979 | 2250979 | 2022-02-25 | Scotland | North Carolina | 37165 | 9854 | 126 |
2247333 | 2247333 | 2022-02-24 | Scotland | Missouri | 29199 | 682 | 18 |
2247728 | 2247728 | 2022-02-24 | Scotland | North Carolina | 37165 | 9853 | 126 |
2244082 | 2244082 | 2022-02-23 | Scotland | Missouri | 29199 | 681 | 17 |
2244477 | 2244477 | 2022-02-23 | Scotland | North Carolina | 37165 | 9844 | 126 |
2240831 | 2240831 | 2022-02-22 | Scotland | Missouri | 29199 | 680 | 17 |
2241226 | 2241226 | 2022-02-22 | Scotland | North Carolina | 37165 | 9835 | 126 |
2237580 | 2237580 | 2022-02-21 | Scotland | Missouri | 29199 | 680 | 17 |
2237975 | 2237975 | 2022-02-21 | Scotland | North Carolina | 37165 | 9825 | 126 |
2234329 | 2234329 | 2022-02-20 | Scotland | Missouri | 29199 | 680 | 17 |
2234724 | 2234724 | 2022-02-20 | Scotland | North Carolina | 37165 | 9811 | 126 |
2231078 | 2231078 | 2022-02-19 | Scotland | Missouri | 29199 | 680 | 17 |
2231473 | 2231473 | 2022-02-19 | Scotland | North Carolina | 37165 | 9811 | 126 |
2227827 | 2227827 | 2022-02-18 | Scotland | Missouri | 29199 | 680 | 17 |
2228222 | 2228222 | 2022-02-18 | Scotland | North Carolina | 37165 | 9811 | 126 |
2224576 | 2224576 | 2022-02-17 | Scotland | Missouri | 29199 | 677 | 17 |
2224971 | 2224971 | 2022-02-17 | Scotland | North Carolina | 37165 | 9794 | 126 |
2221325 | 2221325 | 2022-02-16 | Scotland | Missouri | 29199 | 672 | 17 |
2221720 | 2221720 | 2022-02-16 | Scotland | North Carolina | 37165 | 9777 | 126 |
2218074 | 2218074 | 2022-02-15 | Scotland | Missouri | 29199 | 672 | 17 |
2218469 | 2218469 | 2022-02-15 | Scotland | North Carolina | 37165 | 9764 | 124 |
2214823 | 2214823 | 2022-02-14 | Scotland | Missouri | 29199 | 669 | 17 |
2215218 | 2215218 | 2022-02-14 | Scotland | North Carolina | 37165 | 9758 | 124 |
2211571 | 2211571 | 2022-02-13 | Scotland | Missouri | 29199 | 667 | 17 |
2211967 | 2211967 | 2022-02-13 | Scotland | North Carolina | 37165 | 9732 | 124 |
2208318 | 2208318 | 2022-02-12 | Scotland | Missouri | 29199 | 667 | 17 |
2208714 | 2208714 | 2022-02-12 | Scotland | North Carolina | 37165 | 9732 | 124 |
2205065 | 2205065 | 2022-02-11 | Scotland | Missouri | 29199 | 667 | 17 |
2205461 | 2205461 | 2022-02-11 | Scotland | North Carolina | 37165 | 9732 | 124 |
2201812 | 2201812 | 2022-02-10 | Scotland | Missouri | 29199 | 667 | 17 |
2202208 | 2202208 | 2022-02-10 | Scotland | North Carolina | 37165 | 9709 | 124 |
2198558 | 2198558 | 2022-02-09 | Scotland | Missouri | 29199 | 664 | 17 |
2198954 | 2198954 | 2022-02-09 | Scotland | North Carolina | 37165 | 9684 | 124 |
2195304 | 2195304 | 2022-02-08 | Scotland | Missouri | 29199 | 657 | 17 |
2195700 | 2195700 | 2022-02-08 | Scotland | North Carolina | 37165 | 9651 | 123 |
2192050 | 2192050 | 2022-02-07 | Scotland | Missouri | 29199 | 649 | 17 |
2192446 | 2192446 | 2022-02-07 | Scotland | North Carolina | 37165 | 9641 | 123 |
2188797 | 2188797 | 2022-02-06 | Scotland | Missouri | 29199 | 648 | 17 |
2189192 | 2189192 | 2022-02-06 | Scotland | North Carolina | 37165 | 9584 | 122 |
2185544 | 2185544 | 2022-02-05 | Scotland | Missouri | 29199 | 647 | 17 |
2185939 | 2185939 | 2022-02-05 | Scotland | North Carolina | 37165 | 9584 | 122 |
2182292 | 2182292 | 2022-02-04 | Scotland | Missouri | 29199 | 646 | 17 |
2182687 | 2182687 | 2022-02-04 | Scotland | North Carolina | 37165 | 9584 | 122 |
2179040 | 2179040 | 2022-02-03 | Scotland | Missouri | 29199 | 645 | 17 |
2179435 | 2179435 | 2022-02-03 | Scotland | North Carolina | 37165 | 9548 | 118 |
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);