ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 29037 and state = "Missouri" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
2986 | 2986 | 2020-03-16 | Cass | Missouri | 29037 | 1 | 0 |
3494 | 3494 | 2020-03-17 | Cass | Missouri | 29037 | 2 | 0 |
4083 | 4083 | 2020-03-18 | Cass | Missouri | 29037 | 2 | 0 |
4802 | 4802 | 2020-03-19 | Cass | Missouri | 29037 | 4 | 0 |
5635 | 5635 | 2020-03-20 | Cass | Missouri | 29037 | 6 | 0 |
6623 | 6623 | 2020-03-21 | Cass | Missouri | 29037 | 6 | 0 |
7712 | 7712 | 2020-03-22 | Cass | Missouri | 29037 | 6 | 0 |
8898 | 8898 | 2020-03-23 | Cass | Missouri | 29037 | 6 | 0 |
10197 | 10197 | 2020-03-24 | Cass | Missouri | 29037 | 6 | 0 |
11618 | 11618 | 2020-03-25 | Cass | Missouri | 29037 | 8 | 0 |
13216 | 13216 | 2020-03-26 | Cass | Missouri | 29037 | 8 | 0 |
14940 | 14940 | 2020-03-27 | Cass | Missouri | 29037 | 8 | 0 |
16764 | 16764 | 2020-03-28 | Cass | Missouri | 29037 | 8 | 0 |
18686 | 18686 | 2020-03-29 | Cass | Missouri | 29037 | 8 | 0 |
20710 | 20710 | 2020-03-30 | Cass | Missouri | 29037 | 9 | 0 |
22828 | 22828 | 2020-03-31 | Cass | Missouri | 29037 | 14 | 0 |
25014 | 25014 | 2020-04-01 | Cass | Missouri | 29037 | 17 | 1 |
27269 | 27269 | 2020-04-02 | Cass | Missouri | 29037 | 21 | 1 |
29588 | 29588 | 2020-04-03 | Cass | Missouri | 29037 | 21 | 1 |
31968 | 31968 | 2020-04-04 | Cass | Missouri | 29037 | 22 | 1 |
34396 | 34396 | 2020-04-05 | Cass | Missouri | 29037 | 23 | 1 |
39370 | 39370 | 2020-04-07 | Cass | Missouri | 29037 | 25 | 1 |
36859 | 36859 | 2020-04-06 | Cass | Missouri | 29037 | 26 | 1 |
41924 | 41924 | 2020-04-08 | Cass | Missouri | 29037 | 26 | 1 |
44501 | 44501 | 2020-04-09 | Cass | Missouri | 29037 | 27 | 1 |
47110 | 47110 | 2020-04-10 | Cass | Missouri | 29037 | 27 | 2 |
49757 | 49757 | 2020-04-11 | Cass | Missouri | 29037 | 32 | 2 |
52430 | 52430 | 2020-04-12 | Cass | Missouri | 29037 | 32 | 2 |
55112 | 55112 | 2020-04-13 | Cass | Missouri | 29037 | 36 | 2 |
57810 | 57810 | 2020-04-14 | Cass | Missouri | 29037 | 44 | 4 |
60521 | 60521 | 2020-04-15 | Cass | Missouri | 29037 | 44 | 4 |
63243 | 63243 | 2020-04-16 | Cass | Missouri | 29037 | 47 | 5 |
65983 | 65983 | 2020-04-17 | Cass | Missouri | 29037 | 50 | 5 |
68735 | 68735 | 2020-04-18 | Cass | Missouri | 29037 | 52 | 6 |
71502 | 71502 | 2020-04-19 | Cass | Missouri | 29037 | 53 | 6 |
74275 | 74275 | 2020-04-20 | Cass | Missouri | 29037 | 53 | 6 |
77056 | 77056 | 2020-04-21 | Cass | Missouri | 29037 | 54 | 6 |
79842 | 79842 | 2020-04-22 | Cass | Missouri | 29037 | 55 | 6 |
82638 | 82638 | 2020-04-23 | Cass | Missouri | 29037 | 55 | 6 |
85442 | 85442 | 2020-04-24 | Cass | Missouri | 29037 | 55 | 6 |
88252 | 88252 | 2020-04-25 | Cass | Missouri | 29037 | 58 | 6 |
91068 | 91068 | 2020-04-26 | Cass | Missouri | 29037 | 58 | 6 |
93889 | 93889 | 2020-04-27 | Cass | Missouri | 29037 | 58 | 6 |
96725 | 96725 | 2020-04-28 | Cass | Missouri | 29037 | 61 | 6 |
99571 | 99571 | 2020-04-29 | Cass | Missouri | 29037 | 62 | 6 |
102423 | 102423 | 2020-04-30 | Cass | Missouri | 29037 | 62 | 6 |
105284 | 105284 | 2020-05-01 | Cass | Missouri | 29037 | 63 | 6 |
108149 | 108149 | 2020-05-02 | Cass | Missouri | 29037 | 64 | 6 |
111020 | 111020 | 2020-05-03 | Cass | Missouri | 29037 | 64 | 6 |
113899 | 113899 | 2020-05-04 | Cass | Missouri | 29037 | 64 | 6 |
116781 | 116781 | 2020-05-05 | Cass | Missouri | 29037 | 65 | 6 |
119741 | 119741 | 2020-05-06 | Cass | Missouri | 29037 | 66 | 6 |
122715 | 122715 | 2020-05-07 | Cass | Missouri | 29037 | 67 | 7 |
125697 | 125697 | 2020-05-08 | Cass | Missouri | 29037 | 69 | 8 |
128684 | 128684 | 2020-05-09 | Cass | Missouri | 29037 | 69 | 8 |
131674 | 131674 | 2020-05-10 | Cass | Missouri | 29037 | 70 | 8 |
134665 | 134665 | 2020-05-11 | Cass | Missouri | 29037 | 70 | 8 |
137655 | 137655 | 2020-05-12 | Cass | Missouri | 29037 | 70 | 8 |
140649 | 140649 | 2020-05-13 | Cass | Missouri | 29037 | 70 | 8 |
143644 | 143644 | 2020-05-14 | Cass | Missouri | 29037 | 73 | 8 |
146644 | 146644 | 2020-05-15 | Cass | Missouri | 29037 | 73 | 8 |
149649 | 149649 | 2020-05-16 | Cass | Missouri | 29037 | 74 | 8 |
152660 | 152660 | 2020-05-17 | Cass | Missouri | 29037 | 74 | 8 |
155674 | 155674 | 2020-05-18 | Cass | Missouri | 29037 | 75 | 8 |
158692 | 158692 | 2020-05-19 | Cass | Missouri | 29037 | 75 | 8 |
161718 | 161718 | 2020-05-20 | Cass | Missouri | 29037 | 77 | 8 |
164747 | 164747 | 2020-05-21 | Cass | Missouri | 29037 | 77 | 8 |
167783 | 167783 | 2020-05-22 | Cass | Missouri | 29037 | 77 | 8 |
170821 | 170821 | 2020-05-23 | Cass | Missouri | 29037 | 77 | 8 |
173863 | 173863 | 2020-05-24 | Cass | Missouri | 29037 | 79 | 8 |
176906 | 176906 | 2020-05-25 | Cass | Missouri | 29037 | 80 | 8 |
179950 | 179950 | 2020-05-26 | Cass | Missouri | 29037 | 82 | 8 |
182996 | 182996 | 2020-05-27 | Cass | Missouri | 29037 | 83 | 8 |
186052 | 186052 | 2020-05-28 | Cass | Missouri | 29037 | 85 | 8 |
189110 | 189110 | 2020-05-29 | Cass | Missouri | 29037 | 86 | 8 |
192174 | 192174 | 2020-05-30 | Cass | Missouri | 29037 | 89 | 8 |
195242 | 195242 | 2020-05-31 | Cass | Missouri | 29037 | 90 | 8 |
198313 | 198313 | 2020-06-01 | Cass | Missouri | 29037 | 93 | 8 |
201386 | 201386 | 2020-06-02 | Cass | Missouri | 29037 | 96 | 8 |
204463 | 204463 | 2020-06-03 | Cass | Missouri | 29037 | 97 | 8 |
210625 | 210625 | 2020-06-05 | Cass | Missouri | 29037 | 99 | 8 |
207544 | 207544 | 2020-06-04 | Cass | Missouri | 29037 | 100 | 8 |
213709 | 213709 | 2020-06-06 | Cass | Missouri | 29037 | 102 | 8 |
216797 | 216797 | 2020-06-07 | Cass | Missouri | 29037 | 102 | 8 |
219889 | 219889 | 2020-06-08 | Cass | Missouri | 29037 | 104 | 8 |
222984 | 222984 | 2020-06-09 | Cass | Missouri | 29037 | 105 | 8 |
226082 | 226082 | 2020-06-10 | Cass | Missouri | 29037 | 108 | 8 |
229185 | 229185 | 2020-06-11 | Cass | Missouri | 29037 | 110 | 8 |
232289 | 232289 | 2020-06-12 | Cass | Missouri | 29037 | 111 | 8 |
235395 | 235395 | 2020-06-13 | Cass | Missouri | 29037 | 111 | 8 |
238502 | 238502 | 2020-06-14 | Cass | Missouri | 29037 | 111 | 8 |
247835 | 247835 | 2020-06-17 | Cass | Missouri | 29037 | 111 | 8 |
241611 | 241611 | 2020-06-15 | Cass | Missouri | 29037 | 114 | 8 |
250948 | 250948 | 2020-06-18 | Cass | Missouri | 29037 | 114 | 8 |
244722 | 244722 | 2020-06-16 | Cass | Missouri | 29037 | 115 | 8 |
254063 | 254063 | 2020-06-19 | Cass | Missouri | 29037 | 115 | 8 |
257183 | 257183 | 2020-06-20 | Cass | Missouri | 29037 | 116 | 8 |
260309 | 260309 | 2020-06-21 | Cass | Missouri | 29037 | 116 | 8 |
263437 | 263437 | 2020-06-22 | Cass | Missouri | 29037 | 116 | 8 |
266563 | 266563 | 2020-06-23 | Cass | Missouri | 29037 | 117 | 8 |
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);