ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Rockbridge" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9396 | 9396 | 2020-03-23 | Rockbridge | Virginia | 51163 | 1 | 0 |
10744 | 10744 | 2020-03-24 | Rockbridge | Virginia | 51163 | 1 | 0 |
12265 | 12265 | 2020-03-25 | Rockbridge | Virginia | 51163 | 1 | 0 |
13912 | 13912 | 2020-03-26 | Rockbridge | Virginia | 51163 | 1 | 0 |
15681 | 15681 | 2020-03-27 | Rockbridge | Virginia | 51163 | 1 | 0 |
17561 | 17561 | 2020-03-28 | Rockbridge | Virginia | 51163 | 2 | 0 |
19523 | 19523 | 2020-03-29 | Rockbridge | Virginia | 51163 | 2 | 0 |
21589 | 21589 | 2020-03-30 | Rockbridge | Virginia | 51163 | 2 | 0 |
23736 | 23736 | 2020-03-31 | Rockbridge | Virginia | 51163 | 2 | 0 |
25952 | 25952 | 2020-04-01 | Rockbridge | Virginia | 51163 | 2 | 0 |
28242 | 28242 | 2020-04-02 | Rockbridge | Virginia | 51163 | 2 | 0 |
30591 | 30591 | 2020-04-03 | Rockbridge | Virginia | 51163 | 2 | 0 |
32990 | 32990 | 2020-04-04 | Rockbridge | Virginia | 51163 | 3 | 0 |
35428 | 35428 | 2020-04-05 | Rockbridge | Virginia | 51163 | 3 | 0 |
37911 | 37911 | 2020-04-06 | Rockbridge | Virginia | 51163 | 3 | 0 |
40446 | 40446 | 2020-04-07 | Rockbridge | Virginia | 51163 | 3 | 0 |
43015 | 43015 | 2020-04-08 | Rockbridge | Virginia | 51163 | 3 | 0 |
45611 | 45611 | 2020-04-09 | Rockbridge | Virginia | 51163 | 3 | 0 |
48237 | 48237 | 2020-04-10 | Rockbridge | Virginia | 51163 | 3 | 0 |
50895 | 50895 | 2020-04-11 | Rockbridge | Virginia | 51163 | 3 | 0 |
53570 | 53570 | 2020-04-12 | Rockbridge | Virginia | 51163 | 3 | 0 |
56260 | 56260 | 2020-04-13 | Rockbridge | Virginia | 51163 | 3 | 0 |
58966 | 58966 | 2020-04-14 | Rockbridge | Virginia | 51163 | 3 | 0 |
61685 | 61685 | 2020-04-15 | Rockbridge | Virginia | 51163 | 3 | 0 |
64418 | 64418 | 2020-04-16 | Rockbridge | Virginia | 51163 | 3 | 0 |
67166 | 67166 | 2020-04-17 | Rockbridge | Virginia | 51163 | 5 | 0 |
69928 | 69928 | 2020-04-18 | Rockbridge | Virginia | 51163 | 5 | 0 |
72698 | 72698 | 2020-04-19 | Rockbridge | Virginia | 51163 | 5 | 0 |
75474 | 75474 | 2020-04-20 | Rockbridge | Virginia | 51163 | 5 | 0 |
78258 | 78258 | 2020-04-21 | Rockbridge | Virginia | 51163 | 5 | 0 |
81051 | 81051 | 2020-04-22 | Rockbridge | Virginia | 51163 | 5 | 0 |
83852 | 83852 | 2020-04-23 | Rockbridge | Virginia | 51163 | 5 | 0 |
86659 | 86659 | 2020-04-24 | Rockbridge | Virginia | 51163 | 5 | 0 |
89474 | 89474 | 2020-04-25 | Rockbridge | Virginia | 51163 | 5 | 0 |
92291 | 92291 | 2020-04-26 | Rockbridge | Virginia | 51163 | 5 | 0 |
95120 | 95120 | 2020-04-27 | Rockbridge | Virginia | 51163 | 5 | 0 |
97964 | 97964 | 2020-04-28 | Rockbridge | Virginia | 51163 | 5 | 0 |
100814 | 100814 | 2020-04-29 | Rockbridge | Virginia | 51163 | 5 | 0 |
103669 | 103669 | 2020-04-30 | Rockbridge | Virginia | 51163 | 6 | 0 |
106533 | 106533 | 2020-05-01 | Rockbridge | Virginia | 51163 | 7 | 0 |
109402 | 109402 | 2020-05-02 | Rockbridge | Virginia | 51163 | 7 | 0 |
112276 | 112276 | 2020-05-03 | Rockbridge | Virginia | 51163 | 7 | 0 |
115159 | 115159 | 2020-05-04 | Rockbridge | Virginia | 51163 | 7 | 0 |
118118 | 118118 | 2020-05-05 | Rockbridge | Virginia | 51163 | 8 | 0 |
121082 | 121082 | 2020-05-06 | Rockbridge | Virginia | 51163 | 8 | 0 |
124063 | 124063 | 2020-05-07 | Rockbridge | Virginia | 51163 | 8 | 0 |
127048 | 127048 | 2020-05-08 | Rockbridge | Virginia | 51163 | 8 | 0 |
130038 | 130038 | 2020-05-09 | Rockbridge | Virginia | 51163 | 9 | 0 |
133028 | 133028 | 2020-05-10 | Rockbridge | Virginia | 51163 | 9 | 0 |
136018 | 136018 | 2020-05-11 | Rockbridge | Virginia | 51163 | 9 | 0 |
139009 | 139009 | 2020-05-12 | Rockbridge | Virginia | 51163 | 9 | 0 |
142005 | 142005 | 2020-05-13 | Rockbridge | Virginia | 51163 | 11 | 0 |
145002 | 145002 | 2020-05-14 | Rockbridge | Virginia | 51163 | 11 | 0 |
148005 | 148005 | 2020-05-15 | Rockbridge | Virginia | 51163 | 10 | 0 |
151014 | 151014 | 2020-05-16 | Rockbridge | Virginia | 51163 | 11 | 0 |
154025 | 154025 | 2020-05-17 | Rockbridge | Virginia | 51163 | 11 | 0 |
157042 | 157042 | 2020-05-18 | Rockbridge | Virginia | 51163 | 11 | 0 |
160066 | 160066 | 2020-05-19 | Rockbridge | Virginia | 51163 | 13 | 0 |
163094 | 163094 | 2020-05-20 | Rockbridge | Virginia | 51163 | 13 | 0 |
166123 | 166123 | 2020-05-21 | Rockbridge | Virginia | 51163 | 12 | 0 |
169159 | 169159 | 2020-05-22 | Rockbridge | Virginia | 51163 | 13 | 0 |
172200 | 172200 | 2020-05-23 | Rockbridge | Virginia | 51163 | 14 | 0 |
175243 | 175243 | 2020-05-24 | Rockbridge | Virginia | 51163 | 14 | 0 |
178288 | 178288 | 2020-05-25 | Rockbridge | Virginia | 51163 | 16 | 0 |
181332 | 181332 | 2020-05-26 | Rockbridge | Virginia | 51163 | 17 | 0 |
184383 | 184383 | 2020-05-27 | Rockbridge | Virginia | 51163 | 17 | 0 |
187440 | 187440 | 2020-05-28 | Rockbridge | Virginia | 51163 | 16 | 0 |
190504 | 190504 | 2020-05-29 | Rockbridge | Virginia | 51163 | 16 | 0 |
193570 | 193570 | 2020-05-30 | Rockbridge | Virginia | 51163 | 18 | 0 |
196640 | 196640 | 2020-05-31 | Rockbridge | Virginia | 51163 | 18 | 0 |
199713 | 199713 | 2020-06-01 | Rockbridge | Virginia | 51163 | 18 | 0 |
202789 | 202789 | 2020-06-02 | Rockbridge | Virginia | 51163 | 19 | 0 |
205868 | 205868 | 2020-06-03 | Rockbridge | Virginia | 51163 | 19 | 0 |
208950 | 208950 | 2020-06-04 | Rockbridge | Virginia | 51163 | 18 | 0 |
212035 | 212035 | 2020-06-05 | Rockbridge | Virginia | 51163 | 18 | 0 |
215122 | 215122 | 2020-06-06 | Rockbridge | Virginia | 51163 | 18 | 0 |
218212 | 218212 | 2020-06-07 | Rockbridge | Virginia | 51163 | 19 | 0 |
221304 | 221304 | 2020-06-08 | Rockbridge | Virginia | 51163 | 20 | 0 |
224400 | 224400 | 2020-06-09 | Rockbridge | Virginia | 51163 | 19 | 0 |
227500 | 227500 | 2020-06-10 | Rockbridge | Virginia | 51163 | 19 | 0 |
230604 | 230604 | 2020-06-11 | Rockbridge | Virginia | 51163 | 19 | 0 |
233709 | 233709 | 2020-06-12 | Rockbridge | Virginia | 51163 | 19 | 0 |
236816 | 236816 | 2020-06-13 | Rockbridge | Virginia | 51163 | 19 | 0 |
239924 | 239924 | 2020-06-14 | Rockbridge | Virginia | 51163 | 19 | 0 |
243035 | 243035 | 2020-06-15 | Rockbridge | Virginia | 51163 | 19 | 0 |
246148 | 246148 | 2020-06-16 | Rockbridge | Virginia | 51163 | 18 | 0 |
249260 | 249260 | 2020-06-17 | Rockbridge | Virginia | 51163 | 18 | 0 |
252375 | 252375 | 2020-06-18 | Rockbridge | Virginia | 51163 | 18 | 0 |
255494 | 255494 | 2020-06-19 | Rockbridge | Virginia | 51163 | 18 | 0 |
258621 | 258621 | 2020-06-20 | Rockbridge | Virginia | 51163 | 18 | 0 |
261748 | 261748 | 2020-06-21 | Rockbridge | Virginia | 51163 | 18 | 0 |
264877 | 264877 | 2020-06-22 | Rockbridge | Virginia | 51163 | 21 | 0 |
268006 | 268006 | 2020-06-23 | Rockbridge | Virginia | 51163 | 23 | 0 |
271140 | 271140 | 2020-06-24 | Rockbridge | Virginia | 51163 | 24 | 0 |
274280 | 274280 | 2020-06-25 | Rockbridge | Virginia | 51163 | 27 | 0 |
277428 | 277428 | 2020-06-26 | Rockbridge | Virginia | 51163 | 28 | 0 |
280576 | 280576 | 2020-06-27 | Rockbridge | Virginia | 51163 | 29 | 0 |
283722 | 283722 | 2020-06-28 | Rockbridge | Virginia | 51163 | 30 | 0 |
286868 | 286868 | 2020-06-29 | Rockbridge | Virginia | 51163 | 30 | 0 |
290018 | 290018 | 2020-06-30 | Rockbridge | Virginia | 51163 | 30 | 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);