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)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501171 | 2501171 | 2022-05-13 | Scotland | Missouri | 29199 | 680 | 18 |
2501568 | 2501568 | 2022-05-13 | Scotland | North Carolina | 37165 | 10125 | 132 |
2497913 | 2497913 | 2022-05-12 | Scotland | Missouri | 29199 | 680 | 18 |
2498310 | 2498310 | 2022-05-12 | Scotland | North Carolina | 37165 | 10125 | 132 |
2494655 | 2494655 | 2022-05-11 | Scotland | Missouri | 29199 | 680 | 18 |
2495052 | 2495052 | 2022-05-11 | Scotland | North Carolina | 37165 | 10125 | 132 |
2491397 | 2491397 | 2022-05-10 | Scotland | Missouri | 29199 | 680 | 18 |
2491794 | 2491794 | 2022-05-10 | Scotland | North Carolina | 37165 | 10067 | 132 |
2488139 | 2488139 | 2022-05-09 | Scotland | Missouri | 29199 | 680 | 18 |
2488536 | 2488536 | 2022-05-09 | Scotland | North Carolina | 37165 | 10067 | 132 |
2484882 | 2484882 | 2022-05-08 | Scotland | Missouri | 29199 | 680 | 18 |
2485279 | 2485279 | 2022-05-08 | Scotland | North Carolina | 37165 | 10067 | 132 |
2481624 | 2481624 | 2022-05-07 | Scotland | Missouri | 29199 | 680 | 18 |
2482021 | 2482021 | 2022-05-07 | Scotland | North Carolina | 37165 | 10067 | 132 |
2478366 | 2478366 | 2022-05-06 | Scotland | Missouri | 29199 | 680 | 18 |
2478763 | 2478763 | 2022-05-06 | Scotland | North Carolina | 37165 | 10067 | 132 |
2475108 | 2475108 | 2022-05-05 | Scotland | Missouri | 29199 | 681 | 18 |
2475505 | 2475505 | 2022-05-05 | Scotland | North Carolina | 37165 | 10067 | 132 |
2471851 | 2471851 | 2022-05-04 | Scotland | Missouri | 29199 | 681 | 18 |
2472248 | 2472248 | 2022-05-04 | Scotland | North Carolina | 37165 | 10067 | 132 |
2468595 | 2468595 | 2022-05-03 | Scotland | Missouri | 29199 | 681 | 18 |
2468992 | 2468992 | 2022-05-03 | Scotland | North Carolina | 37165 | 10052 | 126 |
2465339 | 2465339 | 2022-05-02 | Scotland | Missouri | 29199 | 681 | 18 |
2465736 | 2465736 | 2022-05-02 | Scotland | North Carolina | 37165 | 10052 | 126 |
2462084 | 2462084 | 2022-05-01 | Scotland | Missouri | 29199 | 681 | 18 |
2462481 | 2462481 | 2022-05-01 | Scotland | North Carolina | 37165 | 10052 | 126 |
2458828 | 2458828 | 2022-04-30 | Scotland | Missouri | 29199 | 681 | 18 |
2459225 | 2459225 | 2022-04-30 | Scotland | North Carolina | 37165 | 10052 | 126 |
2455572 | 2455572 | 2022-04-29 | Scotland | Missouri | 29199 | 681 | 18 |
2455969 | 2455969 | 2022-04-29 | Scotland | North Carolina | 37165 | 10052 | 126 |
2452316 | 2452316 | 2022-04-28 | Scotland | Missouri | 29199 | 681 | 18 |
2452713 | 2452713 | 2022-04-28 | Scotland | North Carolina | 37165 | 10052 | 126 |
2449060 | 2449060 | 2022-04-27 | Scotland | Missouri | 29199 | 681 | 18 |
2449457 | 2449457 | 2022-04-27 | Scotland | North Carolina | 37165 | 10052 | 126 |
2445803 | 2445803 | 2022-04-26 | Scotland | Missouri | 29199 | 681 | 18 |
2446200 | 2446200 | 2022-04-26 | Scotland | North Carolina | 37165 | 10021 | 126 |
2442548 | 2442548 | 2022-04-25 | Scotland | Missouri | 29199 | 681 | 18 |
2442945 | 2442945 | 2022-04-25 | Scotland | North Carolina | 37165 | 10021 | 126 |
2439292 | 2439292 | 2022-04-24 | Scotland | Missouri | 29199 | 681 | 18 |
2439689 | 2439689 | 2022-04-24 | Scotland | North Carolina | 37165 | 10021 | 126 |
2436036 | 2436036 | 2022-04-23 | Scotland | Missouri | 29199 | 681 | 18 |
2436433 | 2436433 | 2022-04-23 | Scotland | North Carolina | 37165 | 10021 | 126 |
2432780 | 2432780 | 2022-04-22 | Scotland | Missouri | 29199 | 681 | 18 |
2433177 | 2433177 | 2022-04-22 | Scotland | North Carolina | 37165 | 10021 | 126 |
2429524 | 2429524 | 2022-04-21 | Scotland | Missouri | 29199 | 681 | 18 |
2429921 | 2429921 | 2022-04-21 | Scotland | North Carolina | 37165 | 10021 | 126 |
2426268 | 2426268 | 2022-04-20 | Scotland | Missouri | 29199 | 681 | 18 |
2426665 | 2426665 | 2022-04-20 | Scotland | North Carolina | 37165 | 10021 | 126 |
2423012 | 2423012 | 2022-04-19 | Scotland | Missouri | 29199 | 681 | 18 |
2423409 | 2423409 | 2022-04-19 | Scotland | North Carolina | 37165 | 9999 | 126 |
2419755 | 2419755 | 2022-04-18 | Scotland | Missouri | 29199 | 681 | 18 |
2420152 | 2420152 | 2022-04-18 | Scotland | North Carolina | 37165 | 9999 | 126 |
2416500 | 2416500 | 2022-04-17 | Scotland | Missouri | 29199 | 681 | 18 |
2416897 | 2416897 | 2022-04-17 | Scotland | North Carolina | 37165 | 9999 | 126 |
2413244 | 2413244 | 2022-04-16 | Scotland | Missouri | 29199 | 681 | 18 |
2413641 | 2413641 | 2022-04-16 | Scotland | North Carolina | 37165 | 9999 | 126 |
2409988 | 2409988 | 2022-04-15 | Scotland | Missouri | 29199 | 681 | 18 |
2410385 | 2410385 | 2022-04-15 | Scotland | North Carolina | 37165 | 9999 | 126 |
2406732 | 2406732 | 2022-04-14 | Scotland | Missouri | 29199 | 681 | 18 |
2407129 | 2407129 | 2022-04-14 | Scotland | North Carolina | 37165 | 9999 | 126 |
2403476 | 2403476 | 2022-04-13 | Scotland | Missouri | 29199 | 681 | 18 |
2403873 | 2403873 | 2022-04-13 | Scotland | North Carolina | 37165 | 9999 | 126 |
2400221 | 2400221 | 2022-04-12 | Scotland | Missouri | 29199 | 681 | 18 |
2400618 | 2400618 | 2022-04-12 | Scotland | North Carolina | 37165 | 9987 | 126 |
2396966 | 2396966 | 2022-04-11 | Scotland | Missouri | 29199 | 681 | 18 |
2397363 | 2397363 | 2022-04-11 | Scotland | North Carolina | 37165 | 9987 | 126 |
2393711 | 2393711 | 2022-04-10 | Scotland | Missouri | 29199 | 681 | 18 |
2394108 | 2394108 | 2022-04-10 | Scotland | North Carolina | 37165 | 9987 | 126 |
2390455 | 2390455 | 2022-04-09 | Scotland | Missouri | 29199 | 681 | 18 |
2390852 | 2390852 | 2022-04-09 | Scotland | North Carolina | 37165 | 9987 | 126 |
2387199 | 2387199 | 2022-04-08 | Scotland | Missouri | 29199 | 681 | 18 |
2387596 | 2387596 | 2022-04-08 | Scotland | North Carolina | 37165 | 9987 | 126 |
2383944 | 2383944 | 2022-04-07 | Scotland | Missouri | 29199 | 681 | 18 |
2384341 | 2384341 | 2022-04-07 | Scotland | North Carolina | 37165 | 9987 | 126 |
2380689 | 2380689 | 2022-04-06 | Scotland | Missouri | 29199 | 681 | 18 |
2381086 | 2381086 | 2022-04-06 | Scotland | North Carolina | 37165 | 9987 | 126 |
2377434 | 2377434 | 2022-04-05 | Scotland | Missouri | 29199 | 681 | 18 |
2377831 | 2377831 | 2022-04-05 | Scotland | North Carolina | 37165 | 9982 | 126 |
2374181 | 2374181 | 2022-04-04 | Scotland | Missouri | 29199 | 681 | 18 |
2374578 | 2374578 | 2022-04-04 | Scotland | North Carolina | 37165 | 9977 | 126 |
2370929 | 2370929 | 2022-04-03 | Scotland | Missouri | 29199 | 681 | 18 |
2371326 | 2371326 | 2022-04-03 | Scotland | North Carolina | 37165 | 9972 | 126 |
2367676 | 2367676 | 2022-04-02 | Scotland | Missouri | 29199 | 681 | 18 |
2368073 | 2368073 | 2022-04-02 | Scotland | North Carolina | 37165 | 9972 | 126 |
2364423 | 2364423 | 2022-04-01 | Scotland | Missouri | 29199 | 681 | 18 |
2364820 | 2364820 | 2022-04-01 | Scotland | North Carolina | 37165 | 9972 | 126 |
2361169 | 2361169 | 2022-03-31 | Scotland | Missouri | 29199 | 681 | 18 |
2361566 | 2361566 | 2022-03-31 | Scotland | North Carolina | 37165 | 9972 | 126 |
2357915 | 2357915 | 2022-03-30 | Scotland | Missouri | 29199 | 682 | 18 |
2358312 | 2358312 | 2022-03-30 | Scotland | North Carolina | 37165 | 9970 | 126 |
2354662 | 2354662 | 2022-03-29 | Scotland | Missouri | 29199 | 682 | 18 |
2355058 | 2355058 | 2022-03-29 | Scotland | North Carolina | 37165 | 9966 | 126 |
2351409 | 2351409 | 2022-03-28 | Scotland | Missouri | 29199 | 682 | 18 |
2351805 | 2351805 | 2022-03-28 | Scotland | North Carolina | 37165 | 9964 | 126 |
2348157 | 2348157 | 2022-03-27 | Scotland | Missouri | 29199 | 682 | 18 |
2348553 | 2348553 | 2022-03-27 | Scotland | North Carolina | 37165 | 9960 | 126 |
2344904 | 2344904 | 2022-03-26 | Scotland | Missouri | 29199 | 682 | 18 |
2345300 | 2345300 | 2022-03-26 | Scotland | North Carolina | 37165 | 9960 | 126 |
2341651 | 2341651 | 2022-03-25 | Scotland | Missouri | 29199 | 682 | 18 |
2342047 | 2342047 | 2022-03-25 | Scotland | North Carolina | 37165 | 9960 | 126 |
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);