ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 22095 and state = "Louisiana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 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
- …
state 1
- Louisiana · 791 ✖
fips 1
- 22095 · 791 ✖
county 1
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2080 | 2080 | 2020-03-14 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
2478 | 2478 | 2020-03-15 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
2924 | 2924 | 2020-03-16 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
3421 | 3421 | 2020-03-17 | St. John the Baptist | Louisiana | 22095 | 1 | 0 |
4001 | 4001 | 2020-03-18 | St. John the Baptist | Louisiana | 22095 | 2 | 0 |
4700 | 4700 | 2020-03-19 | St. John the Baptist | Louisiana | 22095 | 3 | 0 |
5517 | 5517 | 2020-03-20 | St. John the Baptist | Louisiana | 22095 | 6 | 0 |
6471 | 6471 | 2020-03-21 | St. John the Baptist | Louisiana | 22095 | 9 | 0 |
7546 | 7546 | 2020-03-22 | St. John the Baptist | Louisiana | 22095 | 10 | 0 |
8714 | 8714 | 2020-03-23 | St. John the Baptist | Louisiana | 22095 | 16 | 0 |
10002 | 10002 | 2020-03-24 | St. John the Baptist | Louisiana | 22095 | 21 | 0 |
11409 | 11409 | 2020-03-25 | St. John the Baptist | Louisiana | 22095 | 27 | 2 |
12988 | 12988 | 2020-03-26 | St. John the Baptist | Louisiana | 22095 | 38 | 2 |
14695 | 14695 | 2020-03-27 | St. John the Baptist | Louisiana | 22095 | 41 | 3 |
16515 | 16515 | 2020-03-28 | St. John the Baptist | Louisiana | 22095 | 54 | 3 |
18429 | 18429 | 2020-03-29 | St. John the Baptist | Louisiana | 22095 | 57 | 5 |
20445 | 20445 | 2020-03-30 | St. John the Baptist | Louisiana | 22095 | 75 | 8 |
22554 | 22554 | 2020-03-31 | St. John the Baptist | Louisiana | 22095 | 104 | 12 |
24730 | 24730 | 2020-04-01 | St. John the Baptist | Louisiana | 22095 | 118 | 13 |
26981 | 26981 | 2020-04-02 | St. John the Baptist | Louisiana | 22095 | 274 | 14 |
29298 | 29298 | 2020-04-03 | St. John the Baptist | Louisiana | 22095 | 290 | 17 |
31676 | 31676 | 2020-04-04 | St. John the Baptist | Louisiana | 22095 | 338 | 23 |
34101 | 34101 | 2020-04-05 | St. John the Baptist | Louisiana | 22095 | 345 | 24 |
36559 | 36559 | 2020-04-06 | St. John the Baptist | Louisiana | 22095 | 366 | 24 |
39067 | 39067 | 2020-04-07 | St. John the Baptist | Louisiana | 22095 | 415 | 34 |
41619 | 41619 | 2020-04-08 | St. John the Baptist | Louisiana | 22095 | 432 | 35 |
44195 | 44195 | 2020-04-09 | St. John the Baptist | Louisiana | 22095 | 477 | 35 |
46803 | 46803 | 2020-04-10 | St. John the Baptist | Louisiana | 22095 | 507 | 37 |
49444 | 49444 | 2020-04-11 | St. John the Baptist | Louisiana | 22095 | 538 | 38 |
52114 | 52114 | 2020-04-12 | St. John the Baptist | Louisiana | 22095 | 545 | 38 |
54795 | 54795 | 2020-04-13 | St. John the Baptist | Louisiana | 22095 | 556 | 40 |
57493 | 57493 | 2020-04-14 | St. John the Baptist | Louisiana | 22095 | 562 | 48 |
60201 | 60201 | 2020-04-15 | St. John the Baptist | Louisiana | 22095 | 569 | 47 |
62922 | 62922 | 2020-04-16 | St. John the Baptist | Louisiana | 22095 | 609 | 47 |
65661 | 65661 | 2020-04-17 | St. John the Baptist | Louisiana | 22095 | 623 | 50 |
68410 | 68410 | 2020-04-18 | St. John the Baptist | Louisiana | 22095 | 637 | 53 |
71173 | 71173 | 2020-04-19 | St. John the Baptist | Louisiana | 22095 | 642 | 53 |
73945 | 73945 | 2020-04-20 | St. John the Baptist | Louisiana | 22095 | 669 | 53 |
76725 | 76725 | 2020-04-21 | St. John the Baptist | Louisiana | 22095 | 686 | 57 |
79511 | 79511 | 2020-04-22 | St. John the Baptist | Louisiana | 22095 | 704 | 57 |
82307 | 82307 | 2020-04-23 | St. John the Baptist | Louisiana | 22095 | 721 | 59 |
85111 | 85111 | 2020-04-24 | St. John the Baptist | Louisiana | 22095 | 736 | 63 |
87920 | 87920 | 2020-04-25 | St. John the Baptist | Louisiana | 22095 | 747 | 64 |
90736 | 90736 | 2020-04-26 | St. John the Baptist | Louisiana | 22095 | 749 | 64 |
93557 | 93557 | 2020-04-27 | St. John the Baptist | Louisiana | 22095 | 751 | 64 |
96392 | 96392 | 2020-04-28 | St. John the Baptist | Louisiana | 22095 | 758 | 66 |
99238 | 99238 | 2020-04-29 | St. John the Baptist | Louisiana | 22095 | 765 | 68 |
102090 | 102090 | 2020-04-30 | St. John the Baptist | Louisiana | 22095 | 768 | 69 |
104951 | 104951 | 2020-05-01 | St. John the Baptist | Louisiana | 22095 | 771 | 71 |
107815 | 107815 | 2020-05-02 | St. John the Baptist | Louisiana | 22095 | 772 | 71 |
110687 | 110687 | 2020-05-03 | St. John the Baptist | Louisiana | 22095 | 772 | 71 |
113564 | 113564 | 2020-05-04 | St. John the Baptist | Louisiana | 22095 | 777 | 71 |
116446 | 116446 | 2020-05-05 | St. John the Baptist | Louisiana | 22095 | 782 | 75 |
119407 | 119407 | 2020-05-06 | St. John the Baptist | Louisiana | 22095 | 790 | 74 |
122378 | 122378 | 2020-05-07 | St. John the Baptist | Louisiana | 22095 | 791 | 76 |
125360 | 125360 | 2020-05-08 | St. John the Baptist | Louisiana | 22095 | 791 | 76 |
128347 | 128347 | 2020-05-09 | St. John the Baptist | Louisiana | 22095 | 801 | 76 |
131337 | 131337 | 2020-05-10 | St. John the Baptist | Louisiana | 22095 | 801 | 76 |
134328 | 134328 | 2020-05-11 | St. John the Baptist | Louisiana | 22095 | 801 | 77 |
137318 | 137318 | 2020-05-12 | St. John the Baptist | Louisiana | 22095 | 804 | 76 |
140312 | 140312 | 2020-05-13 | St. John the Baptist | Louisiana | 22095 | 808 | 77 |
143307 | 143307 | 2020-05-14 | St. John the Baptist | Louisiana | 22095 | 820 | 78 |
146307 | 146307 | 2020-05-15 | St. John the Baptist | Louisiana | 22095 | 830 | 77 |
149312 | 149312 | 2020-05-16 | St. John the Baptist | Louisiana | 22095 | 829 | 77 |
152323 | 152323 | 2020-05-17 | St. John the Baptist | Louisiana | 22095 | 829 | 77 |
155337 | 155337 | 2020-05-18 | St. John the Baptist | Louisiana | 22095 | 830 | 77 |
158355 | 158355 | 2020-05-19 | St. John the Baptist | Louisiana | 22095 | 831 | 77 |
161381 | 161381 | 2020-05-20 | St. John the Baptist | Louisiana | 22095 | 832 | 77 |
164410 | 164410 | 2020-05-21 | St. John the Baptist | Louisiana | 22095 | 838 | 77 |
167446 | 167446 | 2020-05-22 | St. John the Baptist | Louisiana | 22095 | 838 | 77 |
170484 | 170484 | 2020-05-23 | St. John the Baptist | Louisiana | 22095 | 838 | 77 |
173525 | 173525 | 2020-05-24 | St. John the Baptist | Louisiana | 22095 | 841 | 77 |
176569 | 176569 | 2020-05-25 | St. John the Baptist | Louisiana | 22095 | 845 | 77 |
179613 | 179613 | 2020-05-26 | St. John the Baptist | Louisiana | 22095 | 848 | 77 |
182658 | 182658 | 2020-05-27 | St. John the Baptist | Louisiana | 22095 | 849 | 77 |
185713 | 185713 | 2020-05-28 | St. John the Baptist | Louisiana | 22095 | 850 | 78 |
188771 | 188771 | 2020-05-29 | St. John the Baptist | Louisiana | 22095 | 850 | 79 |
191835 | 191835 | 2020-05-30 | St. John the Baptist | Louisiana | 22095 | 858 | 79 |
194903 | 194903 | 2020-05-31 | St. John the Baptist | Louisiana | 22095 | 860 | 79 |
197974 | 197974 | 2020-06-01 | St. John the Baptist | Louisiana | 22095 | 862 | 79 |
201046 | 201046 | 2020-06-02 | St. John the Baptist | Louisiana | 22095 | 864 | 82 |
204123 | 204123 | 2020-06-03 | St. John the Baptist | Louisiana | 22095 | 868 | 82 |
207204 | 207204 | 2020-06-04 | St. John the Baptist | Louisiana | 22095 | 872 | 82 |
210285 | 210285 | 2020-06-05 | St. John the Baptist | Louisiana | 22095 | 873 | 84 |
213370 | 213370 | 2020-06-06 | St. John the Baptist | Louisiana | 22095 | 875 | 84 |
216457 | 216457 | 2020-06-07 | St. John the Baptist | Louisiana | 22095 | 877 | 84 |
219549 | 219549 | 2020-06-08 | St. John the Baptist | Louisiana | 22095 | 877 | 84 |
222644 | 222644 | 2020-06-09 | St. John the Baptist | Louisiana | 22095 | 881 | 84 |
225740 | 225740 | 2020-06-10 | St. John the Baptist | Louisiana | 22095 | 883 | 83 |
228842 | 228842 | 2020-06-11 | St. John the Baptist | Louisiana | 22095 | 883 | 83 |
231946 | 231946 | 2020-06-12 | St. John the Baptist | Louisiana | 22095 | 886 | 83 |
235051 | 235051 | 2020-06-13 | St. John the Baptist | Louisiana | 22095 | 889 | 83 |
238158 | 238158 | 2020-06-14 | St. John the Baptist | Louisiana | 22095 | 891 | 83 |
241267 | 241267 | 2020-06-15 | St. John the Baptist | Louisiana | 22095 | 892 | 83 |
244378 | 244378 | 2020-06-16 | St. John the Baptist | Louisiana | 22095 | 894 | 83 |
247491 | 247491 | 2020-06-17 | St. John the Baptist | Louisiana | 22095 | 904 | 83 |
250603 | 250603 | 2020-06-18 | St. John the Baptist | Louisiana | 22095 | 904 | 83 |
253718 | 253718 | 2020-06-19 | St. John the Baptist | Louisiana | 22095 | 917 | 85 |
256838 | 256838 | 2020-06-20 | St. John the Baptist | Louisiana | 22095 | 919 | 85 |
259964 | 259964 | 2020-06-21 | St. John the Baptist | Louisiana | 22095 | 924 | 85 |
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);