ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29157 and state = "Missouri" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
8912 | 8912 | 2020-03-23 | Perry | Missouri | 29157 | 1 | 0 |
10214 | 10214 | 2020-03-24 | Perry | Missouri | 29157 | 2 | 0 |
11639 | 11639 | 2020-03-25 | Perry | Missouri | 29157 | 2 | 0 |
13237 | 13237 | 2020-03-26 | Perry | Missouri | 29157 | 4 | 0 |
14963 | 14963 | 2020-03-27 | Perry | Missouri | 29157 | 6 | 0 |
16787 | 16787 | 2020-03-28 | Perry | Missouri | 29157 | 7 | 0 |
18709 | 18709 | 2020-03-29 | Perry | Missouri | 29157 | 7 | 0 |
20740 | 20740 | 2020-03-30 | Perry | Missouri | 29157 | 12 | 0 |
22859 | 22859 | 2020-03-31 | Perry | Missouri | 29157 | 14 | 0 |
25047 | 25047 | 2020-04-01 | Perry | Missouri | 29157 | 18 | 0 |
27304 | 27304 | 2020-04-02 | Perry | Missouri | 29157 | 19 | 0 |
29625 | 29625 | 2020-04-03 | Perry | Missouri | 29157 | 21 | 0 |
32006 | 32006 | 2020-04-04 | Perry | Missouri | 29157 | 22 | 0 |
34434 | 34434 | 2020-04-05 | Perry | Missouri | 29157 | 25 | 0 |
36899 | 36899 | 2020-04-06 | Perry | Missouri | 29157 | 28 | 0 |
39413 | 39413 | 2020-04-07 | Perry | Missouri | 29157 | 28 | 0 |
41967 | 41967 | 2020-04-08 | Perry | Missouri | 29157 | 30 | 0 |
44544 | 44544 | 2020-04-09 | Perry | Missouri | 29157 | 31 | 0 |
47153 | 47153 | 2020-04-10 | Perry | Missouri | 29157 | 31 | 0 |
49801 | 49801 | 2020-04-11 | Perry | Missouri | 29157 | 34 | 0 |
52474 | 52474 | 2020-04-12 | Perry | Missouri | 29157 | 35 | 0 |
55156 | 55156 | 2020-04-13 | Perry | Missouri | 29157 | 36 | 0 |
57854 | 57854 | 2020-04-14 | Perry | Missouri | 29157 | 38 | 0 |
60568 | 60568 | 2020-04-15 | Perry | Missouri | 29157 | 38 | 0 |
63290 | 63290 | 2020-04-16 | Perry | Missouri | 29157 | 38 | 0 |
74324 | 74324 | 2020-04-20 | Perry | Missouri | 29157 | 38 | 0 |
77105 | 77105 | 2020-04-21 | Perry | Missouri | 29157 | 38 | 0 |
79892 | 79892 | 2020-04-22 | Perry | Missouri | 29157 | 38 | 0 |
82688 | 82688 | 2020-04-23 | Perry | Missouri | 29157 | 38 | 0 |
66030 | 66030 | 2020-04-17 | Perry | Missouri | 29157 | 39 | 0 |
68784 | 68784 | 2020-04-18 | Perry | Missouri | 29157 | 39 | 0 |
71551 | 71551 | 2020-04-19 | Perry | Missouri | 29157 | 39 | 0 |
85492 | 85492 | 2020-04-24 | Perry | Missouri | 29157 | 39 | 0 |
88302 | 88302 | 2020-04-25 | Perry | Missouri | 29157 | 39 | 0 |
91118 | 91118 | 2020-04-26 | Perry | Missouri | 29157 | 41 | 0 |
93939 | 93939 | 2020-04-27 | Perry | Missouri | 29157 | 41 | 0 |
96775 | 96775 | 2020-04-28 | Perry | Missouri | 29157 | 41 | 0 |
99621 | 99621 | 2020-04-29 | Perry | Missouri | 29157 | 43 | 0 |
102473 | 102473 | 2020-04-30 | Perry | Missouri | 29157 | 43 | 0 |
105334 | 105334 | 2020-05-01 | Perry | Missouri | 29157 | 43 | 0 |
108199 | 108199 | 2020-05-02 | Perry | Missouri | 29157 | 43 | 0 |
111071 | 111071 | 2020-05-03 | Perry | Missouri | 29157 | 43 | 0 |
113950 | 113950 | 2020-05-04 | Perry | Missouri | 29157 | 43 | 0 |
116832 | 116832 | 2020-05-05 | Perry | Missouri | 29157 | 43 | 0 |
119792 | 119792 | 2020-05-06 | Perry | Missouri | 29157 | 44 | 0 |
122766 | 122766 | 2020-05-07 | Perry | Missouri | 29157 | 44 | 0 |
125748 | 125748 | 2020-05-08 | Perry | Missouri | 29157 | 45 | 0 |
128736 | 128736 | 2020-05-09 | Perry | Missouri | 29157 | 45 | 0 |
131726 | 131726 | 2020-05-10 | Perry | Missouri | 29157 | 45 | 0 |
134717 | 134717 | 2020-05-11 | Perry | Missouri | 29157 | 45 | 0 |
137707 | 137707 | 2020-05-12 | Perry | Missouri | 29157 | 45 | 0 |
140701 | 140701 | 2020-05-13 | Perry | Missouri | 29157 | 46 | 0 |
143696 | 143696 | 2020-05-14 | Perry | Missouri | 29157 | 46 | 0 |
146697 | 146697 | 2020-05-15 | Perry | Missouri | 29157 | 46 | 0 |
149702 | 149702 | 2020-05-16 | Perry | Missouri | 29157 | 46 | 0 |
152713 | 152713 | 2020-05-17 | Perry | Missouri | 29157 | 46 | 0 |
155727 | 155727 | 2020-05-18 | Perry | Missouri | 29157 | 47 | 0 |
158745 | 158745 | 2020-05-19 | Perry | Missouri | 29157 | 47 | 0 |
161771 | 161771 | 2020-05-20 | Perry | Missouri | 29157 | 47 | 0 |
164800 | 164800 | 2020-05-21 | Perry | Missouri | 29157 | 48 | 0 |
167836 | 167836 | 2020-05-22 | Perry | Missouri | 29157 | 48 | 0 |
170875 | 170875 | 2020-05-23 | Perry | Missouri | 29157 | 49 | 0 |
173917 | 173917 | 2020-05-24 | Perry | Missouri | 29157 | 49 | 0 |
176960 | 176960 | 2020-05-25 | Perry | Missouri | 29157 | 49 | 0 |
180004 | 180004 | 2020-05-26 | Perry | Missouri | 29157 | 49 | 0 |
183051 | 183051 | 2020-05-27 | Perry | Missouri | 29157 | 50 | 0 |
186107 | 186107 | 2020-05-28 | Perry | Missouri | 29157 | 50 | 0 |
189165 | 189165 | 2020-05-29 | Perry | Missouri | 29157 | 55 | 0 |
192229 | 192229 | 2020-05-30 | Perry | Missouri | 29157 | 57 | 0 |
195299 | 195299 | 2020-05-31 | Perry | Missouri | 29157 | 57 | 0 |
198370 | 198370 | 2020-06-01 | Perry | Missouri | 29157 | 61 | 0 |
201443 | 201443 | 2020-06-02 | Perry | Missouri | 29157 | 63 | 0 |
204520 | 204520 | 2020-06-03 | Perry | Missouri | 29157 | 64 | 0 |
207601 | 207601 | 2020-06-04 | Perry | Missouri | 29157 | 65 | 0 |
210682 | 210682 | 2020-06-05 | Perry | Missouri | 29157 | 69 | 0 |
213766 | 213766 | 2020-06-06 | Perry | Missouri | 29157 | 69 | 0 |
216854 | 216854 | 2020-06-07 | Perry | Missouri | 29157 | 70 | 0 |
219946 | 219946 | 2020-06-08 | Perry | Missouri | 29157 | 71 | 0 |
223041 | 223041 | 2020-06-09 | Perry | Missouri | 29157 | 75 | 0 |
226140 | 226140 | 2020-06-10 | Perry | Missouri | 29157 | 75 | 0 |
229243 | 229243 | 2020-06-11 | Perry | Missouri | 29157 | 79 | 0 |
232347 | 232347 | 2020-06-12 | Perry | Missouri | 29157 | 80 | 0 |
235453 | 235453 | 2020-06-13 | Perry | Missouri | 29157 | 84 | 0 |
238560 | 238560 | 2020-06-14 | Perry | Missouri | 29157 | 84 | 0 |
241670 | 241670 | 2020-06-15 | Perry | Missouri | 29157 | 85 | 0 |
244781 | 244781 | 2020-06-16 | Perry | Missouri | 29157 | 86 | 0 |
247894 | 247894 | 2020-06-17 | Perry | Missouri | 29157 | 87 | 0 |
251007 | 251007 | 2020-06-18 | Perry | Missouri | 29157 | 87 | 0 |
254122 | 254122 | 2020-06-19 | Perry | Missouri | 29157 | 88 | 0 |
257243 | 257243 | 2020-06-20 | Perry | Missouri | 29157 | 91 | 0 |
260369 | 260369 | 2020-06-21 | Perry | Missouri | 29157 | 102 | 0 |
263497 | 263497 | 2020-06-22 | Perry | Missouri | 29157 | 104 | 0 |
266623 | 266623 | 2020-06-23 | Perry | Missouri | 29157 | 111 | 0 |
269756 | 269756 | 2020-06-24 | Perry | Missouri | 29157 | 111 | 0 |
272895 | 272895 | 2020-06-25 | Perry | Missouri | 29157 | 112 | 0 |
276038 | 276038 | 2020-06-26 | Perry | Missouri | 29157 | 119 | 0 |
279186 | 279186 | 2020-06-27 | Perry | Missouri | 29157 | 123 | 0 |
282334 | 282334 | 2020-06-28 | Perry | Missouri | 29157 | 126 | 0 |
285479 | 285479 | 2020-06-29 | Perry | Missouri | 29157 | 134 | 0 |
288629 | 288629 | 2020-06-30 | Perry | Missouri | 29157 | 146 | 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);