ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Cass" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387447 | 387447 | 2020-07-31 | Cass | Missouri | 29037 | 643 | 12 |
384229 | 384229 | 2020-07-30 | Cass | Missouri | 29037 | 602 | 12 |
381013 | 381013 | 2020-07-29 | Cass | Missouri | 29037 | 594 | 11 |
377796 | 377796 | 2020-07-28 | Cass | Missouri | 29037 | 578 | 10 |
374581 | 374581 | 2020-07-27 | Cass | Missouri | 29037 | 555 | 9 |
371369 | 371369 | 2020-07-26 | Cass | Missouri | 29037 | 543 | 9 |
368158 | 368158 | 2020-07-25 | Cass | Missouri | 29037 | 517 | 9 |
364950 | 364950 | 2020-07-24 | Cass | Missouri | 29037 | 468 | 9 |
361743 | 361743 | 2020-07-23 | Cass | Missouri | 29037 | 468 | 9 |
358538 | 358538 | 2020-07-22 | Cass | Missouri | 29037 | 440 | 9 |
355335 | 355335 | 2020-07-21 | Cass | Missouri | 29037 | 420 | 9 |
352133 | 352133 | 2020-07-20 | Cass | Missouri | 29037 | 410 | 9 |
348933 | 348933 | 2020-07-19 | Cass | Missouri | 29037 | 401 | 9 |
345732 | 345732 | 2020-07-18 | Cass | Missouri | 29037 | 386 | 9 |
342532 | 342532 | 2020-07-17 | Cass | Missouri | 29037 | 364 | 9 |
339336 | 339336 | 2020-07-16 | Cass | Missouri | 29037 | 341 | 9 |
336140 | 336140 | 2020-07-15 | Cass | Missouri | 29037 | 316 | 9 |
332947 | 332947 | 2020-07-14 | Cass | Missouri | 29037 | 300 | 9 |
329760 | 329760 | 2020-07-13 | Cass | Missouri | 29037 | 267 | 9 |
326574 | 326574 | 2020-07-12 | Cass | Missouri | 29037 | 250 | 9 |
323391 | 323391 | 2020-07-11 | Cass | Missouri | 29037 | 239 | 9 |
320212 | 320212 | 2020-07-10 | Cass | Missouri | 29037 | 227 | 9 |
317037 | 317037 | 2020-07-09 | Cass | Missouri | 29037 | 214 | 9 |
313863 | 313863 | 2020-07-08 | Cass | Missouri | 29037 | 203 | 9 |
310693 | 310693 | 2020-07-07 | Cass | Missouri | 29037 | 191 | 9 |
307525 | 307525 | 2020-07-06 | Cass | Missouri | 29037 | 185 | 9 |
304358 | 304358 | 2020-07-05 | Cass | Missouri | 29037 | 171 | 9 |
301194 | 301194 | 2020-07-04 | Cass | Missouri | 29037 | 166 | 9 |
298031 | 298031 | 2020-07-03 | Cass | Missouri | 29037 | 162 | 9 |
294873 | 294873 | 2020-07-02 | Cass | Missouri | 29037 | 156 | 9 |
291719 | 291719 | 2020-07-01 | Cass | Missouri | 29037 | 147 | 9 |
288568 | 288568 | 2020-06-30 | Cass | Missouri | 29037 | 143 | 9 |
285418 | 285418 | 2020-06-29 | Cass | Missouri | 29037 | 137 | 9 |
282273 | 282273 | 2020-06-28 | Cass | Missouri | 29037 | 134 | 9 |
279125 | 279125 | 2020-06-27 | Cass | Missouri | 29037 | 134 | 9 |
275977 | 275977 | 2020-06-26 | Cass | Missouri | 29037 | 127 | 9 |
272834 | 272834 | 2020-06-25 | Cass | Missouri | 29037 | 123 | 8 |
269696 | 269696 | 2020-06-24 | Cass | Missouri | 29037 | 119 | 8 |
266563 | 266563 | 2020-06-23 | Cass | Missouri | 29037 | 117 | 8 |
263437 | 263437 | 2020-06-22 | Cass | Missouri | 29037 | 116 | 8 |
260309 | 260309 | 2020-06-21 | Cass | Missouri | 29037 | 116 | 8 |
257183 | 257183 | 2020-06-20 | Cass | Missouri | 29037 | 116 | 8 |
254063 | 254063 | 2020-06-19 | Cass | Missouri | 29037 | 115 | 8 |
250948 | 250948 | 2020-06-18 | Cass | Missouri | 29037 | 114 | 8 |
247835 | 247835 | 2020-06-17 | Cass | Missouri | 29037 | 111 | 8 |
244722 | 244722 | 2020-06-16 | Cass | Missouri | 29037 | 115 | 8 |
241611 | 241611 | 2020-06-15 | Cass | Missouri | 29037 | 114 | 8 |
238502 | 238502 | 2020-06-14 | Cass | Missouri | 29037 | 111 | 8 |
235395 | 235395 | 2020-06-13 | Cass | Missouri | 29037 | 111 | 8 |
232289 | 232289 | 2020-06-12 | Cass | Missouri | 29037 | 111 | 8 |
229185 | 229185 | 2020-06-11 | Cass | Missouri | 29037 | 110 | 8 |
226082 | 226082 | 2020-06-10 | Cass | Missouri | 29037 | 108 | 8 |
222984 | 222984 | 2020-06-09 | Cass | Missouri | 29037 | 105 | 8 |
219889 | 219889 | 2020-06-08 | Cass | Missouri | 29037 | 104 | 8 |
216797 | 216797 | 2020-06-07 | Cass | Missouri | 29037 | 102 | 8 |
213709 | 213709 | 2020-06-06 | Cass | Missouri | 29037 | 102 | 8 |
210625 | 210625 | 2020-06-05 | Cass | Missouri | 29037 | 99 | 8 |
207544 | 207544 | 2020-06-04 | Cass | Missouri | 29037 | 100 | 8 |
204463 | 204463 | 2020-06-03 | Cass | Missouri | 29037 | 97 | 8 |
201386 | 201386 | 2020-06-02 | Cass | Missouri | 29037 | 96 | 8 |
198313 | 198313 | 2020-06-01 | Cass | Missouri | 29037 | 93 | 8 |
195242 | 195242 | 2020-05-31 | Cass | Missouri | 29037 | 90 | 8 |
192174 | 192174 | 2020-05-30 | Cass | Missouri | 29037 | 89 | 8 |
189110 | 189110 | 2020-05-29 | Cass | Missouri | 29037 | 86 | 8 |
186052 | 186052 | 2020-05-28 | Cass | Missouri | 29037 | 85 | 8 |
182996 | 182996 | 2020-05-27 | Cass | Missouri | 29037 | 83 | 8 |
179950 | 179950 | 2020-05-26 | Cass | Missouri | 29037 | 82 | 8 |
176906 | 176906 | 2020-05-25 | Cass | Missouri | 29037 | 80 | 8 |
173863 | 173863 | 2020-05-24 | Cass | Missouri | 29037 | 79 | 8 |
170821 | 170821 | 2020-05-23 | Cass | Missouri | 29037 | 77 | 8 |
167783 | 167783 | 2020-05-22 | Cass | Missouri | 29037 | 77 | 8 |
164747 | 164747 | 2020-05-21 | Cass | Missouri | 29037 | 77 | 8 |
161718 | 161718 | 2020-05-20 | Cass | Missouri | 29037 | 77 | 8 |
158692 | 158692 | 2020-05-19 | Cass | Missouri | 29037 | 75 | 8 |
155674 | 155674 | 2020-05-18 | Cass | Missouri | 29037 | 75 | 8 |
152660 | 152660 | 2020-05-17 | Cass | Missouri | 29037 | 74 | 8 |
149649 | 149649 | 2020-05-16 | Cass | Missouri | 29037 | 74 | 8 |
146644 | 146644 | 2020-05-15 | Cass | Missouri | 29037 | 73 | 8 |
143644 | 143644 | 2020-05-14 | Cass | Missouri | 29037 | 73 | 8 |
140649 | 140649 | 2020-05-13 | Cass | Missouri | 29037 | 70 | 8 |
137655 | 137655 | 2020-05-12 | Cass | Missouri | 29037 | 70 | 8 |
134665 | 134665 | 2020-05-11 | Cass | Missouri | 29037 | 70 | 8 |
131674 | 131674 | 2020-05-10 | Cass | Missouri | 29037 | 70 | 8 |
128684 | 128684 | 2020-05-09 | Cass | Missouri | 29037 | 69 | 8 |
125697 | 125697 | 2020-05-08 | Cass | Missouri | 29037 | 69 | 8 |
122715 | 122715 | 2020-05-07 | Cass | Missouri | 29037 | 67 | 7 |
119741 | 119741 | 2020-05-06 | Cass | Missouri | 29037 | 66 | 6 |
116781 | 116781 | 2020-05-05 | Cass | Missouri | 29037 | 65 | 6 |
113899 | 113899 | 2020-05-04 | Cass | Missouri | 29037 | 64 | 6 |
111020 | 111020 | 2020-05-03 | Cass | Missouri | 29037 | 64 | 6 |
108149 | 108149 | 2020-05-02 | Cass | Missouri | 29037 | 64 | 6 |
105284 | 105284 | 2020-05-01 | Cass | Missouri | 29037 | 63 | 6 |
102423 | 102423 | 2020-04-30 | Cass | Missouri | 29037 | 62 | 6 |
99571 | 99571 | 2020-04-29 | Cass | Missouri | 29037 | 62 | 6 |
96725 | 96725 | 2020-04-28 | Cass | Missouri | 29037 | 61 | 6 |
93889 | 93889 | 2020-04-27 | Cass | Missouri | 29037 | 58 | 6 |
91068 | 91068 | 2020-04-26 | Cass | Missouri | 29037 | 58 | 6 |
88252 | 88252 | 2020-04-25 | Cass | Missouri | 29037 | 58 | 6 |
85442 | 85442 | 2020-04-24 | Cass | Missouri | 29037 | 55 | 6 |
82638 | 82638 | 2020-04-23 | Cass | Missouri | 29037 | 55 | 6 |
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);