ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Scotland" and state = "North Carolina" 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 |
---|---|---|---|---|---|---|---|
2501568 | 2501568 | 2022-05-13 | Scotland | North Carolina | 37165 | 10125 | 132 |
2498310 | 2498310 | 2022-05-12 | Scotland | North Carolina | 37165 | 10125 | 132 |
2495052 | 2495052 | 2022-05-11 | Scotland | North Carolina | 37165 | 10125 | 132 |
2491794 | 2491794 | 2022-05-10 | Scotland | North Carolina | 37165 | 10067 | 132 |
2488536 | 2488536 | 2022-05-09 | Scotland | North Carolina | 37165 | 10067 | 132 |
2485279 | 2485279 | 2022-05-08 | Scotland | North Carolina | 37165 | 10067 | 132 |
2482021 | 2482021 | 2022-05-07 | Scotland | North Carolina | 37165 | 10067 | 132 |
2478763 | 2478763 | 2022-05-06 | Scotland | North Carolina | 37165 | 10067 | 132 |
2475505 | 2475505 | 2022-05-05 | Scotland | North Carolina | 37165 | 10067 | 132 |
2472248 | 2472248 | 2022-05-04 | Scotland | North Carolina | 37165 | 10067 | 132 |
2468992 | 2468992 | 2022-05-03 | Scotland | North Carolina | 37165 | 10052 | 126 |
2465736 | 2465736 | 2022-05-02 | Scotland | North Carolina | 37165 | 10052 | 126 |
2462481 | 2462481 | 2022-05-01 | Scotland | North Carolina | 37165 | 10052 | 126 |
2459225 | 2459225 | 2022-04-30 | Scotland | North Carolina | 37165 | 10052 | 126 |
2455969 | 2455969 | 2022-04-29 | Scotland | North Carolina | 37165 | 10052 | 126 |
2452713 | 2452713 | 2022-04-28 | Scotland | North Carolina | 37165 | 10052 | 126 |
2449457 | 2449457 | 2022-04-27 | Scotland | North Carolina | 37165 | 10052 | 126 |
2446200 | 2446200 | 2022-04-26 | Scotland | North Carolina | 37165 | 10021 | 126 |
2442945 | 2442945 | 2022-04-25 | Scotland | North Carolina | 37165 | 10021 | 126 |
2439689 | 2439689 | 2022-04-24 | Scotland | North Carolina | 37165 | 10021 | 126 |
2436433 | 2436433 | 2022-04-23 | Scotland | North Carolina | 37165 | 10021 | 126 |
2433177 | 2433177 | 2022-04-22 | Scotland | North Carolina | 37165 | 10021 | 126 |
2429921 | 2429921 | 2022-04-21 | Scotland | North Carolina | 37165 | 10021 | 126 |
2426665 | 2426665 | 2022-04-20 | Scotland | North Carolina | 37165 | 10021 | 126 |
2423409 | 2423409 | 2022-04-19 | Scotland | North Carolina | 37165 | 9999 | 126 |
2420152 | 2420152 | 2022-04-18 | Scotland | North Carolina | 37165 | 9999 | 126 |
2416897 | 2416897 | 2022-04-17 | Scotland | North Carolina | 37165 | 9999 | 126 |
2413641 | 2413641 | 2022-04-16 | Scotland | North Carolina | 37165 | 9999 | 126 |
2410385 | 2410385 | 2022-04-15 | Scotland | North Carolina | 37165 | 9999 | 126 |
2407129 | 2407129 | 2022-04-14 | Scotland | North Carolina | 37165 | 9999 | 126 |
2403873 | 2403873 | 2022-04-13 | Scotland | North Carolina | 37165 | 9999 | 126 |
2400618 | 2400618 | 2022-04-12 | Scotland | North Carolina | 37165 | 9987 | 126 |
2397363 | 2397363 | 2022-04-11 | Scotland | North Carolina | 37165 | 9987 | 126 |
2394108 | 2394108 | 2022-04-10 | Scotland | North Carolina | 37165 | 9987 | 126 |
2390852 | 2390852 | 2022-04-09 | Scotland | North Carolina | 37165 | 9987 | 126 |
2387596 | 2387596 | 2022-04-08 | Scotland | North Carolina | 37165 | 9987 | 126 |
2384341 | 2384341 | 2022-04-07 | Scotland | North Carolina | 37165 | 9987 | 126 |
2381086 | 2381086 | 2022-04-06 | Scotland | North Carolina | 37165 | 9987 | 126 |
2377831 | 2377831 | 2022-04-05 | Scotland | North Carolina | 37165 | 9982 | 126 |
2374578 | 2374578 | 2022-04-04 | Scotland | North Carolina | 37165 | 9977 | 126 |
2371326 | 2371326 | 2022-04-03 | Scotland | North Carolina | 37165 | 9972 | 126 |
2368073 | 2368073 | 2022-04-02 | Scotland | North Carolina | 37165 | 9972 | 126 |
2364820 | 2364820 | 2022-04-01 | Scotland | North Carolina | 37165 | 9972 | 126 |
2361566 | 2361566 | 2022-03-31 | Scotland | North Carolina | 37165 | 9972 | 126 |
2358312 | 2358312 | 2022-03-30 | Scotland | North Carolina | 37165 | 9970 | 126 |
2355058 | 2355058 | 2022-03-29 | Scotland | North Carolina | 37165 | 9966 | 126 |
2351805 | 2351805 | 2022-03-28 | Scotland | North Carolina | 37165 | 9964 | 126 |
2348553 | 2348553 | 2022-03-27 | Scotland | North Carolina | 37165 | 9960 | 126 |
2345300 | 2345300 | 2022-03-26 | Scotland | North Carolina | 37165 | 9960 | 126 |
2342047 | 2342047 | 2022-03-25 | Scotland | North Carolina | 37165 | 9960 | 126 |
2338794 | 2338794 | 2022-03-24 | Scotland | North Carolina | 37165 | 9957 | 126 |
2335540 | 2335540 | 2022-03-23 | Scotland | North Carolina | 37165 | 9954 | 126 |
2332286 | 2332286 | 2022-03-22 | Scotland | North Carolina | 37165 | 9953 | 126 |
2329033 | 2329033 | 2022-03-21 | Scotland | North Carolina | 37165 | 9951 | 126 |
2325781 | 2325781 | 2022-03-20 | Scotland | North Carolina | 37165 | 9933 | 126 |
2322528 | 2322528 | 2022-03-19 | Scotland | North Carolina | 37165 | 9933 | 126 |
2319274 | 2319274 | 2022-03-18 | Scotland | North Carolina | 37165 | 9933 | 126 |
2316020 | 2316020 | 2022-03-17 | Scotland | North Carolina | 37165 | 9924 | 126 |
2312767 | 2312767 | 2022-03-16 | Scotland | North Carolina | 37165 | 9921 | 126 |
2309514 | 2309514 | 2022-03-15 | Scotland | North Carolina | 37165 | 9914 | 126 |
2306261 | 2306261 | 2022-03-14 | Scotland | North Carolina | 37165 | 9915 | 126 |
2303010 | 2303010 | 2022-03-13 | Scotland | North Carolina | 37165 | 9904 | 126 |
2299758 | 2299758 | 2022-03-12 | Scotland | North Carolina | 37165 | 9904 | 126 |
2296506 | 2296506 | 2022-03-11 | Scotland | North Carolina | 37165 | 9904 | 126 |
2293254 | 2293254 | 2022-03-10 | Scotland | North Carolina | 37165 | 9903 | 126 |
2290002 | 2290002 | 2022-03-09 | Scotland | North Carolina | 37165 | 9899 | 126 |
2286750 | 2286750 | 2022-03-08 | Scotland | North Carolina | 37165 | 9888 | 126 |
2283498 | 2283498 | 2022-03-07 | Scotland | North Carolina | 37165 | 9885 | 126 |
2280246 | 2280246 | 2022-03-06 | Scotland | North Carolina | 37165 | 9879 | 126 |
2276993 | 2276993 | 2022-03-05 | Scotland | North Carolina | 37165 | 9879 | 126 |
2273740 | 2273740 | 2022-03-04 | Scotland | North Carolina | 37165 | 9879 | 126 |
2270487 | 2270487 | 2022-03-03 | Scotland | North Carolina | 37165 | 9876 | 126 |
2267235 | 2267235 | 2022-03-02 | Scotland | North Carolina | 37165 | 9872 | 126 |
2263983 | 2263983 | 2022-03-01 | Scotland | North Carolina | 37165 | 9863 | 126 |
2260732 | 2260732 | 2022-02-28 | Scotland | North Carolina | 37165 | 9861 | 126 |
2257481 | 2257481 | 2022-02-27 | Scotland | North Carolina | 37165 | 9854 | 126 |
2254230 | 2254230 | 2022-02-26 | Scotland | North Carolina | 37165 | 9854 | 126 |
2250979 | 2250979 | 2022-02-25 | Scotland | North Carolina | 37165 | 9854 | 126 |
2247728 | 2247728 | 2022-02-24 | Scotland | North Carolina | 37165 | 9853 | 126 |
2244477 | 2244477 | 2022-02-23 | Scotland | North Carolina | 37165 | 9844 | 126 |
2241226 | 2241226 | 2022-02-22 | Scotland | North Carolina | 37165 | 9835 | 126 |
2237975 | 2237975 | 2022-02-21 | Scotland | North Carolina | 37165 | 9825 | 126 |
2234724 | 2234724 | 2022-02-20 | Scotland | North Carolina | 37165 | 9811 | 126 |
2231473 | 2231473 | 2022-02-19 | Scotland | North Carolina | 37165 | 9811 | 126 |
2228222 | 2228222 | 2022-02-18 | Scotland | North Carolina | 37165 | 9811 | 126 |
2224971 | 2224971 | 2022-02-17 | Scotland | North Carolina | 37165 | 9794 | 126 |
2221720 | 2221720 | 2022-02-16 | Scotland | North Carolina | 37165 | 9777 | 126 |
2218469 | 2218469 | 2022-02-15 | Scotland | North Carolina | 37165 | 9764 | 124 |
2215218 | 2215218 | 2022-02-14 | Scotland | North Carolina | 37165 | 9758 | 124 |
2211967 | 2211967 | 2022-02-13 | Scotland | North Carolina | 37165 | 9732 | 124 |
2208714 | 2208714 | 2022-02-12 | Scotland | North Carolina | 37165 | 9732 | 124 |
2205461 | 2205461 | 2022-02-11 | Scotland | North Carolina | 37165 | 9732 | 124 |
2202208 | 2202208 | 2022-02-10 | Scotland | North Carolina | 37165 | 9709 | 124 |
2198954 | 2198954 | 2022-02-09 | Scotland | North Carolina | 37165 | 9684 | 124 |
2195700 | 2195700 | 2022-02-08 | Scotland | North Carolina | 37165 | 9651 | 123 |
2192446 | 2192446 | 2022-02-07 | Scotland | North Carolina | 37165 | 9641 | 123 |
2189192 | 2189192 | 2022-02-06 | Scotland | North Carolina | 37165 | 9584 | 122 |
2185939 | 2185939 | 2022-02-05 | Scotland | North Carolina | 37165 | 9584 | 122 |
2182687 | 2182687 | 2022-02-04 | Scotland | North Carolina | 37165 | 9584 | 122 |
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);