ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Scotland" and fips = 29199 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 |
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 |
2175788 | 2175788 | 2022-02-02 | Scotland | Missouri | 29199 | 641 | 17 |
2172535 | 2172535 | 2022-02-01 | Scotland | Missouri | 29199 | 630 | 17 |
2169282 | 2169282 | 2022-01-31 | Scotland | Missouri | 29199 | 628 | 17 |
2166027 | 2166027 | 2022-01-30 | Scotland | Missouri | 29199 | 628 | 17 |
2162772 | 2162772 | 2022-01-29 | Scotland | Missouri | 29199 | 628 | 17 |
2159517 | 2159517 | 2022-01-28 | Scotland | Missouri | 29199 | 625 | 17 |
2156263 | 2156263 | 2022-01-27 | Scotland | Missouri | 29199 | 623 | 17 |
2153010 | 2153010 | 2022-01-26 | Scotland | Missouri | 29199 | 619 | 17 |
2149758 | 2149758 | 2022-01-25 | Scotland | Missouri | 29199 | 608 | 17 |
2146506 | 2146506 | 2022-01-24 | Scotland | Missouri | 29199 | 599 | 17 |
2143251 | 2143251 | 2022-01-23 | Scotland | Missouri | 29199 | 596 | 17 |
2139996 | 2139996 | 2022-01-22 | Scotland | Missouri | 29199 | 593 | 17 |
2136740 | 2136740 | 2022-01-21 | Scotland | Missouri | 29199 | 592 | 17 |
2133488 | 2133488 | 2022-01-20 | Scotland | Missouri | 29199 | 589 | 17 |
2130235 | 2130235 | 2022-01-19 | Scotland | Missouri | 29199 | 575 | 17 |
2126981 | 2126981 | 2022-01-18 | Scotland | Missouri | 29199 | 567 | 17 |
2123729 | 2123729 | 2022-01-17 | Scotland | Missouri | 29199 | 562 | 17 |
2120477 | 2120477 | 2022-01-16 | Scotland | Missouri | 29199 | 562 | 17 |
2117225 | 2117225 | 2022-01-15 | Scotland | Missouri | 29199 | 562 | 17 |
2113974 | 2113974 | 2022-01-14 | Scotland | Missouri | 29199 | 553 | 17 |
2110722 | 2110722 | 2022-01-13 | Scotland | Missouri | 29199 | 549 | 17 |
2107471 | 2107471 | 2022-01-12 | Scotland | Missouri | 29199 | 542 | 17 |
2104220 | 2104220 | 2022-01-11 | Scotland | Missouri | 29199 | 531 | 17 |
2100969 | 2100969 | 2022-01-10 | Scotland | Missouri | 29199 | 527 | 17 |
2097718 | 2097718 | 2022-01-09 | Scotland | Missouri | 29199 | 527 | 17 |
2094466 | 2094466 | 2022-01-08 | Scotland | Missouri | 29199 | 527 | 17 |
2091214 | 2091214 | 2022-01-07 | Scotland | Missouri | 29199 | 526 | 17 |
2087963 | 2087963 | 2022-01-06 | Scotland | Missouri | 29199 | 524 | 17 |
2084711 | 2084711 | 2022-01-05 | Scotland | Missouri | 29199 | 522 | 17 |
2081459 | 2081459 | 2022-01-04 | Scotland | Missouri | 29199 | 519 | 17 |
2078207 | 2078207 | 2022-01-03 | Scotland | Missouri | 29199 | 519 | 16 |
2074956 | 2074956 | 2022-01-02 | Scotland | Missouri | 29199 | 514 | 16 |
2071705 | 2071705 | 2022-01-01 | Scotland | Missouri | 29199 | 514 | 16 |
2068454 | 2068454 | 2021-12-31 | Scotland | Missouri | 29199 | 514 | 16 |
2065203 | 2065203 | 2021-12-30 | Scotland | Missouri | 29199 | 514 | 16 |
2061953 | 2061953 | 2021-12-29 | Scotland | Missouri | 29199 | 514 | 16 |
2058704 | 2058704 | 2021-12-28 | Scotland | Missouri | 29199 | 513 | 16 |
2055455 | 2055455 | 2021-12-27 | Scotland | Missouri | 29199 | 513 | 16 |
2052205 | 2052205 | 2021-12-26 | Scotland | Missouri | 29199 | 505 | 16 |
2048955 | 2048955 | 2021-12-25 | Scotland | Missouri | 29199 | 505 | 16 |
2045705 | 2045705 | 2021-12-24 | Scotland | Missouri | 29199 | 505 | 16 |
2042455 | 2042455 | 2021-12-23 | Scotland | Missouri | 29199 | 505 | 16 |
2039206 | 2039206 | 2021-12-22 | Scotland | Missouri | 29199 | 501 | 16 |
2035956 | 2035956 | 2021-12-21 | Scotland | Missouri | 29199 | 496 | 16 |
2032706 | 2032706 | 2021-12-20 | Scotland | Missouri | 29199 | 486 | 15 |
2029455 | 2029455 | 2021-12-19 | Scotland | Missouri | 29199 | 485 | 15 |
2026204 | 2026204 | 2021-12-18 | Scotland | Missouri | 29199 | 482 | 15 |
2022953 | 2022953 | 2021-12-17 | Scotland | Missouri | 29199 | 481 | 15 |
2019702 | 2019702 | 2021-12-16 | Scotland | Missouri | 29199 | 472 | 15 |
2016452 | 2016452 | 2021-12-15 | Scotland | Missouri | 29199 | 470 | 15 |
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);