ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where county = "Lawrence" and fips = 29109 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
111050 | 111050 | 2020-05-03 | Lawrence | Missouri | 29109 | 1 | 0 |
113929 | 113929 | 2020-05-04 | Lawrence | Missouri | 29109 | 1 | 0 |
116811 | 116811 | 2020-05-05 | Lawrence | Missouri | 29109 | 1 | 0 |
119771 | 119771 | 2020-05-06 | Lawrence | Missouri | 29109 | 1 | 0 |
122745 | 122745 | 2020-05-07 | Lawrence | Missouri | 29109 | 2 | 0 |
125727 | 125727 | 2020-05-08 | Lawrence | Missouri | 29109 | 7 | 0 |
128715 | 128715 | 2020-05-09 | Lawrence | Missouri | 29109 | 7 | 0 |
131705 | 131705 | 2020-05-10 | Lawrence | Missouri | 29109 | 7 | 0 |
134696 | 134696 | 2020-05-11 | Lawrence | Missouri | 29109 | 7 | 0 |
137686 | 137686 | 2020-05-12 | Lawrence | Missouri | 29109 | 7 | 0 |
140680 | 140680 | 2020-05-13 | Lawrence | Missouri | 29109 | 7 | 0 |
143675 | 143675 | 2020-05-14 | Lawrence | Missouri | 29109 | 7 | 0 |
146676 | 146676 | 2020-05-15 | Lawrence | Missouri | 29109 | 7 | 0 |
149681 | 149681 | 2020-05-16 | Lawrence | Missouri | 29109 | 7 | 0 |
152692 | 152692 | 2020-05-17 | Lawrence | Missouri | 29109 | 7 | 0 |
155706 | 155706 | 2020-05-18 | Lawrence | Missouri | 29109 | 7 | 0 |
158724 | 158724 | 2020-05-19 | Lawrence | Missouri | 29109 | 8 | 0 |
161750 | 161750 | 2020-05-20 | Lawrence | Missouri | 29109 | 7 | 0 |
164779 | 164779 | 2020-05-21 | Lawrence | Missouri | 29109 | 7 | 0 |
167815 | 167815 | 2020-05-22 | Lawrence | Missouri | 29109 | 7 | 0 |
170854 | 170854 | 2020-05-23 | Lawrence | Missouri | 29109 | 7 | 0 |
173896 | 173896 | 2020-05-24 | Lawrence | Missouri | 29109 | 7 | 0 |
176939 | 176939 | 2020-05-25 | Lawrence | Missouri | 29109 | 7 | 0 |
179983 | 179983 | 2020-05-26 | Lawrence | Missouri | 29109 | 7 | 0 |
183029 | 183029 | 2020-05-27 | Lawrence | Missouri | 29109 | 7 | 0 |
186085 | 186085 | 2020-05-28 | Lawrence | Missouri | 29109 | 7 | 0 |
189143 | 189143 | 2020-05-29 | Lawrence | Missouri | 29109 | 7 | 0 |
192207 | 192207 | 2020-05-30 | Lawrence | Missouri | 29109 | 7 | 0 |
195276 | 195276 | 2020-05-31 | Lawrence | Missouri | 29109 | 7 | 0 |
198347 | 198347 | 2020-06-01 | Lawrence | Missouri | 29109 | 7 | 0 |
201420 | 201420 | 2020-06-02 | Lawrence | Missouri | 29109 | 7 | 0 |
204497 | 204497 | 2020-06-03 | Lawrence | Missouri | 29109 | 7 | 0 |
207578 | 207578 | 2020-06-04 | Lawrence | Missouri | 29109 | 7 | 0 |
210659 | 210659 | 2020-06-05 | Lawrence | Missouri | 29109 | 7 | 0 |
213743 | 213743 | 2020-06-06 | Lawrence | Missouri | 29109 | 7 | 0 |
216831 | 216831 | 2020-06-07 | Lawrence | Missouri | 29109 | 7 | 0 |
219923 | 219923 | 2020-06-08 | Lawrence | Missouri | 29109 | 7 | 0 |
223018 | 223018 | 2020-06-09 | Lawrence | Missouri | 29109 | 7 | 0 |
226117 | 226117 | 2020-06-10 | Lawrence | Missouri | 29109 | 7 | 0 |
229220 | 229220 | 2020-06-11 | Lawrence | Missouri | 29109 | 7 | 0 |
232324 | 232324 | 2020-06-12 | Lawrence | Missouri | 29109 | 7 | 0 |
235430 | 235430 | 2020-06-13 | Lawrence | Missouri | 29109 | 7 | 0 |
238537 | 238537 | 2020-06-14 | Lawrence | Missouri | 29109 | 7 | 0 |
241647 | 241647 | 2020-06-15 | Lawrence | Missouri | 29109 | 7 | 0 |
244758 | 244758 | 2020-06-16 | Lawrence | Missouri | 29109 | 8 | 0 |
247871 | 247871 | 2020-06-17 | Lawrence | Missouri | 29109 | 8 | 0 |
250984 | 250984 | 2020-06-18 | Lawrence | Missouri | 29109 | 10 | 0 |
254099 | 254099 | 2020-06-19 | Lawrence | Missouri | 29109 | 11 | 0 |
257219 | 257219 | 2020-06-20 | Lawrence | Missouri | 29109 | 11 | 0 |
260345 | 260345 | 2020-06-21 | Lawrence | Missouri | 29109 | 13 | 0 |
263473 | 263473 | 2020-06-22 | Lawrence | Missouri | 29109 | 13 | 0 |
266599 | 266599 | 2020-06-23 | Lawrence | Missouri | 29109 | 19 | 0 |
269732 | 269732 | 2020-06-24 | Lawrence | Missouri | 29109 | 20 | 0 |
272871 | 272871 | 2020-06-25 | Lawrence | Missouri | 29109 | 20 | 0 |
276014 | 276014 | 2020-06-26 | Lawrence | Missouri | 29109 | 28 | 0 |
279162 | 279162 | 2020-06-27 | Lawrence | Missouri | 29109 | 30 | 0 |
282310 | 282310 | 2020-06-28 | Lawrence | Missouri | 29109 | 31 | 1 |
285455 | 285455 | 2020-06-29 | Lawrence | Missouri | 29109 | 32 | 1 |
288605 | 288605 | 2020-06-30 | Lawrence | Missouri | 29109 | 34 | 1 |
291756 | 291756 | 2020-07-01 | Lawrence | Missouri | 29109 | 37 | 1 |
294910 | 294910 | 2020-07-02 | Lawrence | Missouri | 29109 | 37 | 1 |
298068 | 298068 | 2020-07-03 | Lawrence | Missouri | 29109 | 41 | 1 |
301231 | 301231 | 2020-07-04 | Lawrence | Missouri | 29109 | 41 | 1 |
304395 | 304395 | 2020-07-05 | Lawrence | Missouri | 29109 | 45 | 1 |
307562 | 307562 | 2020-07-06 | Lawrence | Missouri | 29109 | 46 | 1 |
310730 | 310730 | 2020-07-07 | Lawrence | Missouri | 29109 | 48 | 1 |
313901 | 313901 | 2020-07-08 | Lawrence | Missouri | 29109 | 52 | 1 |
317075 | 317075 | 2020-07-09 | Lawrence | Missouri | 29109 | 53 | 1 |
320250 | 320250 | 2020-07-10 | Lawrence | Missouri | 29109 | 54 | 1 |
323429 | 323429 | 2020-07-11 | Lawrence | Missouri | 29109 | 58 | 1 |
326612 | 326612 | 2020-07-12 | Lawrence | Missouri | 29109 | 59 | 1 |
329798 | 329798 | 2020-07-13 | Lawrence | Missouri | 29109 | 60 | 2 |
332985 | 332985 | 2020-07-14 | Lawrence | Missouri | 29109 | 60 | 2 |
336178 | 336178 | 2020-07-15 | Lawrence | Missouri | 29109 | 65 | 2 |
339374 | 339374 | 2020-07-16 | Lawrence | Missouri | 29109 | 81 | 2 |
342570 | 342570 | 2020-07-17 | Lawrence | Missouri | 29109 | 86 | 2 |
345770 | 345770 | 2020-07-18 | Lawrence | Missouri | 29109 | 87 | 2 |
348971 | 348971 | 2020-07-19 | Lawrence | Missouri | 29109 | 94 | 2 |
352171 | 352171 | 2020-07-20 | Lawrence | Missouri | 29109 | 104 | 2 |
355373 | 355373 | 2020-07-21 | Lawrence | Missouri | 29109 | 106 | 2 |
358576 | 358576 | 2020-07-22 | Lawrence | Missouri | 29109 | 110 | 2 |
361781 | 361781 | 2020-07-23 | Lawrence | Missouri | 29109 | 122 | 2 |
364988 | 364988 | 2020-07-24 | Lawrence | Missouri | 29109 | 125 | 2 |
368196 | 368196 | 2020-07-25 | Lawrence | Missouri | 29109 | 134 | 2 |
371407 | 371407 | 2020-07-26 | Lawrence | Missouri | 29109 | 136 | 2 |
374619 | 374619 | 2020-07-27 | Lawrence | Missouri | 29109 | 142 | 2 |
377834 | 377834 | 2020-07-28 | Lawrence | Missouri | 29109 | 152 | 2 |
381051 | 381051 | 2020-07-29 | Lawrence | Missouri | 29109 | 159 | 2 |
384267 | 384267 | 2020-07-30 | Lawrence | Missouri | 29109 | 172 | 2 |
387485 | 387485 | 2020-07-31 | Lawrence | Missouri | 29109 | 182 | 2 |
390702 | 390702 | 2020-08-01 | Lawrence | Missouri | 29109 | 184 | 2 |
393919 | 393919 | 2020-08-02 | Lawrence | Missouri | 29109 | 186 | 2 |
397135 | 397135 | 2020-08-03 | Lawrence | Missouri | 29109 | 192 | 2 |
400349 | 400349 | 2020-08-04 | Lawrence | Missouri | 29109 | 195 | 2 |
403566 | 403566 | 2020-08-05 | Lawrence | Missouri | 29109 | 202 | 2 |
406784 | 406784 | 2020-08-06 | Lawrence | Missouri | 29109 | 205 | 2 |
410004 | 410004 | 2020-08-07 | Lawrence | Missouri | 29109 | 211 | 2 |
413224 | 413224 | 2020-08-08 | Lawrence | Missouri | 29109 | 211 | 2 |
416444 | 416444 | 2020-08-09 | Lawrence | Missouri | 29109 | 228 | 2 |
419665 | 419665 | 2020-08-10 | Lawrence | Missouri | 29109 | 230 | 2 |
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);