ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where deaths = 0 and fips = 29101 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
310724 | 310724 | 2020-07-07 | Johnson | Missouri | 29101 | 197 | 0 |
307556 | 307556 | 2020-07-06 | Johnson | Missouri | 29101 | 185 | 0 |
304389 | 304389 | 2020-07-05 | Johnson | Missouri | 29101 | 162 | 0 |
301225 | 301225 | 2020-07-04 | Johnson | Missouri | 29101 | 161 | 0 |
298062 | 298062 | 2020-07-03 | Johnson | Missouri | 29101 | 151 | 0 |
294904 | 294904 | 2020-07-02 | Johnson | Missouri | 29101 | 141 | 0 |
291750 | 291750 | 2020-07-01 | Johnson | Missouri | 29101 | 124 | 0 |
288599 | 288599 | 2020-06-30 | Johnson | Missouri | 29101 | 124 | 0 |
285449 | 285449 | 2020-06-29 | Johnson | Missouri | 29101 | 120 | 0 |
282304 | 282304 | 2020-06-28 | Johnson | Missouri | 29101 | 113 | 0 |
279156 | 279156 | 2020-06-27 | Johnson | Missouri | 29101 | 112 | 0 |
276008 | 276008 | 2020-06-26 | Johnson | Missouri | 29101 | 101 | 0 |
272865 | 272865 | 2020-06-25 | Johnson | Missouri | 29101 | 100 | 0 |
269727 | 269727 | 2020-06-24 | Johnson | Missouri | 29101 | 91 | 0 |
266594 | 266594 | 2020-06-23 | Johnson | Missouri | 29101 | 91 | 0 |
263468 | 263468 | 2020-06-22 | Johnson | Missouri | 29101 | 89 | 0 |
260340 | 260340 | 2020-06-21 | Johnson | Missouri | 29101 | 89 | 0 |
257214 | 257214 | 2020-06-20 | Johnson | Missouri | 29101 | 89 | 0 |
254094 | 254094 | 2020-06-19 | Johnson | Missouri | 29101 | 90 | 0 |
250979 | 250979 | 2020-06-18 | Johnson | Missouri | 29101 | 87 | 0 |
247866 | 247866 | 2020-06-17 | Johnson | Missouri | 29101 | 84 | 0 |
244753 | 244753 | 2020-06-16 | Johnson | Missouri | 29101 | 81 | 0 |
241642 | 241642 | 2020-06-15 | Johnson | Missouri | 29101 | 80 | 0 |
238532 | 238532 | 2020-06-14 | Johnson | Missouri | 29101 | 80 | 0 |
235425 | 235425 | 2020-06-13 | Johnson | Missouri | 29101 | 80 | 0 |
232319 | 232319 | 2020-06-12 | Johnson | Missouri | 29101 | 79 | 0 |
229215 | 229215 | 2020-06-11 | Johnson | Missouri | 29101 | 79 | 0 |
226112 | 226112 | 2020-06-10 | Johnson | Missouri | 29101 | 78 | 0 |
223014 | 223014 | 2020-06-09 | Johnson | Missouri | 29101 | 78 | 0 |
219919 | 219919 | 2020-06-08 | Johnson | Missouri | 29101 | 78 | 0 |
216827 | 216827 | 2020-06-07 | Johnson | Missouri | 29101 | 77 | 0 |
213739 | 213739 | 2020-06-06 | Johnson | Missouri | 29101 | 77 | 0 |
210655 | 210655 | 2020-06-05 | Johnson | Missouri | 29101 | 77 | 0 |
207574 | 207574 | 2020-06-04 | Johnson | Missouri | 29101 | 77 | 0 |
204493 | 204493 | 2020-06-03 | Johnson | Missouri | 29101 | 77 | 0 |
201416 | 201416 | 2020-06-02 | Johnson | Missouri | 29101 | 76 | 0 |
198343 | 198343 | 2020-06-01 | Johnson | Missouri | 29101 | 76 | 0 |
195272 | 195272 | 2020-05-31 | Johnson | Missouri | 29101 | 76 | 0 |
192203 | 192203 | 2020-05-30 | Johnson | Missouri | 29101 | 76 | 0 |
189139 | 189139 | 2020-05-29 | Johnson | Missouri | 29101 | 76 | 0 |
186081 | 186081 | 2020-05-28 | Johnson | Missouri | 29101 | 74 | 0 |
183025 | 183025 | 2020-05-27 | Johnson | Missouri | 29101 | 73 | 0 |
179979 | 179979 | 2020-05-26 | Johnson | Missouri | 29101 | 73 | 0 |
176935 | 176935 | 2020-05-25 | Johnson | Missouri | 29101 | 73 | 0 |
173892 | 173892 | 2020-05-24 | Johnson | Missouri | 29101 | 72 | 0 |
170850 | 170850 | 2020-05-23 | Johnson | Missouri | 29101 | 72 | 0 |
167811 | 167811 | 2020-05-22 | Johnson | Missouri | 29101 | 71 | 0 |
164775 | 164775 | 2020-05-21 | Johnson | Missouri | 29101 | 72 | 0 |
161746 | 161746 | 2020-05-20 | Johnson | Missouri | 29101 | 72 | 0 |
158720 | 158720 | 2020-05-19 | Johnson | Missouri | 29101 | 72 | 0 |
155702 | 155702 | 2020-05-18 | Johnson | Missouri | 29101 | 72 | 0 |
152688 | 152688 | 2020-05-17 | Johnson | Missouri | 29101 | 71 | 0 |
149677 | 149677 | 2020-05-16 | Johnson | Missouri | 29101 | 71 | 0 |
146672 | 146672 | 2020-05-15 | Johnson | Missouri | 29101 | 71 | 0 |
143671 | 143671 | 2020-05-14 | Johnson | Missouri | 29101 | 69 | 0 |
140676 | 140676 | 2020-05-13 | Johnson | Missouri | 29101 | 65 | 0 |
137682 | 137682 | 2020-05-12 | Johnson | Missouri | 29101 | 65 | 0 |
134692 | 134692 | 2020-05-11 | Johnson | Missouri | 29101 | 63 | 0 |
131701 | 131701 | 2020-05-10 | Johnson | Missouri | 29101 | 63 | 0 |
128711 | 128711 | 2020-05-09 | Johnson | Missouri | 29101 | 62 | 0 |
125724 | 125724 | 2020-05-08 | Johnson | Missouri | 29101 | 62 | 0 |
122742 | 122742 | 2020-05-07 | Johnson | Missouri | 29101 | 62 | 0 |
119768 | 119768 | 2020-05-06 | Johnson | Missouri | 29101 | 60 | 0 |
116808 | 116808 | 2020-05-05 | Johnson | Missouri | 29101 | 60 | 0 |
113926 | 113926 | 2020-05-04 | Johnson | Missouri | 29101 | 59 | 0 |
111047 | 111047 | 2020-05-03 | Johnson | Missouri | 29101 | 59 | 0 |
108176 | 108176 | 2020-05-02 | Johnson | Missouri | 29101 | 57 | 0 |
105311 | 105311 | 2020-05-01 | Johnson | Missouri | 29101 | 55 | 0 |
102450 | 102450 | 2020-04-30 | Johnson | Missouri | 29101 | 54 | 0 |
99598 | 99598 | 2020-04-29 | Johnson | Missouri | 29101 | 54 | 0 |
96752 | 96752 | 2020-04-28 | Johnson | Missouri | 29101 | 54 | 0 |
93916 | 93916 | 2020-04-27 | Johnson | Missouri | 29101 | 54 | 0 |
91095 | 91095 | 2020-04-26 | Johnson | Missouri | 29101 | 53 | 0 |
88279 | 88279 | 2020-04-25 | Johnson | Missouri | 29101 | 53 | 0 |
85469 | 85469 | 2020-04-24 | Johnson | Missouri | 29101 | 53 | 0 |
82665 | 82665 | 2020-04-23 | Johnson | Missouri | 29101 | 52 | 0 |
79869 | 79869 | 2020-04-22 | Johnson | Missouri | 29101 | 52 | 0 |
77083 | 77083 | 2020-04-21 | Johnson | Missouri | 29101 | 52 | 0 |
74302 | 74302 | 2020-04-20 | Johnson | Missouri | 29101 | 50 | 0 |
71529 | 71529 | 2020-04-19 | Johnson | Missouri | 29101 | 48 | 0 |
68762 | 68762 | 2020-04-18 | Johnson | Missouri | 29101 | 48 | 0 |
66010 | 66010 | 2020-04-17 | Johnson | Missouri | 29101 | 48 | 0 |
63270 | 63270 | 2020-04-16 | Johnson | Missouri | 29101 | 45 | 0 |
60548 | 60548 | 2020-04-15 | Johnson | Missouri | 29101 | 41 | 0 |
57835 | 57835 | 2020-04-14 | Johnson | Missouri | 29101 | 40 | 0 |
55137 | 55137 | 2020-04-13 | Johnson | Missouri | 29101 | 39 | 0 |
52455 | 52455 | 2020-04-12 | Johnson | Missouri | 29101 | 37 | 0 |
49782 | 49782 | 2020-04-11 | Johnson | Missouri | 29101 | 37 | 0 |
47134 | 47134 | 2020-04-10 | Johnson | Missouri | 29101 | 36 | 0 |
44525 | 44525 | 2020-04-09 | Johnson | Missouri | 29101 | 36 | 0 |
41948 | 41948 | 2020-04-08 | Johnson | Missouri | 29101 | 35 | 0 |
39394 | 39394 | 2020-04-07 | Johnson | Missouri | 29101 | 33 | 0 |
36881 | 36881 | 2020-04-06 | Johnson | Missouri | 29101 | 32 | 0 |
34417 | 34417 | 2020-04-05 | Johnson | Missouri | 29101 | 29 | 0 |
31989 | 31989 | 2020-04-04 | Johnson | Missouri | 29101 | 29 | 0 |
29609 | 29609 | 2020-04-03 | Johnson | Missouri | 29101 | 28 | 0 |
27289 | 27289 | 2020-04-02 | Johnson | Missouri | 29101 | 26 | 0 |
25033 | 25033 | 2020-04-01 | Johnson | Missouri | 29101 | 14 | 0 |
22845 | 22845 | 2020-03-31 | Johnson | Missouri | 29101 | 10 | 0 |
20726 | 20726 | 2020-03-30 | Johnson | Missouri | 29101 | 9 | 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);