ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Scott" and fips = 29201 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 |
---|---|---|---|---|---|---|---|
2501172 | 2501172 | 2022-05-13 | Scott | Missouri | 29201 | 11133 | 161 |
2497914 | 2497914 | 2022-05-12 | Scott | Missouri | 29201 | 11122 | 161 |
2494656 | 2494656 | 2022-05-11 | Scott | Missouri | 29201 | 11122 | 161 |
2491398 | 2491398 | 2022-05-10 | Scott | Missouri | 29201 | 11122 | 161 |
2488140 | 2488140 | 2022-05-09 | Scott | Missouri | 29201 | 11122 | 161 |
2484883 | 2484883 | 2022-05-08 | Scott | Missouri | 29201 | 11122 | 161 |
2481625 | 2481625 | 2022-05-07 | Scott | Missouri | 29201 | 11122 | 161 |
2478367 | 2478367 | 2022-05-06 | Scott | Missouri | 29201 | 11122 | 161 |
2475109 | 2475109 | 2022-05-05 | Scott | Missouri | 29201 | 11113 | 161 |
2471852 | 2471852 | 2022-05-04 | Scott | Missouri | 29201 | 11109 | 159 |
2468596 | 2468596 | 2022-05-03 | Scott | Missouri | 29201 | 11109 | 159 |
2465340 | 2465340 | 2022-05-02 | Scott | Missouri | 29201 | 11109 | 159 |
2462085 | 2462085 | 2022-05-01 | Scott | Missouri | 29201 | 11109 | 159 |
2458829 | 2458829 | 2022-04-30 | Scott | Missouri | 29201 | 11109 | 159 |
2455573 | 2455573 | 2022-04-29 | Scott | Missouri | 29201 | 11109 | 159 |
2452317 | 2452317 | 2022-04-28 | Scott | Missouri | 29201 | 11109 | 159 |
2449061 | 2449061 | 2022-04-27 | Scott | Missouri | 29201 | 11109 | 159 |
2445804 | 2445804 | 2022-04-26 | Scott | Missouri | 29201 | 11109 | 159 |
2442549 | 2442549 | 2022-04-25 | Scott | Missouri | 29201 | 11109 | 159 |
2439293 | 2439293 | 2022-04-24 | Scott | Missouri | 29201 | 11109 | 159 |
2436037 | 2436037 | 2022-04-23 | Scott | Missouri | 29201 | 11109 | 159 |
2432781 | 2432781 | 2022-04-22 | Scott | Missouri | 29201 | 11109 | 159 |
2429525 | 2429525 | 2022-04-21 | Scott | Missouri | 29201 | 11109 | 159 |
2426269 | 2426269 | 2022-04-20 | Scott | Missouri | 29201 | 11109 | 159 |
2423013 | 2423013 | 2022-04-19 | Scott | Missouri | 29201 | 11109 | 159 |
2419756 | 2419756 | 2022-04-18 | Scott | Missouri | 29201 | 11109 | 159 |
2416501 | 2416501 | 2022-04-17 | Scott | Missouri | 29201 | 11109 | 159 |
2413245 | 2413245 | 2022-04-16 | Scott | Missouri | 29201 | 11109 | 159 |
2409989 | 2409989 | 2022-04-15 | Scott | Missouri | 29201 | 11109 | 159 |
2406733 | 2406733 | 2022-04-14 | Scott | Missouri | 29201 | 11109 | 159 |
2403477 | 2403477 | 2022-04-13 | Scott | Missouri | 29201 | 11109 | 159 |
2400222 | 2400222 | 2022-04-12 | Scott | Missouri | 29201 | 11109 | 159 |
2396967 | 2396967 | 2022-04-11 | Scott | Missouri | 29201 | 11109 | 159 |
2393712 | 2393712 | 2022-04-10 | Scott | Missouri | 29201 | 11109 | 159 |
2390456 | 2390456 | 2022-04-09 | Scott | Missouri | 29201 | 11109 | 159 |
2387200 | 2387200 | 2022-04-08 | Scott | Missouri | 29201 | 11109 | 159 |
2383945 | 2383945 | 2022-04-07 | Scott | Missouri | 29201 | 11109 | 159 |
2380690 | 2380690 | 2022-04-06 | Scott | Missouri | 29201 | 11109 | 159 |
2377435 | 2377435 | 2022-04-05 | Scott | Missouri | 29201 | 11109 | 159 |
2374182 | 2374182 | 2022-04-04 | Scott | Missouri | 29201 | 11109 | 159 |
2370930 | 2370930 | 2022-04-03 | Scott | Missouri | 29201 | 11109 | 159 |
2367677 | 2367677 | 2022-04-02 | Scott | Missouri | 29201 | 11109 | 159 |
2364424 | 2364424 | 2022-04-01 | Scott | Missouri | 29201 | 11109 | 159 |
2361170 | 2361170 | 2022-03-31 | Scott | Missouri | 29201 | 11109 | 159 |
2357916 | 2357916 | 2022-03-30 | Scott | Missouri | 29201 | 11106 | 159 |
2354663 | 2354663 | 2022-03-29 | Scott | Missouri | 29201 | 11106 | 159 |
2351410 | 2351410 | 2022-03-28 | Scott | Missouri | 29201 | 11105 | 158 |
2348158 | 2348158 | 2022-03-27 | Scott | Missouri | 29201 | 11103 | 158 |
2344905 | 2344905 | 2022-03-26 | Scott | Missouri | 29201 | 11103 | 158 |
2341652 | 2341652 | 2022-03-25 | Scott | Missouri | 29201 | 11103 | 158 |
2338399 | 2338399 | 2022-03-24 | Scott | Missouri | 29201 | 11090 | 158 |
2335145 | 2335145 | 2022-03-23 | Scott | Missouri | 29201 | 11088 | 158 |
2331891 | 2331891 | 2022-03-22 | Scott | Missouri | 29201 | 11088 | 158 |
2328638 | 2328638 | 2022-03-21 | Scott | Missouri | 29201 | 11087 | 158 |
2325386 | 2325386 | 2022-03-20 | Scott | Missouri | 29201 | 11086 | 158 |
2322132 | 2322132 | 2022-03-19 | Scott | Missouri | 29201 | 11086 | 158 |
2318878 | 2318878 | 2022-03-18 | Scott | Missouri | 29201 | 11086 | 158 |
2315625 | 2315625 | 2022-03-17 | Scott | Missouri | 29201 | 11086 | 158 |
2312372 | 2312372 | 2022-03-16 | Scott | Missouri | 29201 | 11085 | 158 |
2309119 | 2309119 | 2022-03-15 | Scott | Missouri | 29201 | 11084 | 158 |
2305867 | 2305867 | 2022-03-14 | Scott | Missouri | 29201 | 11080 | 153 |
2302616 | 2302616 | 2022-03-13 | Scott | Missouri | 29201 | 11076 | 153 |
2299364 | 2299364 | 2022-03-12 | Scott | Missouri | 29201 | 11076 | 153 |
2296112 | 2296112 | 2022-03-11 | Scott | Missouri | 29201 | 11076 | 153 |
2292860 | 2292860 | 2022-03-10 | Scott | Missouri | 29201 | 11073 | 153 |
2289608 | 2289608 | 2022-03-09 | Scott | Missouri | 29201 | 11071 | 153 |
2286356 | 2286356 | 2022-03-08 | Scott | Missouri | 29201 | 11069 | 153 |
2283104 | 2283104 | 2022-03-07 | Scott | Missouri | 29201 | 11063 | 152 |
2279851 | 2279851 | 2022-03-06 | Scott | Missouri | 29201 | 11022 | 152 |
2276598 | 2276598 | 2022-03-05 | Scott | Missouri | 29201 | 11022 | 152 |
2273345 | 2273345 | 2022-03-04 | Scott | Missouri | 29201 | 11022 | 152 |
2270093 | 2270093 | 2022-03-03 | Scott | Missouri | 29201 | 11021 | 152 |
2266840 | 2266840 | 2022-03-02 | Scott | Missouri | 29201 | 11019 | 152 |
2263589 | 2263589 | 2022-03-01 | Scott | Missouri | 29201 | 11018 | 152 |
2260338 | 2260338 | 2022-02-28 | Scott | Missouri | 29201 | 11020 | 152 |
2257087 | 2257087 | 2022-02-27 | Scott | Missouri | 29201 | 11009 | 150 |
2253836 | 2253836 | 2022-02-26 | Scott | Missouri | 29201 | 11009 | 150 |
2250585 | 2250585 | 2022-02-25 | Scott | Missouri | 29201 | 11009 | 150 |
2247334 | 2247334 | 2022-02-24 | Scott | Missouri | 29201 | 11005 | 150 |
2244083 | 2244083 | 2022-02-23 | Scott | Missouri | 29201 | 11002 | 147 |
2240832 | 2240832 | 2022-02-22 | Scott | Missouri | 29201 | 10997 | 147 |
2237581 | 2237581 | 2022-02-21 | Scott | Missouri | 29201 | 10990 | 147 |
2234330 | 2234330 | 2022-02-20 | Scott | Missouri | 29201 | 10990 | 147 |
2231079 | 2231079 | 2022-02-19 | Scott | Missouri | 29201 | 10990 | 147 |
2227828 | 2227828 | 2022-02-18 | Scott | Missouri | 29201 | 10990 | 147 |
2224577 | 2224577 | 2022-02-17 | Scott | Missouri | 29201 | 10982 | 147 |
2221326 | 2221326 | 2022-02-16 | Scott | Missouri | 29201 | 10946 | 147 |
2218075 | 2218075 | 2022-02-15 | Scott | Missouri | 29201 | 10910 | 147 |
2214824 | 2214824 | 2022-02-14 | Scott | Missouri | 29201 | 10868 | 147 |
2211572 | 2211572 | 2022-02-13 | Scott | Missouri | 29201 | 10810 | 146 |
2208319 | 2208319 | 2022-02-12 | Scott | Missouri | 29201 | 10810 | 146 |
2205066 | 2205066 | 2022-02-11 | Scott | Missouri | 29201 | 10810 | 146 |
2201813 | 2201813 | 2022-02-10 | Scott | Missouri | 29201 | 10810 | 146 |
2198559 | 2198559 | 2022-02-09 | Scott | Missouri | 29201 | 10784 | 146 |
2195305 | 2195305 | 2022-02-08 | Scott | Missouri | 29201 | 10735 | 146 |
2192051 | 2192051 | 2022-02-07 | Scott | Missouri | 29201 | 10668 | 143 |
2188798 | 2188798 | 2022-02-06 | Scott | Missouri | 29201 | 10639 | 143 |
2185545 | 2185545 | 2022-02-05 | Scott | Missouri | 29201 | 10632 | 143 |
2182293 | 2182293 | 2022-02-04 | Scott | Missouri | 29201 | 10602 | 143 |
2179041 | 2179041 | 2022-02-03 | Scott | Missouri | 29201 | 10514 | 143 |
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);