ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Scott" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387525 | 387525 | 2020-07-31 | Scott | Missouri | 29201 | 342 | 13 |
384307 | 384307 | 2020-07-30 | Scott | Missouri | 29201 | 330 | 13 |
381091 | 381091 | 2020-07-29 | Scott | Missouri | 29201 | 313 | 13 |
377874 | 377874 | 2020-07-28 | Scott | Missouri | 29201 | 311 | 13 |
374659 | 374659 | 2020-07-27 | Scott | Missouri | 29201 | 294 | 13 |
371447 | 371447 | 2020-07-26 | Scott | Missouri | 29201 | 285 | 13 |
368236 | 368236 | 2020-07-25 | Scott | Missouri | 29201 | 286 | 13 |
365028 | 365028 | 2020-07-24 | Scott | Missouri | 29201 | 282 | 13 |
361821 | 361821 | 2020-07-23 | Scott | Missouri | 29201 | 272 | 13 |
358616 | 358616 | 2020-07-22 | Scott | Missouri | 29201 | 266 | 13 |
355413 | 355413 | 2020-07-21 | Scott | Missouri | 29201 | 250 | 13 |
352211 | 352211 | 2020-07-20 | Scott | Missouri | 29201 | 244 | 13 |
349011 | 349011 | 2020-07-19 | Scott | Missouri | 29201 | 244 | 13 |
345810 | 345810 | 2020-07-18 | Scott | Missouri | 29201 | 242 | 13 |
342610 | 342610 | 2020-07-17 | Scott | Missouri | 29201 | 240 | 13 |
339414 | 339414 | 2020-07-16 | Scott | Missouri | 29201 | 237 | 13 |
336218 | 336218 | 2020-07-15 | Scott | Missouri | 29201 | 235 | 13 |
333025 | 333025 | 2020-07-14 | Scott | Missouri | 29201 | 219 | 12 |
329838 | 329838 | 2020-07-13 | Scott | Missouri | 29201 | 209 | 12 |
326652 | 326652 | 2020-07-12 | Scott | Missouri | 29201 | 207 | 12 |
323469 | 323469 | 2020-07-11 | Scott | Missouri | 29201 | 206 | 12 |
320290 | 320290 | 2020-07-10 | Scott | Missouri | 29201 | 198 | 12 |
317115 | 317115 | 2020-07-09 | Scott | Missouri | 29201 | 192 | 11 |
313941 | 313941 | 2020-07-08 | Scott | Missouri | 29201 | 191 | 11 |
310770 | 310770 | 2020-07-07 | Scott | Missouri | 29201 | 188 | 11 |
307602 | 307602 | 2020-07-06 | Scott | Missouri | 29201 | 185 | 11 |
304435 | 304435 | 2020-07-05 | Scott | Missouri | 29201 | 181 | 11 |
301271 | 301271 | 2020-07-04 | Scott | Missouri | 29201 | 173 | 11 |
298108 | 298108 | 2020-07-03 | Scott | Missouri | 29201 | 172 | 11 |
294950 | 294950 | 2020-07-02 | Scott | Missouri | 29201 | 170 | 11 |
291796 | 291796 | 2020-07-01 | Scott | Missouri | 29201 | 169 | 11 |
288645 | 288645 | 2020-06-30 | Scott | Missouri | 29201 | 168 | 11 |
285495 | 285495 | 2020-06-29 | Scott | Missouri | 29201 | 164 | 11 |
282350 | 282350 | 2020-06-28 | Scott | Missouri | 29201 | 162 | 11 |
279202 | 279202 | 2020-06-27 | Scott | Missouri | 29201 | 161 | 11 |
276054 | 276054 | 2020-06-26 | Scott | Missouri | 29201 | 161 | 11 |
272911 | 272911 | 2020-06-25 | Scott | Missouri | 29201 | 159 | 11 |
269772 | 269772 | 2020-06-24 | Scott | Missouri | 29201 | 159 | 11 |
266639 | 266639 | 2020-06-23 | Scott | Missouri | 29201 | 159 | 11 |
263513 | 263513 | 2020-06-22 | Scott | Missouri | 29201 | 160 | 11 |
260385 | 260385 | 2020-06-21 | Scott | Missouri | 29201 | 159 | 10 |
257259 | 257259 | 2020-06-20 | Scott | Missouri | 29201 | 157 | 10 |
254138 | 254138 | 2020-06-19 | Scott | Missouri | 29201 | 155 | 10 |
251023 | 251023 | 2020-06-18 | Scott | Missouri | 29201 | 149 | 10 |
247910 | 247910 | 2020-06-17 | Scott | Missouri | 29201 | 149 | 10 |
244797 | 244797 | 2020-06-16 | Scott | Missouri | 29201 | 145 | 10 |
241686 | 241686 | 2020-06-15 | Scott | Missouri | 29201 | 145 | 10 |
238576 | 238576 | 2020-06-14 | Scott | Missouri | 29201 | 139 | 10 |
235469 | 235469 | 2020-06-13 | Scott | Missouri | 29201 | 139 | 10 |
232363 | 232363 | 2020-06-12 | Scott | Missouri | 29201 | 134 | 10 |
229259 | 229259 | 2020-06-11 | Scott | Missouri | 29201 | 132 | 10 |
226156 | 226156 | 2020-06-10 | Scott | Missouri | 29201 | 128 | 10 |
223057 | 223057 | 2020-06-09 | Scott | Missouri | 29201 | 127 | 10 |
219962 | 219962 | 2020-06-08 | Scott | Missouri | 29201 | 123 | 10 |
216870 | 216870 | 2020-06-07 | Scott | Missouri | 29201 | 121 | 9 |
213781 | 213781 | 2020-06-06 | Scott | Missouri | 29201 | 121 | 9 |
210697 | 210697 | 2020-06-05 | Scott | Missouri | 29201 | 119 | 9 |
207616 | 207616 | 2020-06-04 | Scott | Missouri | 29201 | 117 | 9 |
204535 | 204535 | 2020-06-03 | Scott | Missouri | 29201 | 113 | 9 |
201458 | 201458 | 2020-06-02 | Scott | Missouri | 29201 | 109 | 9 |
198385 | 198385 | 2020-06-01 | Scott | Missouri | 29201 | 108 | 9 |
195314 | 195314 | 2020-05-31 | Scott | Missouri | 29201 | 110 | 9 |
192244 | 192244 | 2020-05-30 | Scott | Missouri | 29201 | 108 | 9 |
189180 | 189180 | 2020-05-29 | Scott | Missouri | 29201 | 100 | 9 |
186122 | 186122 | 2020-05-28 | Scott | Missouri | 29201 | 98 | 8 |
183066 | 183066 | 2020-05-27 | Scott | Missouri | 29201 | 94 | 8 |
180019 | 180019 | 2020-05-26 | Scott | Missouri | 29201 | 94 | 8 |
176975 | 176975 | 2020-05-25 | Scott | Missouri | 29201 | 93 | 8 |
173932 | 173932 | 2020-05-24 | Scott | Missouri | 29201 | 93 | 8 |
170890 | 170890 | 2020-05-23 | Scott | Missouri | 29201 | 91 | 8 |
167851 | 167851 | 2020-05-22 | Scott | Missouri | 29201 | 91 | 8 |
164815 | 164815 | 2020-05-21 | Scott | Missouri | 29201 | 89 | 8 |
161786 | 161786 | 2020-05-20 | Scott | Missouri | 29201 | 88 | 8 |
158760 | 158760 | 2020-05-19 | Scott | Missouri | 29201 | 86 | 7 |
155742 | 155742 | 2020-05-18 | Scott | Missouri | 29201 | 87 | 7 |
152728 | 152728 | 2020-05-17 | Scott | Missouri | 29201 | 87 | 6 |
149717 | 149717 | 2020-05-16 | Scott | Missouri | 29201 | 86 | 6 |
146711 | 146711 | 2020-05-15 | Scott | Missouri | 29201 | 85 | 6 |
143710 | 143710 | 2020-05-14 | Scott | Missouri | 29201 | 84 | 6 |
140715 | 140715 | 2020-05-13 | Scott | Missouri | 29201 | 83 | 6 |
137721 | 137721 | 2020-05-12 | Scott | Missouri | 29201 | 82 | 6 |
134731 | 134731 | 2020-05-11 | Scott | Missouri | 29201 | 80 | 6 |
131740 | 131740 | 2020-05-10 | Scott | Missouri | 29201 | 80 | 5 |
128750 | 128750 | 2020-05-09 | Scott | Missouri | 29201 | 79 | 5 |
125762 | 125762 | 2020-05-08 | Scott | Missouri | 29201 | 78 | 5 |
122780 | 122780 | 2020-05-07 | Scott | Missouri | 29201 | 77 | 2 |
119806 | 119806 | 2020-05-06 | Scott | Missouri | 29201 | 76 | 2 |
116846 | 116846 | 2020-05-05 | Scott | Missouri | 29201 | 75 | 2 |
113964 | 113964 | 2020-05-04 | Scott | Missouri | 29201 | 76 | 2 |
111085 | 111085 | 2020-05-03 | Scott | Missouri | 29201 | 76 | 2 |
108213 | 108213 | 2020-05-02 | Scott | Missouri | 29201 | 76 | 2 |
105348 | 105348 | 2020-05-01 | Scott | Missouri | 29201 | 70 | 2 |
102487 | 102487 | 2020-04-30 | Scott | Missouri | 29201 | 64 | 2 |
99635 | 99635 | 2020-04-29 | Scott | Missouri | 29201 | 63 | 2 |
96789 | 96789 | 2020-04-28 | Scott | Missouri | 29201 | 62 | 2 |
93953 | 93953 | 2020-04-27 | Scott | Missouri | 29201 | 61 | 1 |
91132 | 91132 | 2020-04-26 | Scott | Missouri | 29201 | 61 | 1 |
88316 | 88316 | 2020-04-25 | Scott | Missouri | 29201 | 60 | 1 |
85506 | 85506 | 2020-04-24 | Scott | Missouri | 29201 | 59 | 1 |
82702 | 82702 | 2020-04-23 | Scott | Missouri | 29201 | 59 | 1 |
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);