ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "St. Mary" and state = "Louisiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
6473 | 6473 | 2020-03-21 | St. Mary | Louisiana | 22101 | 1 | 0 |
7548 | 7548 | 2020-03-22 | St. Mary | Louisiana | 22101 | 1 | 0 |
8717 | 8717 | 2020-03-23 | St. Mary | Louisiana | 22101 | 1 | 0 |
10005 | 10005 | 2020-03-24 | St. Mary | Louisiana | 22101 | 2 | 0 |
11412 | 11412 | 2020-03-25 | St. Mary | Louisiana | 22101 | 5 | 0 |
12991 | 12991 | 2020-03-26 | St. Mary | Louisiana | 22101 | 5 | 0 |
14698 | 14698 | 2020-03-27 | St. Mary | Louisiana | 22101 | 6 | 0 |
16518 | 16518 | 2020-03-28 | St. Mary | Louisiana | 22101 | 7 | 0 |
18432 | 18432 | 2020-03-29 | St. Mary | Louisiana | 22101 | 7 | 0 |
20448 | 20448 | 2020-03-30 | St. Mary | Louisiana | 22101 | 10 | 0 |
22557 | 22557 | 2020-03-31 | St. Mary | Louisiana | 22101 | 22 | 0 |
24733 | 24733 | 2020-04-01 | St. Mary | Louisiana | 22101 | 26 | 0 |
26984 | 26984 | 2020-04-02 | St. Mary | Louisiana | 22101 | 42 | 0 |
29301 | 29301 | 2020-04-03 | St. Mary | Louisiana | 22101 | 47 | 0 |
31679 | 31679 | 2020-04-04 | St. Mary | Louisiana | 22101 | 65 | 0 |
34104 | 34104 | 2020-04-05 | St. Mary | Louisiana | 22101 | 67 | 0 |
36562 | 36562 | 2020-04-06 | St. Mary | Louisiana | 22101 | 73 | 0 |
39070 | 39070 | 2020-04-07 | St. Mary | Louisiana | 22101 | 76 | 0 |
41622 | 41622 | 2020-04-08 | St. Mary | Louisiana | 22101 | 81 | 0 |
44198 | 44198 | 2020-04-09 | St. Mary | Louisiana | 22101 | 89 | 1 |
46806 | 46806 | 2020-04-10 | St. Mary | Louisiana | 22101 | 100 | 1 |
49447 | 49447 | 2020-04-11 | St. Mary | Louisiana | 22101 | 105 | 2 |
52117 | 52117 | 2020-04-12 | St. Mary | Louisiana | 22101 | 113 | 2 |
54798 | 54798 | 2020-04-13 | St. Mary | Louisiana | 22101 | 127 | 2 |
57496 | 57496 | 2020-04-14 | St. Mary | Louisiana | 22101 | 129 | 2 |
60204 | 60204 | 2020-04-15 | St. Mary | Louisiana | 22101 | 130 | 4 |
62925 | 62925 | 2020-04-16 | St. Mary | Louisiana | 22101 | 134 | 8 |
65664 | 65664 | 2020-04-17 | St. Mary | Louisiana | 22101 | 137 | 9 |
68413 | 68413 | 2020-04-18 | St. Mary | Louisiana | 22101 | 143 | 11 |
71176 | 71176 | 2020-04-19 | St. Mary | Louisiana | 22101 | 149 | 11 |
73948 | 73948 | 2020-04-20 | St. Mary | Louisiana | 22101 | 156 | 12 |
76728 | 76728 | 2020-04-21 | St. Mary | Louisiana | 22101 | 160 | 16 |
79514 | 79514 | 2020-04-22 | St. Mary | Louisiana | 22101 | 162 | 17 |
82310 | 82310 | 2020-04-23 | St. Mary | Louisiana | 22101 | 168 | 18 |
85114 | 85114 | 2020-04-24 | St. Mary | Louisiana | 22101 | 171 | 18 |
87923 | 87923 | 2020-04-25 | St. Mary | Louisiana | 22101 | 178 | 20 |
90739 | 90739 | 2020-04-26 | St. Mary | Louisiana | 22101 | 179 | 20 |
93560 | 93560 | 2020-04-27 | St. Mary | Louisiana | 22101 | 181 | 20 |
96395 | 96395 | 2020-04-28 | St. Mary | Louisiana | 22101 | 182 | 20 |
99241 | 99241 | 2020-04-29 | St. Mary | Louisiana | 22101 | 185 | 20 |
102093 | 102093 | 2020-04-30 | St. Mary | Louisiana | 22101 | 191 | 20 |
104954 | 104954 | 2020-05-01 | St. Mary | Louisiana | 22101 | 193 | 23 |
107818 | 107818 | 2020-05-02 | St. Mary | Louisiana | 22101 | 199 | 23 |
110690 | 110690 | 2020-05-03 | St. Mary | Louisiana | 22101 | 205 | 23 |
113567 | 113567 | 2020-05-04 | St. Mary | Louisiana | 22101 | 209 | 23 |
116449 | 116449 | 2020-05-05 | St. Mary | Louisiana | 22101 | 212 | 23 |
119410 | 119410 | 2020-05-06 | St. Mary | Louisiana | 22101 | 215 | 24 |
122381 | 122381 | 2020-05-07 | St. Mary | Louisiana | 22101 | 222 | 24 |
125363 | 125363 | 2020-05-08 | St. Mary | Louisiana | 22101 | 224 | 25 |
128350 | 128350 | 2020-05-09 | St. Mary | Louisiana | 22101 | 242 | 26 |
131340 | 131340 | 2020-05-10 | St. Mary | Louisiana | 22101 | 245 | 26 |
134331 | 134331 | 2020-05-11 | St. Mary | Louisiana | 22101 | 250 | 26 |
137321 | 137321 | 2020-05-12 | St. Mary | Louisiana | 22101 | 251 | 26 |
140315 | 140315 | 2020-05-13 | St. Mary | Louisiana | 22101 | 257 | 26 |
143310 | 143310 | 2020-05-14 | St. Mary | Louisiana | 22101 | 263 | 27 |
146310 | 146310 | 2020-05-15 | St. Mary | Louisiana | 22101 | 268 | 28 |
149315 | 149315 | 2020-05-16 | St. Mary | Louisiana | 22101 | 269 | 29 |
152326 | 152326 | 2020-05-17 | St. Mary | Louisiana | 22101 | 274 | 29 |
155340 | 155340 | 2020-05-18 | St. Mary | Louisiana | 22101 | 275 | 29 |
158358 | 158358 | 2020-05-19 | St. Mary | Louisiana | 22101 | 277 | 29 |
161384 | 161384 | 2020-05-20 | St. Mary | Louisiana | 22101 | 281 | 29 |
164413 | 164413 | 2020-05-21 | St. Mary | Louisiana | 22101 | 288 | 29 |
167449 | 167449 | 2020-05-22 | St. Mary | Louisiana | 22101 | 294 | 29 |
170487 | 170487 | 2020-05-23 | St. Mary | Louisiana | 22101 | 294 | 29 |
173528 | 173528 | 2020-05-24 | St. Mary | Louisiana | 22101 | 295 | 29 |
176572 | 176572 | 2020-05-25 | St. Mary | Louisiana | 22101 | 302 | 29 |
179616 | 179616 | 2020-05-26 | St. Mary | Louisiana | 22101 | 304 | 29 |
182661 | 182661 | 2020-05-27 | St. Mary | Louisiana | 22101 | 308 | 29 |
185716 | 185716 | 2020-05-28 | St. Mary | Louisiana | 22101 | 309 | 29 |
188774 | 188774 | 2020-05-29 | St. Mary | Louisiana | 22101 | 309 | 29 |
191838 | 191838 | 2020-05-30 | St. Mary | Louisiana | 22101 | 317 | 30 |
194906 | 194906 | 2020-05-31 | St. Mary | Louisiana | 22101 | 319 | 30 |
197977 | 197977 | 2020-06-01 | St. Mary | Louisiana | 22101 | 321 | 30 |
201049 | 201049 | 2020-06-02 | St. Mary | Louisiana | 22101 | 323 | 31 |
204126 | 204126 | 2020-06-03 | St. Mary | Louisiana | 22101 | 328 | 32 |
207207 | 207207 | 2020-06-04 | St. Mary | Louisiana | 22101 | 331 | 32 |
210288 | 210288 | 2020-06-05 | St. Mary | Louisiana | 22101 | 333 | 32 |
213373 | 213373 | 2020-06-06 | St. Mary | Louisiana | 22101 | 337 | 32 |
216460 | 216460 | 2020-06-07 | St. Mary | Louisiana | 22101 | 339 | 32 |
219552 | 219552 | 2020-06-08 | St. Mary | Louisiana | 22101 | 339 | 32 |
222647 | 222647 | 2020-06-09 | St. Mary | Louisiana | 22101 | 342 | 32 |
225743 | 225743 | 2020-06-10 | St. Mary | Louisiana | 22101 | 342 | 32 |
228845 | 228845 | 2020-06-11 | St. Mary | Louisiana | 22101 | 346 | 33 |
231949 | 231949 | 2020-06-12 | St. Mary | Louisiana | 22101 | 348 | 33 |
235054 | 235054 | 2020-06-13 | St. Mary | Louisiana | 22101 | 353 | 33 |
238161 | 238161 | 2020-06-14 | St. Mary | Louisiana | 22101 | 356 | 33 |
241270 | 241270 | 2020-06-15 | St. Mary | Louisiana | 22101 | 359 | 33 |
244381 | 244381 | 2020-06-16 | St. Mary | Louisiana | 22101 | 360 | 33 |
247494 | 247494 | 2020-06-17 | St. Mary | Louisiana | 22101 | 363 | 35 |
250606 | 250606 | 2020-06-18 | St. Mary | Louisiana | 22101 | 363 | 35 |
253721 | 253721 | 2020-06-19 | St. Mary | Louisiana | 22101 | 373 | 35 |
256841 | 256841 | 2020-06-20 | St. Mary | Louisiana | 22101 | 378 | 35 |
259967 | 259967 | 2020-06-21 | St. Mary | Louisiana | 22101 | 384 | 35 |
263096 | 263096 | 2020-06-22 | St. Mary | Louisiana | 22101 | 393 | 35 |
266223 | 266223 | 2020-06-23 | St. Mary | Louisiana | 22101 | 405 | 36 |
269356 | 269356 | 2020-06-24 | St. Mary | Louisiana | 22101 | 410 | 37 |
272492 | 272492 | 2020-06-25 | St. Mary | Louisiana | 22101 | 415 | 37 |
275635 | 275635 | 2020-06-26 | St. Mary | Louisiana | 22101 | 426 | 38 |
278783 | 278783 | 2020-06-27 | St. Mary | Louisiana | 22101 | 426 | 38 |
281931 | 281931 | 2020-06-28 | St. Mary | Louisiana | 22101 | 443 | 38 |
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);