ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,554 rows where county = "Louisa" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8166 | 8166 | 2020-03-22 | Louisa | Virginia | 51109 | 1 | 0 |
9388 | 9388 | 2020-03-23 | Louisa | Virginia | 51109 | 2 | 0 |
10736 | 10736 | 2020-03-24 | Louisa | Virginia | 51109 | 2 | 0 |
12250 | 12250 | 2020-03-25 | Louisa | Virginia | 51109 | 3 | 0 |
13891 | 13891 | 2020-03-26 | Louisa | Virginia | 51109 | 5 | 0 |
15659 | 15659 | 2020-03-27 | Louisa | Virginia | 51109 | 5 | 0 |
17535 | 17535 | 2020-03-28 | Louisa | Virginia | 51109 | 6 | 0 |
19496 | 19496 | 2020-03-29 | Louisa | Virginia | 51109 | 7 | 0 |
21561 | 21561 | 2020-03-30 | Louisa | Virginia | 51109 | 8 | 0 |
23707 | 23707 | 2020-03-31 | Louisa | Virginia | 51109 | 9 | 0 |
25923 | 25923 | 2020-04-01 | Louisa | Virginia | 51109 | 11 | 0 |
28213 | 28213 | 2020-04-02 | Louisa | Virginia | 51109 | 12 | 0 |
30560 | 30560 | 2020-04-03 | Louisa | Virginia | 51109 | 12 | 0 |
32959 | 32959 | 2020-04-04 | Louisa | Virginia | 51109 | 13 | 0 |
35397 | 35397 | 2020-04-05 | Louisa | Virginia | 51109 | 14 | 0 |
37880 | 37880 | 2020-04-06 | Louisa | Virginia | 51109 | 14 | 0 |
40413 | 40413 | 2020-04-07 | Louisa | Virginia | 51109 | 14 | 0 |
42982 | 42982 | 2020-04-08 | Louisa | Virginia | 51109 | 16 | 0 |
45577 | 45577 | 2020-04-09 | Louisa | Virginia | 51109 | 17 | 0 |
48203 | 48203 | 2020-04-10 | Louisa | Virginia | 51109 | 20 | 0 |
50861 | 50861 | 2020-04-11 | Louisa | Virginia | 51109 | 25 | 0 |
53536 | 53536 | 2020-04-12 | Louisa | Virginia | 51109 | 25 | 0 |
56226 | 56226 | 2020-04-13 | Louisa | Virginia | 51109 | 27 | 0 |
58932 | 58932 | 2020-04-14 | Louisa | Virginia | 51109 | 27 | 0 |
61651 | 61651 | 2020-04-15 | Louisa | Virginia | 51109 | 29 | 0 |
64384 | 64384 | 2020-04-16 | Louisa | Virginia | 51109 | 30 | 0 |
67132 | 67132 | 2020-04-17 | Louisa | Virginia | 51109 | 33 | 0 |
69894 | 69894 | 2020-04-18 | Louisa | Virginia | 51109 | 33 | 0 |
72664 | 72664 | 2020-04-19 | Louisa | Virginia | 51109 | 33 | 0 |
75440 | 75440 | 2020-04-20 | Louisa | Virginia | 51109 | 33 | 0 |
78222 | 78222 | 2020-04-21 | Louisa | Virginia | 51109 | 35 | 0 |
81015 | 81015 | 2020-04-22 | Louisa | Virginia | 51109 | 37 | 0 |
83816 | 83816 | 2020-04-23 | Louisa | Virginia | 51109 | 38 | 0 |
86623 | 86623 | 2020-04-24 | Louisa | Virginia | 51109 | 38 | 0 |
89438 | 89438 | 2020-04-25 | Louisa | Virginia | 51109 | 39 | 0 |
92255 | 92255 | 2020-04-26 | Louisa | Virginia | 51109 | 40 | 0 |
95084 | 95084 | 2020-04-27 | Louisa | Virginia | 51109 | 41 | 0 |
97927 | 97927 | 2020-04-28 | Louisa | Virginia | 51109 | 41 | 0 |
100777 | 100777 | 2020-04-29 | Louisa | Virginia | 51109 | 41 | 0 |
103632 | 103632 | 2020-04-30 | Louisa | Virginia | 51109 | 43 | 0 |
106496 | 106496 | 2020-05-01 | Louisa | Virginia | 51109 | 45 | 0 |
109365 | 109365 | 2020-05-02 | Louisa | Virginia | 51109 | 46 | 0 |
112239 | 112239 | 2020-05-03 | Louisa | Virginia | 51109 | 46 | 0 |
115122 | 115122 | 2020-05-04 | Louisa | Virginia | 51109 | 49 | 0 |
118081 | 118081 | 2020-05-05 | Louisa | Virginia | 51109 | 50 | 0 |
121045 | 121045 | 2020-05-06 | Louisa | Virginia | 51109 | 50 | 0 |
124026 | 124026 | 2020-05-07 | Louisa | Virginia | 51109 | 51 | 0 |
127011 | 127011 | 2020-05-08 | Louisa | Virginia | 51109 | 53 | 0 |
130001 | 130001 | 2020-05-09 | Louisa | Virginia | 51109 | 55 | 0 |
132991 | 132991 | 2020-05-10 | Louisa | Virginia | 51109 | 55 | 0 |
135981 | 135981 | 2020-05-11 | Louisa | Virginia | 51109 | 56 | 0 |
138972 | 138972 | 2020-05-12 | Louisa | Virginia | 51109 | 56 | 0 |
141968 | 141968 | 2020-05-13 | Louisa | Virginia | 51109 | 59 | 0 |
144965 | 144965 | 2020-05-14 | Louisa | Virginia | 51109 | 59 | 0 |
147968 | 147968 | 2020-05-15 | Louisa | Virginia | 51109 | 59 | 0 |
150977 | 150977 | 2020-05-16 | Louisa | Virginia | 51109 | 59 | 0 |
153988 | 153988 | 2020-05-17 | Louisa | Virginia | 51109 | 59 | 0 |
157005 | 157005 | 2020-05-18 | Louisa | Virginia | 51109 | 60 | 0 |
160029 | 160029 | 2020-05-19 | Louisa | Virginia | 51109 | 60 | 0 |
163057 | 163057 | 2020-05-20 | Louisa | Virginia | 51109 | 61 | 0 |
166086 | 166086 | 2020-05-21 | Louisa | Virginia | 51109 | 64 | 0 |
169122 | 169122 | 2020-05-22 | Louisa | Virginia | 51109 | 67 | 1 |
172163 | 172163 | 2020-05-23 | Louisa | Virginia | 51109 | 67 | 1 |
175206 | 175206 | 2020-05-24 | Louisa | Virginia | 51109 | 69 | 1 |
178251 | 178251 | 2020-05-25 | Louisa | Virginia | 51109 | 69 | 1 |
181295 | 181295 | 2020-05-26 | Louisa | Virginia | 51109 | 73 | 1 |
184346 | 184346 | 2020-05-27 | Louisa | Virginia | 51109 | 75 | 1 |
187403 | 187403 | 2020-05-28 | Louisa | Virginia | 51109 | 76 | 1 |
190467 | 190467 | 2020-05-29 | Louisa | Virginia | 51109 | 76 | 1 |
193533 | 193533 | 2020-05-30 | Louisa | Virginia | 51109 | 78 | 1 |
196603 | 196603 | 2020-05-31 | Louisa | Virginia | 51109 | 79 | 1 |
199676 | 199676 | 2020-06-01 | Louisa | Virginia | 51109 | 79 | 1 |
202752 | 202752 | 2020-06-02 | Louisa | Virginia | 51109 | 81 | 1 |
205831 | 205831 | 2020-06-03 | Louisa | Virginia | 51109 | 81 | 1 |
208913 | 208913 | 2020-06-04 | Louisa | Virginia | 51109 | 84 | 1 |
211998 | 211998 | 2020-06-05 | Louisa | Virginia | 51109 | 85 | 1 |
215085 | 215085 | 2020-06-06 | Louisa | Virginia | 51109 | 92 | 1 |
218175 | 218175 | 2020-06-07 | Louisa | Virginia | 51109 | 92 | 1 |
221267 | 221267 | 2020-06-08 | Louisa | Virginia | 51109 | 94 | 1 |
224363 | 224363 | 2020-06-09 | Louisa | Virginia | 51109 | 94 | 1 |
227463 | 227463 | 2020-06-10 | Louisa | Virginia | 51109 | 94 | 1 |
230567 | 230567 | 2020-06-11 | Louisa | Virginia | 51109 | 95 | 1 |
233672 | 233672 | 2020-06-12 | Louisa | Virginia | 51109 | 98 | 1 |
236779 | 236779 | 2020-06-13 | Louisa | Virginia | 51109 | 98 | 1 |
239887 | 239887 | 2020-06-14 | Louisa | Virginia | 51109 | 98 | 1 |
242998 | 242998 | 2020-06-15 | Louisa | Virginia | 51109 | 99 | 1 |
246111 | 246111 | 2020-06-16 | Louisa | Virginia | 51109 | 99 | 1 |
249223 | 249223 | 2020-06-17 | Louisa | Virginia | 51109 | 101 | 1 |
252338 | 252338 | 2020-06-18 | Louisa | Virginia | 51109 | 102 | 1 |
255457 | 255457 | 2020-06-19 | Louisa | Virginia | 51109 | 102 | 1 |
258584 | 258584 | 2020-06-20 | Louisa | Virginia | 51109 | 108 | 1 |
261711 | 261711 | 2020-06-21 | Louisa | Virginia | 51109 | 109 | 1 |
264840 | 264840 | 2020-06-22 | Louisa | Virginia | 51109 | 109 | 1 |
267969 | 267969 | 2020-06-23 | Louisa | Virginia | 51109 | 110 | 1 |
271103 | 271103 | 2020-06-24 | Louisa | Virginia | 51109 | 111 | 1 |
274243 | 274243 | 2020-06-25 | Louisa | Virginia | 51109 | 112 | 1 |
277391 | 277391 | 2020-06-26 | Louisa | Virginia | 51109 | 114 | 1 |
280539 | 280539 | 2020-06-27 | Louisa | Virginia | 51109 | 117 | 1 |
283685 | 283685 | 2020-06-28 | Louisa | Virginia | 51109 | 118 | 1 |
286831 | 286831 | 2020-06-29 | Louisa | Virginia | 51109 | 118 | 1 |
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);