ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Washington" and state = "Louisiana" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- …
state 1
- Louisiana · 788 ✖
fips 1
- 22117 788
county 1
- Washington · 788 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3424 | 3424 | 2020-03-17 | Washington | Louisiana | 22117 | 1 | 0 |
4005 | 4005 | 2020-03-18 | Washington | Louisiana | 22117 | 1 | 0 |
4705 | 4705 | 2020-03-19 | Washington | Louisiana | 22117 | 2 | 0 |
5523 | 5523 | 2020-03-20 | Washington | Louisiana | 22117 | 2 | 0 |
6478 | 6478 | 2020-03-21 | Washington | Louisiana | 22117 | 2 | 0 |
7553 | 7553 | 2020-03-22 | Washington | Louisiana | 22117 | 2 | 0 |
8722 | 8722 | 2020-03-23 | Washington | Louisiana | 22117 | 2 | 1 |
10011 | 10011 | 2020-03-24 | Washington | Louisiana | 22117 | 3 | 1 |
11419 | 11419 | 2020-03-25 | Washington | Louisiana | 22117 | 4 | 1 |
12999 | 12999 | 2020-03-26 | Washington | Louisiana | 22117 | 6 | 1 |
14706 | 14706 | 2020-03-27 | Washington | Louisiana | 22117 | 8 | 1 |
16526 | 16526 | 2020-03-28 | Washington | Louisiana | 22117 | 10 | 1 |
18440 | 18440 | 2020-03-29 | Washington | Louisiana | 22117 | 12 | 1 |
20456 | 20456 | 2020-03-30 | Washington | Louisiana | 22117 | 22 | 1 |
22565 | 22565 | 2020-03-31 | Washington | Louisiana | 22117 | 28 | 1 |
24741 | 24741 | 2020-04-01 | Washington | Louisiana | 22117 | 39 | 2 |
26992 | 26992 | 2020-04-02 | Washington | Louisiana | 22117 | 50 | 2 |
29309 | 29309 | 2020-04-03 | Washington | Louisiana | 22117 | 57 | 2 |
31687 | 31687 | 2020-04-04 | Washington | Louisiana | 22117 | 75 | 2 |
34112 | 34112 | 2020-04-05 | Washington | Louisiana | 22117 | 81 | 2 |
36570 | 36570 | 2020-04-06 | Washington | Louisiana | 22117 | 92 | 2 |
39078 | 39078 | 2020-04-07 | Washington | Louisiana | 22117 | 100 | 2 |
41630 | 41630 | 2020-04-08 | Washington | Louisiana | 22117 | 106 | 5 |
44206 | 44206 | 2020-04-09 | Washington | Louisiana | 22117 | 119 | 8 |
46814 | 46814 | 2020-04-10 | Washington | Louisiana | 22117 | 136 | 7 |
49456 | 49456 | 2020-04-11 | Washington | Louisiana | 22117 | 142 | 7 |
52126 | 52126 | 2020-04-12 | Washington | Louisiana | 22117 | 147 | 7 |
54807 | 54807 | 2020-04-13 | Washington | Louisiana | 22117 | 156 | 8 |
57505 | 57505 | 2020-04-14 | Washington | Louisiana | 22117 | 162 | 9 |
60213 | 60213 | 2020-04-15 | Washington | Louisiana | 22117 | 173 | 10 |
62934 | 62934 | 2020-04-16 | Washington | Louisiana | 22117 | 179 | 10 |
65673 | 65673 | 2020-04-17 | Washington | Louisiana | 22117 | 184 | 11 |
68422 | 68422 | 2020-04-18 | Washington | Louisiana | 22117 | 188 | 11 |
71185 | 71185 | 2020-04-19 | Washington | Louisiana | 22117 | 191 | 11 |
73957 | 73957 | 2020-04-20 | Washington | Louisiana | 22117 | 195 | 11 |
76737 | 76737 | 2020-04-21 | Washington | Louisiana | 22117 | 206 | 13 |
79523 | 79523 | 2020-04-22 | Washington | Louisiana | 22117 | 214 | 13 |
82319 | 82319 | 2020-04-23 | Washington | Louisiana | 22117 | 225 | 13 |
85123 | 85123 | 2020-04-24 | Washington | Louisiana | 22117 | 232 | 14 |
87932 | 87932 | 2020-04-25 | Washington | Louisiana | 22117 | 241 | 14 |
90748 | 90748 | 2020-04-26 | Washington | Louisiana | 22117 | 245 | 14 |
93569 | 93569 | 2020-04-27 | Washington | Louisiana | 22117 | 253 | 18 |
96404 | 96404 | 2020-04-28 | Washington | Louisiana | 22117 | 256 | 18 |
99250 | 99250 | 2020-04-29 | Washington | Louisiana | 22117 | 261 | 18 |
102102 | 102102 | 2020-04-30 | Washington | Louisiana | 22117 | 262 | 18 |
104963 | 104963 | 2020-05-01 | Washington | Louisiana | 22117 | 273 | 21 |
107827 | 107827 | 2020-05-02 | Washington | Louisiana | 22117 | 282 | 21 |
110699 | 110699 | 2020-05-03 | Washington | Louisiana | 22117 | 285 | 21 |
113576 | 113576 | 2020-05-04 | Washington | Louisiana | 22117 | 291 | 21 |
116458 | 116458 | 2020-05-05 | Washington | Louisiana | 22117 | 292 | 23 |
119419 | 119419 | 2020-05-06 | Washington | Louisiana | 22117 | 298 | 24 |
122390 | 122390 | 2020-05-07 | Washington | Louisiana | 22117 | 308 | 24 |
125372 | 125372 | 2020-05-08 | Washington | Louisiana | 22117 | 312 | 24 |
128359 | 128359 | 2020-05-09 | Washington | Louisiana | 22117 | 335 | 26 |
131349 | 131349 | 2020-05-10 | Washington | Louisiana | 22117 | 337 | 26 |
134340 | 134340 | 2020-05-11 | Washington | Louisiana | 22117 | 342 | 26 |
137330 | 137330 | 2020-05-12 | Washington | Louisiana | 22117 | 347 | 26 |
140324 | 140324 | 2020-05-13 | Washington | Louisiana | 22117 | 350 | 29 |
143319 | 143319 | 2020-05-14 | Washington | Louisiana | 22117 | 356 | 29 |
146319 | 146319 | 2020-05-15 | Washington | Louisiana | 22117 | 357 | 31 |
149324 | 149324 | 2020-05-16 | Washington | Louisiana | 22117 | 363 | 32 |
152335 | 152335 | 2020-05-17 | Washington | Louisiana | 22117 | 365 | 32 |
155349 | 155349 | 2020-05-18 | Washington | Louisiana | 22117 | 370 | 32 |
158367 | 158367 | 2020-05-19 | Washington | Louisiana | 22117 | 375 | 34 |
161393 | 161393 | 2020-05-20 | Washington | Louisiana | 22117 | 376 | 36 |
164422 | 164422 | 2020-05-21 | Washington | Louisiana | 22117 | 383 | 36 |
167458 | 167458 | 2020-05-22 | Washington | Louisiana | 22117 | 389 | 37 |
170496 | 170496 | 2020-05-23 | Washington | Louisiana | 22117 | 389 | 37 |
173537 | 173537 | 2020-05-24 | Washington | Louisiana | 22117 | 389 | 37 |
176581 | 176581 | 2020-05-25 | Washington | Louisiana | 22117 | 398 | 37 |
179625 | 179625 | 2020-05-26 | Washington | Louisiana | 22117 | 400 | 37 |
182670 | 182670 | 2020-05-27 | Washington | Louisiana | 22117 | 407 | 37 |
185725 | 185725 | 2020-05-28 | Washington | Louisiana | 22117 | 410 | 38 |
188783 | 188783 | 2020-05-29 | Washington | Louisiana | 22117 | 410 | 38 |
191847 | 191847 | 2020-05-30 | Washington | Louisiana | 22117 | 419 | 38 |
194915 | 194915 | 2020-05-31 | Washington | Louisiana | 22117 | 425 | 38 |
197986 | 197986 | 2020-06-01 | Washington | Louisiana | 22117 | 433 | 38 |
201058 | 201058 | 2020-06-02 | Washington | Louisiana | 22117 | 437 | 38 |
204135 | 204135 | 2020-06-03 | Washington | Louisiana | 22117 | 444 | 39 |
207216 | 207216 | 2020-06-04 | Washington | Louisiana | 22117 | 451 | 41 |
210297 | 210297 | 2020-06-05 | Washington | Louisiana | 22117 | 457 | 42 |
213382 | 213382 | 2020-06-06 | Washington | Louisiana | 22117 | 462 | 42 |
216469 | 216469 | 2020-06-07 | Washington | Louisiana | 22117 | 465 | 42 |
219561 | 219561 | 2020-06-08 | Washington | Louisiana | 22117 | 478 | 42 |
222656 | 222656 | 2020-06-09 | Washington | Louisiana | 22117 | 489 | 42 |
225752 | 225752 | 2020-06-10 | Washington | Louisiana | 22117 | 500 | 42 |
228854 | 228854 | 2020-06-11 | Washington | Louisiana | 22117 | 509 | 43 |
231958 | 231958 | 2020-06-12 | Washington | Louisiana | 22117 | 520 | 43 |
235063 | 235063 | 2020-06-13 | Washington | Louisiana | 22117 | 528 | 43 |
238170 | 238170 | 2020-06-14 | Washington | Louisiana | 22117 | 532 | 43 |
241279 | 241279 | 2020-06-15 | Washington | Louisiana | 22117 | 546 | 43 |
244390 | 244390 | 2020-06-16 | Washington | Louisiana | 22117 | 556 | 43 |
247503 | 247503 | 2020-06-17 | Washington | Louisiana | 22117 | 560 | 43 |
250615 | 250615 | 2020-06-18 | Washington | Louisiana | 22117 | 560 | 43 |
253730 | 253730 | 2020-06-19 | Washington | Louisiana | 22117 | 570 | 43 |
256850 | 256850 | 2020-06-20 | Washington | Louisiana | 22117 | 579 | 44 |
259976 | 259976 | 2020-06-21 | Washington | Louisiana | 22117 | 581 | 44 |
263105 | 263105 | 2020-06-22 | Washington | Louisiana | 22117 | 585 | 44 |
266232 | 266232 | 2020-06-23 | Washington | Louisiana | 22117 | 596 | 45 |
269365 | 269365 | 2020-06-24 | Washington | Louisiana | 22117 | 607 | 45 |
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);