ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Union" and fips = 22111 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281936 | 281936 | 2020-06-28 | Union | Louisiana | 22111 | 412 | 24 |
278788 | 278788 | 2020-06-27 | Union | Louisiana | 22111 | 405 | 24 |
275640 | 275640 | 2020-06-26 | Union | Louisiana | 22111 | 405 | 24 |
272497 | 272497 | 2020-06-25 | Union | Louisiana | 22111 | 398 | 23 |
269361 | 269361 | 2020-06-24 | Union | Louisiana | 22111 | 395 | 23 |
266228 | 266228 | 2020-06-23 | Union | Louisiana | 22111 | 391 | 21 |
263101 | 263101 | 2020-06-22 | Union | Louisiana | 22111 | 378 | 20 |
259972 | 259972 | 2020-06-21 | Union | Louisiana | 22111 | 375 | 20 |
256846 | 256846 | 2020-06-20 | Union | Louisiana | 22111 | 375 | 20 |
253726 | 253726 | 2020-06-19 | Union | Louisiana | 22111 | 372 | 20 |
250611 | 250611 | 2020-06-18 | Union | Louisiana | 22111 | 435 | 20 |
247499 | 247499 | 2020-06-17 | Union | Louisiana | 22111 | 435 | 20 |
244386 | 244386 | 2020-06-16 | Union | Louisiana | 22111 | 422 | 20 |
241275 | 241275 | 2020-06-15 | Union | Louisiana | 22111 | 422 | 20 |
238166 | 238166 | 2020-06-14 | Union | Louisiana | 22111 | 411 | 20 |
235059 | 235059 | 2020-06-13 | Union | Louisiana | 22111 | 409 | 20 |
231954 | 231954 | 2020-06-12 | Union | Louisiana | 22111 | 385 | 20 |
228850 | 228850 | 2020-06-11 | Union | Louisiana | 22111 | 383 | 20 |
225748 | 225748 | 2020-06-10 | Union | Louisiana | 22111 | 375 | 20 |
222652 | 222652 | 2020-06-09 | Union | Louisiana | 22111 | 366 | 20 |
219557 | 219557 | 2020-06-08 | Union | Louisiana | 22111 | 349 | 20 |
216465 | 216465 | 2020-06-07 | Union | Louisiana | 22111 | 348 | 20 |
213378 | 213378 | 2020-06-06 | Union | Louisiana | 22111 | 344 | 20 |
210293 | 210293 | 2020-06-05 | Union | Louisiana | 22111 | 343 | 20 |
207212 | 207212 | 2020-06-04 | Union | Louisiana | 22111 | 333 | 19 |
204131 | 204131 | 2020-06-03 | Union | Louisiana | 22111 | 331 | 19 |
201054 | 201054 | 2020-06-02 | Union | Louisiana | 22111 | 324 | 19 |
197982 | 197982 | 2020-06-01 | Union | Louisiana | 22111 | 324 | 17 |
194911 | 194911 | 2020-05-31 | Union | Louisiana | 22111 | 317 | 17 |
191843 | 191843 | 2020-05-30 | Union | Louisiana | 22111 | 313 | 17 |
188779 | 188779 | 2020-05-29 | Union | Louisiana | 22111 | 306 | 17 |
185721 | 185721 | 2020-05-28 | Union | Louisiana | 22111 | 306 | 17 |
182666 | 182666 | 2020-05-27 | Union | Louisiana | 22111 | 303 | 17 |
179621 | 179621 | 2020-05-26 | Union | Louisiana | 22111 | 295 | 17 |
176577 | 176577 | 2020-05-25 | Union | Louisiana | 22111 | 291 | 16 |
173533 | 173533 | 2020-05-24 | Union | Louisiana | 22111 | 287 | 16 |
170492 | 170492 | 2020-05-23 | Union | Louisiana | 22111 | 287 | 16 |
167454 | 167454 | 2020-05-22 | Union | Louisiana | 22111 | 287 | 16 |
164418 | 164418 | 2020-05-21 | Union | Louisiana | 22111 | 287 | 16 |
161389 | 161389 | 2020-05-20 | Union | Louisiana | 22111 | 245 | 14 |
158363 | 158363 | 2020-05-19 | Union | Louisiana | 22111 | 245 | 15 |
155345 | 155345 | 2020-05-18 | Union | Louisiana | 22111 | 243 | 14 |
152331 | 152331 | 2020-05-17 | Union | Louisiana | 22111 | 242 | 14 |
149320 | 149320 | 2020-05-16 | Union | Louisiana | 22111 | 236 | 14 |
146315 | 146315 | 2020-05-15 | Union | Louisiana | 22111 | 238 | 13 |
143315 | 143315 | 2020-05-14 | Union | Louisiana | 22111 | 231 | 11 |
140320 | 140320 | 2020-05-13 | Union | Louisiana | 22111 | 227 | 11 |
137326 | 137326 | 2020-05-12 | Union | Louisiana | 22111 | 171 | 11 |
134336 | 134336 | 2020-05-11 | Union | Louisiana | 22111 | 169 | 10 |
131345 | 131345 | 2020-05-10 | Union | Louisiana | 22111 | 165 | 9 |
128355 | 128355 | 2020-05-09 | Union | Louisiana | 22111 | 162 | 8 |
125368 | 125368 | 2020-05-08 | Union | Louisiana | 22111 | 153 | 8 |
122386 | 122386 | 2020-05-07 | Union | Louisiana | 22111 | 151 | 8 |
119415 | 119415 | 2020-05-06 | Union | Louisiana | 22111 | 148 | 7 |
116454 | 116454 | 2020-05-05 | Union | Louisiana | 22111 | 144 | 7 |
113572 | 113572 | 2020-05-04 | Union | Louisiana | 22111 | 143 | 7 |
110695 | 110695 | 2020-05-03 | Union | Louisiana | 22111 | 135 | 7 |
107823 | 107823 | 2020-05-02 | Union | Louisiana | 22111 | 131 | 7 |
104959 | 104959 | 2020-05-01 | Union | Louisiana | 22111 | 125 | 6 |
102098 | 102098 | 2020-04-30 | Union | Louisiana | 22111 | 117 | 6 |
99246 | 99246 | 2020-04-29 | Union | Louisiana | 22111 | 114 | 6 |
96400 | 96400 | 2020-04-28 | Union | Louisiana | 22111 | 108 | 6 |
93565 | 93565 | 2020-04-27 | Union | Louisiana | 22111 | 103 | 6 |
90744 | 90744 | 2020-04-26 | Union | Louisiana | 22111 | 102 | 6 |
87928 | 87928 | 2020-04-25 | Union | Louisiana | 22111 | 102 | 6 |
85119 | 85119 | 2020-04-24 | Union | Louisiana | 22111 | 95 | 6 |
82315 | 82315 | 2020-04-23 | Union | Louisiana | 22111 | 89 | 6 |
79519 | 79519 | 2020-04-22 | Union | Louisiana | 22111 | 85 | 5 |
76733 | 76733 | 2020-04-21 | Union | Louisiana | 22111 | 82 | 5 |
73953 | 73953 | 2020-04-20 | Union | Louisiana | 22111 | 79 | 5 |
71181 | 71181 | 2020-04-19 | Union | Louisiana | 22111 | 78 | 5 |
68418 | 68418 | 2020-04-18 | Union | Louisiana | 22111 | 75 | 5 |
65669 | 65669 | 2020-04-17 | Union | Louisiana | 22111 | 71 | 5 |
62930 | 62930 | 2020-04-16 | Union | Louisiana | 22111 | 67 | 4 |
60209 | 60209 | 2020-04-15 | Union | Louisiana | 22111 | 56 | 4 |
57501 | 57501 | 2020-04-14 | Union | Louisiana | 22111 | 50 | 4 |
54803 | 54803 | 2020-04-13 | Union | Louisiana | 22111 | 48 | 3 |
52122 | 52122 | 2020-04-12 | Union | Louisiana | 22111 | 47 | 3 |
49452 | 49452 | 2020-04-11 | Union | Louisiana | 22111 | 45 | 3 |
46810 | 46810 | 2020-04-10 | Union | Louisiana | 22111 | 41 | 3 |
44202 | 44202 | 2020-04-09 | Union | Louisiana | 22111 | 39 | 3 |
41626 | 41626 | 2020-04-08 | Union | Louisiana | 22111 | 35 | 3 |
39074 | 39074 | 2020-04-07 | Union | Louisiana | 22111 | 33 | 0 |
36566 | 36566 | 2020-04-06 | Union | Louisiana | 22111 | 26 | 0 |
34108 | 34108 | 2020-04-05 | Union | Louisiana | 22111 | 19 | 0 |
31683 | 31683 | 2020-04-04 | Union | Louisiana | 22111 | 19 | 0 |
29305 | 29305 | 2020-04-03 | Union | Louisiana | 22111 | 17 | 0 |
26988 | 26988 | 2020-04-02 | Union | Louisiana | 22111 | 13 | 0 |
24737 | 24737 | 2020-04-01 | Union | Louisiana | 22111 | 11 | 0 |
22561 | 22561 | 2020-03-31 | Union | Louisiana | 22111 | 9 | 0 |
20452 | 20452 | 2020-03-30 | Union | Louisiana | 22111 | 9 | 0 |
18436 | 18436 | 2020-03-29 | Union | Louisiana | 22111 | 9 | 0 |
16522 | 16522 | 2020-03-28 | Union | Louisiana | 22111 | 7 | 0 |
14702 | 14702 | 2020-03-27 | Union | Louisiana | 22111 | 4 | 0 |
12995 | 12995 | 2020-03-26 | Union | Louisiana | 22111 | 2 | 0 |
11416 | 11416 | 2020-03-25 | Union | Louisiana | 22111 | 2 | 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);