ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Lafayette" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
294509 | 294509 | 2020-07-02 | Lafayette | Louisiana | 22055 | 2472 | 46 |
291355 | 291355 | 2020-07-01 | Lafayette | Louisiana | 22055 | 2359 | 45 |
288204 | 288204 | 2020-06-30 | Lafayette | Louisiana | 22055 | 2158 | 42 |
285055 | 285055 | 2020-06-29 | Lafayette | Louisiana | 22055 | 2058 | 41 |
281909 | 281909 | 2020-06-28 | Lafayette | Louisiana | 22055 | 1972 | 41 |
278761 | 278761 | 2020-06-27 | Lafayette | Louisiana | 22055 | 1862 | 41 |
275613 | 275613 | 2020-06-26 | Lafayette | Louisiana | 22055 | 1862 | 41 |
272470 | 272470 | 2020-06-25 | Lafayette | Louisiana | 22055 | 1723 | 37 |
269334 | 269334 | 2020-06-24 | Lafayette | Louisiana | 22055 | 1654 | 36 |
266201 | 266201 | 2020-06-23 | Lafayette | Louisiana | 22055 | 1574 | 36 |
263074 | 263074 | 2020-06-22 | Lafayette | Louisiana | 22055 | 1440 | 33 |
259945 | 259945 | 2020-06-21 | Lafayette | Louisiana | 22055 | 1396 | 33 |
256819 | 256819 | 2020-06-20 | Lafayette | Louisiana | 22055 | 1364 | 33 |
253699 | 253699 | 2020-06-19 | Lafayette | Louisiana | 22055 | 1310 | 32 |
250584 | 250584 | 2020-06-18 | Lafayette | Louisiana | 22055 | 1302 | 32 |
247472 | 247472 | 2020-06-17 | Lafayette | Louisiana | 22055 | 1302 | 32 |
244359 | 244359 | 2020-06-16 | Lafayette | Louisiana | 22055 | 1243 | 32 |
241248 | 241248 | 2020-06-15 | Lafayette | Louisiana | 22055 | 1202 | 32 |
238139 | 238139 | 2020-06-14 | Lafayette | Louisiana | 22055 | 1148 | 32 |
235032 | 235032 | 2020-06-13 | Lafayette | Louisiana | 22055 | 1140 | 32 |
231927 | 231927 | 2020-06-12 | Lafayette | Louisiana | 22055 | 988 | 32 |
228823 | 228823 | 2020-06-11 | Lafayette | Louisiana | 22055 | 957 | 33 |
225721 | 225721 | 2020-06-10 | Lafayette | Louisiana | 22055 | 931 | 30 |
222625 | 222625 | 2020-06-09 | Lafayette | Louisiana | 22055 | 908 | 30 |
219530 | 219530 | 2020-06-08 | Lafayette | Louisiana | 22055 | 897 | 30 |
216438 | 216438 | 2020-06-07 | Lafayette | Louisiana | 22055 | 880 | 29 |
213351 | 213351 | 2020-06-06 | Lafayette | Louisiana | 22055 | 866 | 29 |
210266 | 210266 | 2020-06-05 | Lafayette | Louisiana | 22055 | 854 | 29 |
207185 | 207185 | 2020-06-04 | Lafayette | Louisiana | 22055 | 834 | 28 |
204104 | 204104 | 2020-06-03 | Lafayette | Louisiana | 22055 | 821 | 27 |
201027 | 201027 | 2020-06-02 | Lafayette | Louisiana | 22055 | 803 | 27 |
197955 | 197955 | 2020-06-01 | Lafayette | Louisiana | 22055 | 793 | 26 |
194884 | 194884 | 2020-05-31 | Lafayette | Louisiana | 22055 | 768 | 26 |
191816 | 191816 | 2020-05-30 | Lafayette | Louisiana | 22055 | 763 | 26 |
188752 | 188752 | 2020-05-29 | Lafayette | Louisiana | 22055 | 695 | 26 |
185694 | 185694 | 2020-05-28 | Lafayette | Louisiana | 22055 | 695 | 25 |
182639 | 182639 | 2020-05-27 | Lafayette | Louisiana | 22055 | 689 | 23 |
179594 | 179594 | 2020-05-26 | Lafayette | Louisiana | 22055 | 678 | 23 |
176550 | 176550 | 2020-05-25 | Lafayette | Louisiana | 22055 | 674 | 23 |
173506 | 173506 | 2020-05-24 | Lafayette | Louisiana | 22055 | 659 | 23 |
170465 | 170465 | 2020-05-23 | Lafayette | Louisiana | 22055 | 659 | 23 |
167427 | 167427 | 2020-05-22 | Lafayette | Louisiana | 22055 | 637 | 23 |
164391 | 164391 | 2020-05-21 | Lafayette | Louisiana | 22055 | 631 | 23 |
161362 | 161362 | 2020-05-20 | Lafayette | Louisiana | 22055 | 607 | 23 |
158336 | 158336 | 2020-05-19 | Lafayette | Louisiana | 22055 | 605 | 23 |
155318 | 155318 | 2020-05-18 | Lafayette | Louisiana | 22055 | 598 | 23 |
152304 | 152304 | 2020-05-17 | Lafayette | Louisiana | 22055 | 590 | 23 |
149293 | 149293 | 2020-05-16 | Lafayette | Louisiana | 22055 | 578 | 23 |
146288 | 146288 | 2020-05-15 | Lafayette | Louisiana | 22055 | 543 | 23 |
143288 | 143288 | 2020-05-14 | Lafayette | Louisiana | 22055 | 541 | 23 |
140293 | 140293 | 2020-05-13 | Lafayette | Louisiana | 22055 | 537 | 22 |
137299 | 137299 | 2020-05-12 | Lafayette | Louisiana | 22055 | 512 | 22 |
134309 | 134309 | 2020-05-11 | Lafayette | Louisiana | 22055 | 508 | 22 |
131318 | 131318 | 2020-05-10 | Lafayette | Louisiana | 22055 | 501 | 22 |
128328 | 128328 | 2020-05-09 | Lafayette | Louisiana | 22055 | 498 | 22 |
125341 | 125341 | 2020-05-08 | Lafayette | Louisiana | 22055 | 481 | 21 |
122359 | 122359 | 2020-05-07 | Lafayette | Louisiana | 22055 | 479 | 21 |
119388 | 119388 | 2020-05-06 | Lafayette | Louisiana | 22055 | 477 | 21 |
116427 | 116427 | 2020-05-05 | Lafayette | Louisiana | 22055 | 473 | 20 |
113545 | 113545 | 2020-05-04 | Lafayette | Louisiana | 22055 | 468 | 20 |
110668 | 110668 | 2020-05-03 | Lafayette | Louisiana | 22055 | 466 | 20 |
107796 | 107796 | 2020-05-02 | Lafayette | Louisiana | 22055 | 464 | 20 |
104932 | 104932 | 2020-05-01 | Lafayette | Louisiana | 22055 | 463 | 20 |
102071 | 102071 | 2020-04-30 | Lafayette | Louisiana | 22055 | 455 | 20 |
99219 | 99219 | 2020-04-29 | Lafayette | Louisiana | 22055 | 451 | 20 |
96373 | 96373 | 2020-04-28 | Lafayette | Louisiana | 22055 | 446 | 21 |
93538 | 93538 | 2020-04-27 | Lafayette | Louisiana | 22055 | 443 | 18 |
90717 | 90717 | 2020-04-26 | Lafayette | Louisiana | 22055 | 443 | 17 |
87901 | 87901 | 2020-04-25 | Lafayette | Louisiana | 22055 | 442 | 17 |
85092 | 85092 | 2020-04-24 | Lafayette | Louisiana | 22055 | 440 | 17 |
82288 | 82288 | 2020-04-23 | Lafayette | Louisiana | 22055 | 439 | 17 |
79492 | 79492 | 2020-04-22 | Lafayette | Louisiana | 22055 | 435 | 17 |
76706 | 76706 | 2020-04-21 | Lafayette | Louisiana | 22055 | 429 | 17 |
73926 | 73926 | 2020-04-20 | Lafayette | Louisiana | 22055 | 423 | 17 |
71154 | 71154 | 2020-04-19 | Lafayette | Louisiana | 22055 | 419 | 17 |
68391 | 68391 | 2020-04-18 | Lafayette | Louisiana | 22055 | 414 | 17 |
65642 | 65642 | 2020-04-17 | Lafayette | Louisiana | 22055 | 396 | 17 |
62903 | 62903 | 2020-04-16 | Lafayette | Louisiana | 22055 | 387 | 16 |
60182 | 60182 | 2020-04-15 | Lafayette | Louisiana | 22055 | 375 | 16 |
57474 | 57474 | 2020-04-14 | Lafayette | Louisiana | 22055 | 363 | 15 |
54776 | 54776 | 2020-04-13 | Lafayette | Louisiana | 22055 | 360 | 14 |
52095 | 52095 | 2020-04-12 | Lafayette | Louisiana | 22055 | 354 | 13 |
49425 | 49425 | 2020-04-11 | Lafayette | Louisiana | 22055 | 337 | 12 |
46784 | 46784 | 2020-04-10 | Lafayette | Louisiana | 22055 | 330 | 12 |
44176 | 44176 | 2020-04-09 | Lafayette | Louisiana | 22055 | 303 | 11 |
41600 | 41600 | 2020-04-08 | Lafayette | Louisiana | 22055 | 285 | 10 |
39048 | 39048 | 2020-04-07 | Lafayette | Louisiana | 22055 | 272 | 7 |
36540 | 36540 | 2020-04-06 | Lafayette | Louisiana | 22055 | 260 | 6 |
34082 | 34082 | 2020-04-05 | Lafayette | Louisiana | 22055 | 247 | 5 |
31657 | 31657 | 2020-04-04 | Lafayette | Louisiana | 22055 | 229 | 4 |
29279 | 29279 | 2020-04-03 | Lafayette | Louisiana | 22055 | 276 | 2 |
26962 | 26962 | 2020-04-02 | Lafayette | Louisiana | 22055 | 247 | 2 |
24711 | 24711 | 2020-04-01 | Lafayette | Louisiana | 22055 | 159 | 2 |
22535 | 22535 | 2020-03-31 | Lafayette | Louisiana | 22055 | 118 | 1 |
20427 | 20427 | 2020-03-30 | Lafayette | Louisiana | 22055 | 82 | 1 |
18411 | 18411 | 2020-03-29 | Lafayette | Louisiana | 22055 | 50 | 1 |
16499 | 16499 | 2020-03-28 | Lafayette | Louisiana | 22055 | 48 | 1 |
14679 | 14679 | 2020-03-27 | Lafayette | Louisiana | 22055 | 44 | 0 |
12972 | 12972 | 2020-03-26 | Lafayette | Louisiana | 22055 | 30 | 0 |
11395 | 11395 | 2020-03-25 | Lafayette | Louisiana | 22055 | 20 | 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);