ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "St. Landry", fips = 22097 and state = "Louisiana" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4701 | 4701 | 2020-03-19 | St. Landry | Louisiana | 22097 | 2 | 0 |
5518 | 5518 | 2020-03-20 | St. Landry | Louisiana | 22097 | 2 | 0 |
6472 | 6472 | 2020-03-21 | St. Landry | Louisiana | 22097 | 3 | 0 |
7547 | 7547 | 2020-03-22 | St. Landry | Louisiana | 22097 | 3 | 0 |
8715 | 8715 | 2020-03-23 | St. Landry | Louisiana | 22097 | 3 | 0 |
10003 | 10003 | 2020-03-24 | St. Landry | Louisiana | 22097 | 3 | 0 |
11410 | 11410 | 2020-03-25 | St. Landry | Louisiana | 22097 | 4 | 0 |
12989 | 12989 | 2020-03-26 | St. Landry | Louisiana | 22097 | 5 | 0 |
14696 | 14696 | 2020-03-27 | St. Landry | Louisiana | 22097 | 10 | 0 |
16516 | 16516 | 2020-03-28 | St. Landry | Louisiana | 22097 | 10 | 0 |
18430 | 18430 | 2020-03-29 | St. Landry | Louisiana | 22097 | 10 | 0 |
20446 | 20446 | 2020-03-30 | St. Landry | Louisiana | 22097 | 15 | 1 |
22555 | 22555 | 2020-03-31 | St. Landry | Louisiana | 22097 | 31 | 1 |
24731 | 24731 | 2020-04-01 | St. Landry | Louisiana | 22097 | 45 | 1 |
26982 | 26982 | 2020-04-02 | St. Landry | Louisiana | 22097 | 56 | 1 |
29299 | 29299 | 2020-04-03 | St. Landry | Louisiana | 22097 | 68 | 2 |
31677 | 31677 | 2020-04-04 | St. Landry | Louisiana | 22097 | 45 | 2 |
34102 | 34102 | 2020-04-05 | St. Landry | Louisiana | 22097 | 47 | 4 |
36560 | 36560 | 2020-04-06 | St. Landry | Louisiana | 22097 | 52 | 4 |
39068 | 39068 | 2020-04-07 | St. Landry | Louisiana | 22097 | 60 | 4 |
41620 | 41620 | 2020-04-08 | St. Landry | Louisiana | 22097 | 86 | 4 |
44196 | 44196 | 2020-04-09 | St. Landry | Louisiana | 22097 | 90 | 4 |
46804 | 46804 | 2020-04-10 | St. Landry | Louisiana | 22097 | 103 | 6 |
49445 | 49445 | 2020-04-11 | St. Landry | Louisiana | 22097 | 109 | 11 |
52115 | 52115 | 2020-04-12 | St. Landry | Louisiana | 22097 | 113 | 13 |
54796 | 54796 | 2020-04-13 | St. Landry | Louisiana | 22097 | 114 | 13 |
57494 | 57494 | 2020-04-14 | St. Landry | Louisiana | 22097 | 115 | 16 |
60202 | 60202 | 2020-04-15 | St. Landry | Louisiana | 22097 | 116 | 16 |
62923 | 62923 | 2020-04-16 | St. Landry | Louisiana | 22097 | 118 | 17 |
65662 | 65662 | 2020-04-17 | St. Landry | Louisiana | 22097 | 119 | 18 |
68411 | 68411 | 2020-04-18 | St. Landry | Louisiana | 22097 | 133 | 20 |
71174 | 71174 | 2020-04-19 | St. Landry | Louisiana | 22097 | 134 | 20 |
73946 | 73946 | 2020-04-20 | St. Landry | Louisiana | 22097 | 136 | 20 |
76726 | 76726 | 2020-04-21 | St. Landry | Louisiana | 22097 | 136 | 26 |
79512 | 79512 | 2020-04-22 | St. Landry | Louisiana | 22097 | 140 | 29 |
82308 | 82308 | 2020-04-23 | St. Landry | Louisiana | 22097 | 154 | 31 |
85112 | 85112 | 2020-04-24 | St. Landry | Louisiana | 22097 | 157 | 34 |
87921 | 87921 | 2020-04-25 | St. Landry | Louisiana | 22097 | 163 | 34 |
90737 | 90737 | 2020-04-26 | St. Landry | Louisiana | 22097 | 163 | 34 |
93558 | 93558 | 2020-04-27 | St. Landry | Louisiana | 22097 | 167 | 35 |
96393 | 96393 | 2020-04-28 | St. Landry | Louisiana | 22097 | 170 | 37 |
99239 | 99239 | 2020-04-29 | St. Landry | Louisiana | 22097 | 172 | 39 |
102091 | 102091 | 2020-04-30 | St. Landry | Louisiana | 22097 | 180 | 42 |
104952 | 104952 | 2020-05-01 | St. Landry | Louisiana | 22097 | 181 | 44 |
107816 | 107816 | 2020-05-02 | St. Landry | Louisiana | 22097 | 185 | 44 |
110688 | 110688 | 2020-05-03 | St. Landry | Louisiana | 22097 | 186 | 45 |
113565 | 113565 | 2020-05-04 | St. Landry | Louisiana | 22097 | 191 | 45 |
116447 | 116447 | 2020-05-05 | St. Landry | Louisiana | 22097 | 198 | 47 |
119408 | 119408 | 2020-05-06 | St. Landry | Louisiana | 22097 | 202 | 48 |
122379 | 122379 | 2020-05-07 | St. Landry | Louisiana | 22097 | 203 | 49 |
125361 | 125361 | 2020-05-08 | St. Landry | Louisiana | 22097 | 204 | 49 |
128348 | 128348 | 2020-05-09 | St. Landry | Louisiana | 22097 | 211 | 49 |
131338 | 131338 | 2020-05-10 | St. Landry | Louisiana | 22097 | 215 | 50 |
134329 | 134329 | 2020-05-11 | St. Landry | Louisiana | 22097 | 214 | 50 |
137319 | 137319 | 2020-05-12 | St. Landry | Louisiana | 22097 | 215 | 51 |
140313 | 140313 | 2020-05-13 | St. Landry | Louisiana | 22097 | 241 | 51 |
143308 | 143308 | 2020-05-14 | St. Landry | Louisiana | 22097 | 244 | 51 |
146308 | 146308 | 2020-05-15 | St. Landry | Louisiana | 22097 | 244 | 51 |
149313 | 149313 | 2020-05-16 | St. Landry | Louisiana | 22097 | 230 | 51 |
152324 | 152324 | 2020-05-17 | St. Landry | Louisiana | 22097 | 231 | 51 |
155338 | 155338 | 2020-05-18 | St. Landry | Louisiana | 22097 | 235 | 51 |
158356 | 158356 | 2020-05-19 | St. Landry | Louisiana | 22097 | 237 | 51 |
161382 | 161382 | 2020-05-20 | St. Landry | Louisiana | 22097 | 237 | 52 |
164411 | 164411 | 2020-05-21 | St. Landry | Louisiana | 22097 | 244 | 52 |
167447 | 167447 | 2020-05-22 | St. Landry | Louisiana | 22097 | 247 | 52 |
170485 | 170485 | 2020-05-23 | St. Landry | Louisiana | 22097 | 247 | 52 |
173526 | 173526 | 2020-05-24 | St. Landry | Louisiana | 22097 | 247 | 52 |
176570 | 176570 | 2020-05-25 | St. Landry | Louisiana | 22097 | 248 | 52 |
179614 | 179614 | 2020-05-26 | St. Landry | Louisiana | 22097 | 249 | 52 |
182659 | 182659 | 2020-05-27 | St. Landry | Louisiana | 22097 | 252 | 52 |
185714 | 185714 | 2020-05-28 | St. Landry | Louisiana | 22097 | 252 | 54 |
188772 | 188772 | 2020-05-29 | St. Landry | Louisiana | 22097 | 252 | 54 |
191836 | 191836 | 2020-05-30 | St. Landry | Louisiana | 22097 | 255 | 54 |
194904 | 194904 | 2020-05-31 | St. Landry | Louisiana | 22097 | 257 | 54 |
197975 | 197975 | 2020-06-01 | St. Landry | Louisiana | 22097 | 263 | 54 |
201047 | 201047 | 2020-06-02 | St. Landry | Louisiana | 22097 | 266 | 54 |
204124 | 204124 | 2020-06-03 | St. Landry | Louisiana | 22097 | 269 | 54 |
207205 | 207205 | 2020-06-04 | St. Landry | Louisiana | 22097 | 272 | 54 |
210286 | 210286 | 2020-06-05 | St. Landry | Louisiana | 22097 | 308 | 54 |
213371 | 213371 | 2020-06-06 | St. Landry | Louisiana | 22097 | 309 | 54 |
216458 | 216458 | 2020-06-07 | St. Landry | Louisiana | 22097 | 309 | 54 |
219550 | 219550 | 2020-06-08 | St. Landry | Louisiana | 22097 | 311 | 54 |
222645 | 222645 | 2020-06-09 | St. Landry | Louisiana | 22097 | 316 | 54 |
225741 | 225741 | 2020-06-10 | St. Landry | Louisiana | 22097 | 323 | 54 |
228843 | 228843 | 2020-06-11 | St. Landry | Louisiana | 22097 | 324 | 55 |
231947 | 231947 | 2020-06-12 | St. Landry | Louisiana | 22097 | 326 | 55 |
235052 | 235052 | 2020-06-13 | St. Landry | Louisiana | 22097 | 358 | 55 |
238159 | 238159 | 2020-06-14 | St. Landry | Louisiana | 22097 | 360 | 55 |
241268 | 241268 | 2020-06-15 | St. Landry | Louisiana | 22097 | 370 | 55 |
244379 | 244379 | 2020-06-16 | St. Landry | Louisiana | 22097 | 379 | 55 |
247492 | 247492 | 2020-06-17 | St. Landry | Louisiana | 22097 | 393 | 55 |
250604 | 250604 | 2020-06-18 | St. Landry | Louisiana | 22097 | 393 | 55 |
253719 | 253719 | 2020-06-19 | St. Landry | Louisiana | 22097 | 453 | 55 |
256839 | 256839 | 2020-06-20 | St. Landry | Louisiana | 22097 | 462 | 55 |
259965 | 259965 | 2020-06-21 | St. Landry | Louisiana | 22097 | 465 | 55 |
263094 | 263094 | 2020-06-22 | St. Landry | Louisiana | 22097 | 484 | 55 |
266221 | 266221 | 2020-06-23 | St. Landry | Louisiana | 22097 | 517 | 57 |
269354 | 269354 | 2020-06-24 | St. Landry | Louisiana | 22097 | 530 | 57 |
272490 | 272490 | 2020-06-25 | St. Landry | Louisiana | 22097 | 540 | 57 |
275633 | 275633 | 2020-06-26 | St. Landry | Louisiana | 22097 | 578 | 57 |
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);