ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Stearns" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79730 | 79730 | 2020-04-22 | Stearns | Minnesota | 27145 | 20 | 0 |
76945 | 76945 | 2020-04-21 | Stearns | Minnesota | 27145 | 18 | 0 |
74164 | 74164 | 2020-04-20 | Stearns | Minnesota | 27145 | 17 | 0 |
71391 | 71391 | 2020-04-19 | Stearns | Minnesota | 27145 | 16 | 0 |
68625 | 68625 | 2020-04-18 | Stearns | Minnesota | 27145 | 16 | 0 |
65873 | 65873 | 2020-04-17 | Stearns | Minnesota | 27145 | 14 | 0 |
63134 | 63134 | 2020-04-16 | Stearns | Minnesota | 27145 | 11 | 0 |
60411 | 60411 | 2020-04-15 | Stearns | Minnesota | 27145 | 7 | 0 |
57700 | 57700 | 2020-04-14 | Stearns | Minnesota | 27145 | 7 | 0 |
55002 | 55002 | 2020-04-13 | Stearns | Minnesota | 27145 | 7 | 0 |
52320 | 52320 | 2020-04-12 | Stearns | Minnesota | 27145 | 7 | 0 |
49648 | 49648 | 2020-04-11 | Stearns | Minnesota | 27145 | 7 | 0 |
47003 | 47003 | 2020-04-10 | Stearns | Minnesota | 27145 | 7 | 0 |
44393 | 44393 | 2020-04-09 | Stearns | Minnesota | 27145 | 7 | 0 |
41817 | 41817 | 2020-04-08 | Stearns | Minnesota | 27145 | 7 | 0 |
39263 | 39263 | 2020-04-07 | Stearns | Minnesota | 27145 | 6 | 0 |
36753 | 36753 | 2020-04-06 | Stearns | Minnesota | 27145 | 6 | 0 |
34291 | 34291 | 2020-04-05 | Stearns | Minnesota | 27145 | 6 | 0 |
31864 | 31864 | 2020-04-04 | Stearns | Minnesota | 27145 | 6 | 0 |
29484 | 29484 | 2020-04-03 | Stearns | Minnesota | 27145 | 5 | 0 |
27165 | 27165 | 2020-04-02 | Stearns | Minnesota | 27145 | 5 | 0 |
24911 | 24911 | 2020-04-01 | Stearns | Minnesota | 27145 | 5 | 0 |
22729 | 22729 | 2020-03-31 | Stearns | Minnesota | 27145 | 5 | 0 |
20614 | 20614 | 2020-03-30 | Stearns | Minnesota | 27145 | 5 | 0 |
18592 | 18592 | 2020-03-29 | Stearns | Minnesota | 27145 | 5 | 0 |
16672 | 16672 | 2020-03-28 | Stearns | Minnesota | 27145 | 5 | 0 |
14850 | 14850 | 2020-03-27 | Stearns | Minnesota | 27145 | 5 | 0 |
13134 | 13134 | 2020-03-26 | Stearns | Minnesota | 27145 | 5 | 0 |
11544 | 11544 | 2020-03-25 | Stearns | Minnesota | 27145 | 5 | 0 |
10126 | 10126 | 2020-03-24 | Stearns | Minnesota | 27145 | 5 | 0 |
8831 | 8831 | 2020-03-23 | Stearns | Minnesota | 27145 | 5 | 0 |
7651 | 7651 | 2020-03-22 | Stearns | Minnesota | 27145 | 4 | 0 |
6569 | 6569 | 2020-03-21 | Stearns | Minnesota | 27145 | 4 | 0 |
5598 | 5598 | 2020-03-20 | Stearns | Minnesota | 27145 | 4 | 0 |
4776 | 4776 | 2020-03-19 | Stearns | Minnesota | 27145 | 4 | 0 |
4064 | 4064 | 2020-03-18 | Stearns | Minnesota | 27145 | 3 | 0 |
3480 | 3480 | 2020-03-17 | Stearns | Minnesota | 27145 | 3 | 0 |
2975 | 2975 | 2020-03-16 | Stearns | Minnesota | 27145 | 3 | 0 |
2523 | 2523 | 2020-03-15 | Stearns | Minnesota | 27145 | 3 | 0 |
2119 | 2119 | 2020-03-14 | Stearns | Minnesota | 27145 | 3 | 0 |
1774 | 1774 | 2020-03-13 | Stearns | Minnesota | 27145 | 2 | 0 |
1491 | 1491 | 2020-03-12 | Stearns | Minnesota | 27145 | 2 | 0 |
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);