ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 29031 and state = "Missouri" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10196 | 10196 | 2020-03-24 | Cape Girardeau | Missouri | 29031 | 1 | 0 |
11617 | 11617 | 2020-03-25 | Cape Girardeau | Missouri | 29031 | 3 | 0 |
13214 | 13214 | 2020-03-26 | Cape Girardeau | Missouri | 29031 | 6 | 0 |
14938 | 14938 | 2020-03-27 | Cape Girardeau | Missouri | 29031 | 6 | 0 |
16762 | 16762 | 2020-03-28 | Cape Girardeau | Missouri | 29031 | 6 | 0 |
18684 | 18684 | 2020-03-29 | Cape Girardeau | Missouri | 29031 | 6 | 0 |
20708 | 20708 | 2020-03-30 | Cape Girardeau | Missouri | 29031 | 13 | 0 |
22826 | 22826 | 2020-03-31 | Cape Girardeau | Missouri | 29031 | 15 | 0 |
25012 | 25012 | 2020-04-01 | Cape Girardeau | Missouri | 29031 | 15 | 0 |
27267 | 27267 | 2020-04-02 | Cape Girardeau | Missouri | 29031 | 15 | 0 |
29586 | 29586 | 2020-04-03 | Cape Girardeau | Missouri | 29031 | 15 | 0 |
31966 | 31966 | 2020-04-04 | Cape Girardeau | Missouri | 29031 | 16 | 0 |
34394 | 34394 | 2020-04-05 | Cape Girardeau | Missouri | 29031 | 17 | 0 |
36857 | 36857 | 2020-04-06 | Cape Girardeau | Missouri | 29031 | 20 | 0 |
39368 | 39368 | 2020-04-07 | Cape Girardeau | Missouri | 29031 | 20 | 1 |
41922 | 41922 | 2020-04-08 | Cape Girardeau | Missouri | 29031 | 23 | 1 |
44499 | 44499 | 2020-04-09 | Cape Girardeau | Missouri | 29031 | 24 | 1 |
47108 | 47108 | 2020-04-10 | Cape Girardeau | Missouri | 29031 | 26 | 1 |
49755 | 49755 | 2020-04-11 | Cape Girardeau | Missouri | 29031 | 28 | 1 |
52428 | 52428 | 2020-04-12 | Cape Girardeau | Missouri | 29031 | 28 | 1 |
55110 | 55110 | 2020-04-13 | Cape Girardeau | Missouri | 29031 | 30 | 1 |
57808 | 57808 | 2020-04-14 | Cape Girardeau | Missouri | 29031 | 30 | 1 |
60519 | 60519 | 2020-04-15 | Cape Girardeau | Missouri | 29031 | 31 | 1 |
63241 | 63241 | 2020-04-16 | Cape Girardeau | Missouri | 29031 | 33 | 1 |
65981 | 65981 | 2020-04-17 | Cape Girardeau | Missouri | 29031 | 35 | 1 |
68733 | 68733 | 2020-04-18 | Cape Girardeau | Missouri | 29031 | 36 | 1 |
71500 | 71500 | 2020-04-19 | Cape Girardeau | Missouri | 29031 | 36 | 1 |
74273 | 74273 | 2020-04-20 | Cape Girardeau | Missouri | 29031 | 36 | 1 |
77054 | 77054 | 2020-04-21 | Cape Girardeau | Missouri | 29031 | 37 | 1 |
79839 | 79839 | 2020-04-22 | Cape Girardeau | Missouri | 29031 | 40 | 1 |
82635 | 82635 | 2020-04-23 | Cape Girardeau | Missouri | 29031 | 42 | 1 |
85439 | 85439 | 2020-04-24 | Cape Girardeau | Missouri | 29031 | 43 | 1 |
88249 | 88249 | 2020-04-25 | Cape Girardeau | Missouri | 29031 | 43 | 1 |
91065 | 91065 | 2020-04-26 | Cape Girardeau | Missouri | 29031 | 47 | 1 |
93886 | 93886 | 2020-04-27 | Cape Girardeau | Missouri | 29031 | 48 | 1 |
96722 | 96722 | 2020-04-28 | Cape Girardeau | Missouri | 29031 | 48 | 1 |
99568 | 99568 | 2020-04-29 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
102420 | 102420 | 2020-04-30 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
105281 | 105281 | 2020-05-01 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
108146 | 108146 | 2020-05-02 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
111017 | 111017 | 2020-05-03 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
113896 | 113896 | 2020-05-04 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
116778 | 116778 | 2020-05-05 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
119738 | 119738 | 2020-05-06 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
122712 | 122712 | 2020-05-07 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
125694 | 125694 | 2020-05-08 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
128681 | 128681 | 2020-05-09 | Cape Girardeau | Missouri | 29031 | 49 | 1 |
131671 | 131671 | 2020-05-10 | Cape Girardeau | Missouri | 29031 | 51 | 1 |
134662 | 134662 | 2020-05-11 | Cape Girardeau | Missouri | 29031 | 51 | 1 |
137652 | 137652 | 2020-05-12 | Cape Girardeau | Missouri | 29031 | 50 | 1 |
140646 | 140646 | 2020-05-13 | Cape Girardeau | Missouri | 29031 | 51 | 1 |
143641 | 143641 | 2020-05-14 | Cape Girardeau | Missouri | 29031 | 51 | 1 |
146641 | 146641 | 2020-05-15 | Cape Girardeau | Missouri | 29031 | 51 | 1 |
149646 | 149646 | 2020-05-16 | Cape Girardeau | Missouri | 29031 | 54 | 2 |
152657 | 152657 | 2020-05-17 | Cape Girardeau | Missouri | 29031 | 53 | 2 |
155671 | 155671 | 2020-05-18 | Cape Girardeau | Missouri | 29031 | 54 | 2 |
158689 | 158689 | 2020-05-19 | Cape Girardeau | Missouri | 29031 | 54 | 2 |
161715 | 161715 | 2020-05-20 | Cape Girardeau | Missouri | 29031 | 55 | 2 |
164744 | 164744 | 2020-05-21 | Cape Girardeau | Missouri | 29031 | 56 | 2 |
167780 | 167780 | 2020-05-22 | Cape Girardeau | Missouri | 29031 | 57 | 2 |
170818 | 170818 | 2020-05-23 | Cape Girardeau | Missouri | 29031 | 58 | 2 |
173860 | 173860 | 2020-05-24 | Cape Girardeau | Missouri | 29031 | 59 | 2 |
176903 | 176903 | 2020-05-25 | Cape Girardeau | Missouri | 29031 | 62 | 2 |
179947 | 179947 | 2020-05-26 | Cape Girardeau | Missouri | 29031 | 64 | 2 |
182993 | 182993 | 2020-05-27 | Cape Girardeau | Missouri | 29031 | 68 | 2 |
186049 | 186049 | 2020-05-28 | Cape Girardeau | Missouri | 29031 | 70 | 2 |
189107 | 189107 | 2020-05-29 | Cape Girardeau | Missouri | 29031 | 73 | 2 |
192171 | 192171 | 2020-05-30 | Cape Girardeau | Missouri | 29031 | 73 | 2 |
195239 | 195239 | 2020-05-31 | Cape Girardeau | Missouri | 29031 | 73 | 2 |
198310 | 198310 | 2020-06-01 | Cape Girardeau | Missouri | 29031 | 74 | 2 |
201383 | 201383 | 2020-06-02 | Cape Girardeau | Missouri | 29031 | 76 | 2 |
204460 | 204460 | 2020-06-03 | Cape Girardeau | Missouri | 29031 | 76 | 2 |
207541 | 207541 | 2020-06-04 | Cape Girardeau | Missouri | 29031 | 77 | 2 |
210622 | 210622 | 2020-06-05 | Cape Girardeau | Missouri | 29031 | 83 | 3 |
213706 | 213706 | 2020-06-06 | Cape Girardeau | Missouri | 29031 | 85 | 3 |
216794 | 216794 | 2020-06-07 | Cape Girardeau | Missouri | 29031 | 85 | 3 |
219886 | 219886 | 2020-06-08 | Cape Girardeau | Missouri | 29031 | 87 | 3 |
222981 | 222981 | 2020-06-09 | Cape Girardeau | Missouri | 29031 | 86 | 3 |
226079 | 226079 | 2020-06-10 | Cape Girardeau | Missouri | 29031 | 88 | 3 |
229182 | 229182 | 2020-06-11 | Cape Girardeau | Missouri | 29031 | 98 | 3 |
232286 | 232286 | 2020-06-12 | Cape Girardeau | Missouri | 29031 | 101 | 3 |
235392 | 235392 | 2020-06-13 | Cape Girardeau | Missouri | 29031 | 104 | 3 |
238499 | 238499 | 2020-06-14 | Cape Girardeau | Missouri | 29031 | 104 | 3 |
241608 | 241608 | 2020-06-15 | Cape Girardeau | Missouri | 29031 | 108 | 3 |
244719 | 244719 | 2020-06-16 | Cape Girardeau | Missouri | 29031 | 110 | 3 |
247832 | 247832 | 2020-06-17 | Cape Girardeau | Missouri | 29031 | 111 | 3 |
250945 | 250945 | 2020-06-18 | Cape Girardeau | Missouri | 29031 | 114 | 3 |
254060 | 254060 | 2020-06-19 | Cape Girardeau | Missouri | 29031 | 117 | 3 |
257180 | 257180 | 2020-06-20 | Cape Girardeau | Missouri | 29031 | 119 | 3 |
260306 | 260306 | 2020-06-21 | Cape Girardeau | Missouri | 29031 | 120 | 3 |
263434 | 263434 | 2020-06-22 | Cape Girardeau | Missouri | 29031 | 121 | 3 |
266560 | 266560 | 2020-06-23 | Cape Girardeau | Missouri | 29031 | 123 | 3 |
269693 | 269693 | 2020-06-24 | Cape Girardeau | Missouri | 29031 | 123 | 3 |
272831 | 272831 | 2020-06-25 | Cape Girardeau | Missouri | 29031 | 126 | 3 |
275974 | 275974 | 2020-06-26 | Cape Girardeau | Missouri | 29031 | 133 | 3 |
279122 | 279122 | 2020-06-27 | Cape Girardeau | Missouri | 29031 | 141 | 3 |
282270 | 282270 | 2020-06-28 | Cape Girardeau | Missouri | 29031 | 145 | 3 |
285415 | 285415 | 2020-06-29 | Cape Girardeau | Missouri | 29031 | 153 | 3 |
288565 | 288565 | 2020-06-30 | Cape Girardeau | Missouri | 29031 | 161 | 3 |
291716 | 291716 | 2020-07-01 | Cape Girardeau | Missouri | 29031 | 171 | 3 |
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);