ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22119 and state = "Louisiana" sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▲ | cases | deaths |
---|---|---|---|---|---|---|---|
4706 | 4706 | 2020-03-19 | Webster | Louisiana | 22119 | 1 | 0 |
5524 | 5524 | 2020-03-20 | Webster | Louisiana | 22119 | 1 | 0 |
6479 | 6479 | 2020-03-21 | Webster | Louisiana | 22119 | 1 | 0 |
7554 | 7554 | 2020-03-22 | Webster | Louisiana | 22119 | 1 | 0 |
8723 | 8723 | 2020-03-23 | Webster | Louisiana | 22119 | 3 | 1 |
10012 | 10012 | 2020-03-24 | Webster | Louisiana | 22119 | 3 | 1 |
11420 | 11420 | 2020-03-25 | Webster | Louisiana | 22119 | 5 | 1 |
13000 | 13000 | 2020-03-26 | Webster | Louisiana | 22119 | 8 | 1 |
14707 | 14707 | 2020-03-27 | Webster | Louisiana | 22119 | 9 | 1 |
16527 | 16527 | 2020-03-28 | Webster | Louisiana | 22119 | 9 | 1 |
18441 | 18441 | 2020-03-29 | Webster | Louisiana | 22119 | 9 | 1 |
20457 | 20457 | 2020-03-30 | Webster | Louisiana | 22119 | 11 | 1 |
22566 | 22566 | 2020-03-31 | Webster | Louisiana | 22119 | 17 | 1 |
24742 | 24742 | 2020-04-01 | Webster | Louisiana | 22119 | 17 | 1 |
26993 | 26993 | 2020-04-02 | Webster | Louisiana | 22119 | 19 | 2 |
29310 | 29310 | 2020-04-03 | Webster | Louisiana | 22119 | 23 | 2 |
31688 | 31688 | 2020-04-04 | Webster | Louisiana | 22119 | 42 | 2 |
34113 | 34113 | 2020-04-05 | Webster | Louisiana | 22119 | 49 | 2 |
36571 | 36571 | 2020-04-06 | Webster | Louisiana | 22119 | 51 | 2 |
39079 | 39079 | 2020-04-07 | Webster | Louisiana | 22119 | 50 | 2 |
41631 | 41631 | 2020-04-08 | Webster | Louisiana | 22119 | 51 | 2 |
44207 | 44207 | 2020-04-09 | Webster | Louisiana | 22119 | 55 | 2 |
46815 | 46815 | 2020-04-10 | Webster | Louisiana | 22119 | 57 | 2 |
49457 | 49457 | 2020-04-11 | Webster | Louisiana | 22119 | 60 | 2 |
52127 | 52127 | 2020-04-12 | Webster | Louisiana | 22119 | 62 | 2 |
54808 | 54808 | 2020-04-13 | Webster | Louisiana | 22119 | 65 | 2 |
57506 | 57506 | 2020-04-14 | Webster | Louisiana | 22119 | 65 | 2 |
60214 | 60214 | 2020-04-15 | Webster | Louisiana | 22119 | 69 | 4 |
62935 | 62935 | 2020-04-16 | Webster | Louisiana | 22119 | 71 | 4 |
65674 | 65674 | 2020-04-17 | Webster | Louisiana | 22119 | 74 | 4 |
68423 | 68423 | 2020-04-18 | Webster | Louisiana | 22119 | 76 | 4 |
71186 | 71186 | 2020-04-19 | Webster | Louisiana | 22119 | 76 | 4 |
73958 | 73958 | 2020-04-20 | Webster | Louisiana | 22119 | 78 | 4 |
76738 | 76738 | 2020-04-21 | Webster | Louisiana | 22119 | 79 | 4 |
79524 | 79524 | 2020-04-22 | Webster | Louisiana | 22119 | 79 | 4 |
82320 | 82320 | 2020-04-23 | Webster | Louisiana | 22119 | 81 | 4 |
85124 | 85124 | 2020-04-24 | Webster | Louisiana | 22119 | 80 | 4 |
87933 | 87933 | 2020-04-25 | Webster | Louisiana | 22119 | 82 | 4 |
90749 | 90749 | 2020-04-26 | Webster | Louisiana | 22119 | 83 | 4 |
93570 | 93570 | 2020-04-27 | Webster | Louisiana | 22119 | 83 | 4 |
96405 | 96405 | 2020-04-28 | Webster | Louisiana | 22119 | 85 | 4 |
99251 | 99251 | 2020-04-29 | Webster | Louisiana | 22119 | 85 | 4 |
102103 | 102103 | 2020-04-30 | Webster | Louisiana | 22119 | 85 | 4 |
104964 | 104964 | 2020-05-01 | Webster | Louisiana | 22119 | 92 | 4 |
107828 | 107828 | 2020-05-02 | Webster | Louisiana | 22119 | 92 | 4 |
110700 | 110700 | 2020-05-03 | Webster | Louisiana | 22119 | 92 | 4 |
113577 | 113577 | 2020-05-04 | Webster | Louisiana | 22119 | 92 | 4 |
116459 | 116459 | 2020-05-05 | Webster | Louisiana | 22119 | 95 | 4 |
119420 | 119420 | 2020-05-06 | Webster | Louisiana | 22119 | 96 | 4 |
122391 | 122391 | 2020-05-07 | Webster | Louisiana | 22119 | 97 | 4 |
125373 | 125373 | 2020-05-08 | Webster | Louisiana | 22119 | 97 | 4 |
128360 | 128360 | 2020-05-09 | Webster | Louisiana | 22119 | 97 | 4 |
131350 | 131350 | 2020-05-10 | Webster | Louisiana | 22119 | 98 | 4 |
134341 | 134341 | 2020-05-11 | Webster | Louisiana | 22119 | 100 | 4 |
137331 | 137331 | 2020-05-12 | Webster | Louisiana | 22119 | 101 | 4 |
140325 | 140325 | 2020-05-13 | Webster | Louisiana | 22119 | 112 | 4 |
143320 | 143320 | 2020-05-14 | Webster | Louisiana | 22119 | 112 | 5 |
146320 | 146320 | 2020-05-15 | Webster | Louisiana | 22119 | 112 | 5 |
149325 | 149325 | 2020-05-16 | Webster | Louisiana | 22119 | 113 | 5 |
152336 | 152336 | 2020-05-17 | Webster | Louisiana | 22119 | 113 | 5 |
155350 | 155350 | 2020-05-18 | Webster | Louisiana | 22119 | 117 | 5 |
158368 | 158368 | 2020-05-19 | Webster | Louisiana | 22119 | 119 | 5 |
161394 | 161394 | 2020-05-20 | Webster | Louisiana | 22119 | 119 | 5 |
164423 | 164423 | 2020-05-21 | Webster | Louisiana | 22119 | 126 | 5 |
167459 | 167459 | 2020-05-22 | Webster | Louisiana | 22119 | 128 | 5 |
170497 | 170497 | 2020-05-23 | Webster | Louisiana | 22119 | 128 | 6 |
173538 | 173538 | 2020-05-24 | Webster | Louisiana | 22119 | 136 | 6 |
176582 | 176582 | 2020-05-25 | Webster | Louisiana | 22119 | 139 | 6 |
179626 | 179626 | 2020-05-26 | Webster | Louisiana | 22119 | 139 | 6 |
182671 | 182671 | 2020-05-27 | Webster | Louisiana | 22119 | 142 | 6 |
185726 | 185726 | 2020-05-28 | Webster | Louisiana | 22119 | 143 | 6 |
188784 | 188784 | 2020-05-29 | Webster | Louisiana | 22119 | 143 | 7 |
191848 | 191848 | 2020-05-30 | Webster | Louisiana | 22119 | 147 | 7 |
194916 | 194916 | 2020-05-31 | Webster | Louisiana | 22119 | 147 | 7 |
197987 | 197987 | 2020-06-01 | Webster | Louisiana | 22119 | 147 | 7 |
201059 | 201059 | 2020-06-02 | Webster | Louisiana | 22119 | 157 | 7 |
204136 | 204136 | 2020-06-03 | Webster | Louisiana | 22119 | 163 | 7 |
207217 | 207217 | 2020-06-04 | Webster | Louisiana | 22119 | 171 | 7 |
210298 | 210298 | 2020-06-05 | Webster | Louisiana | 22119 | 175 | 8 |
213383 | 213383 | 2020-06-06 | Webster | Louisiana | 22119 | 179 | 8 |
216470 | 216470 | 2020-06-07 | Webster | Louisiana | 22119 | 182 | 8 |
219562 | 219562 | 2020-06-08 | Webster | Louisiana | 22119 | 185 | 8 |
222657 | 222657 | 2020-06-09 | Webster | Louisiana | 22119 | 195 | 8 |
225753 | 225753 | 2020-06-10 | Webster | Louisiana | 22119 | 203 | 8 |
228855 | 228855 | 2020-06-11 | Webster | Louisiana | 22119 | 204 | 8 |
231959 | 231959 | 2020-06-12 | Webster | Louisiana | 22119 | 206 | 8 |
235064 | 235064 | 2020-06-13 | Webster | Louisiana | 22119 | 242 | 8 |
238171 | 238171 | 2020-06-14 | Webster | Louisiana | 22119 | 244 | 8 |
241280 | 241280 | 2020-06-15 | Webster | Louisiana | 22119 | 248 | 8 |
244391 | 244391 | 2020-06-16 | Webster | Louisiana | 22119 | 252 | 8 |
247504 | 247504 | 2020-06-17 | Webster | Louisiana | 22119 | 331 | 10 |
250616 | 250616 | 2020-06-18 | Webster | Louisiana | 22119 | 331 | 10 |
253731 | 253731 | 2020-06-19 | Webster | Louisiana | 22119 | 311 | 9 |
256851 | 256851 | 2020-06-20 | Webster | Louisiana | 22119 | 316 | 9 |
259977 | 259977 | 2020-06-21 | Webster | Louisiana | 22119 | 321 | 9 |
263106 | 263106 | 2020-06-22 | Webster | Louisiana | 22119 | 323 | 9 |
266233 | 266233 | 2020-06-23 | Webster | Louisiana | 22119 | 352 | 9 |
269366 | 269366 | 2020-06-24 | Webster | Louisiana | 22119 | 361 | 9 |
272502 | 272502 | 2020-06-25 | Webster | Louisiana | 22119 | 368 | 9 |
275645 | 275645 | 2020-06-26 | Webster | Louisiana | 22119 | 391 | 10 |
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);