ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "King George" and state = "Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
13888 | 13888 | 2020-03-26 | King George | Virginia | 51099 | 1 | 0 |
15656 | 15656 | 2020-03-27 | King George | Virginia | 51099 | 1 | 0 |
17531 | 17531 | 2020-03-28 | King George | Virginia | 51099 | 2 | 0 |
19492 | 19492 | 2020-03-29 | King George | Virginia | 51099 | 2 | 0 |
21556 | 21556 | 2020-03-30 | King George | Virginia | 51099 | 3 | 0 |
23701 | 23701 | 2020-03-31 | King George | Virginia | 51099 | 3 | 0 |
25917 | 25917 | 2020-04-01 | King George | Virginia | 51099 | 4 | 0 |
28207 | 28207 | 2020-04-02 | King George | Virginia | 51099 | 4 | 0 |
30553 | 30553 | 2020-04-03 | King George | Virginia | 51099 | 6 | 0 |
32952 | 32952 | 2020-04-04 | King George | Virginia | 51099 | 8 | 0 |
35390 | 35390 | 2020-04-05 | King George | Virginia | 51099 | 8 | 0 |
37873 | 37873 | 2020-04-06 | King George | Virginia | 51099 | 10 | 0 |
40406 | 40406 | 2020-04-07 | King George | Virginia | 51099 | 10 | 0 |
42975 | 42975 | 2020-04-08 | King George | Virginia | 51099 | 11 | 0 |
45570 | 45570 | 2020-04-09 | King George | Virginia | 51099 | 13 | 0 |
48196 | 48196 | 2020-04-10 | King George | Virginia | 51099 | 14 | 0 |
50854 | 50854 | 2020-04-11 | King George | Virginia | 51099 | 13 | 0 |
53529 | 53529 | 2020-04-12 | King George | Virginia | 51099 | 14 | 0 |
56219 | 56219 | 2020-04-13 | King George | Virginia | 51099 | 14 | 0 |
58925 | 58925 | 2020-04-14 | King George | Virginia | 51099 | 16 | 0 |
61644 | 61644 | 2020-04-15 | King George | Virginia | 51099 | 17 | 0 |
64377 | 64377 | 2020-04-16 | King George | Virginia | 51099 | 18 | 0 |
67125 | 67125 | 2020-04-17 | King George | Virginia | 51099 | 18 | 0 |
69887 | 69887 | 2020-04-18 | King George | Virginia | 51099 | 18 | 0 |
72657 | 72657 | 2020-04-19 | King George | Virginia | 51099 | 18 | 0 |
75433 | 75433 | 2020-04-20 | King George | Virginia | 51099 | 18 | 0 |
78215 | 78215 | 2020-04-21 | King George | Virginia | 51099 | 19 | 2 |
81008 | 81008 | 2020-04-22 | King George | Virginia | 51099 | 20 | 4 |
83809 | 83809 | 2020-04-23 | King George | Virginia | 51099 | 21 | 4 |
86616 | 86616 | 2020-04-24 | King George | Virginia | 51099 | 23 | 4 |
89431 | 89431 | 2020-04-25 | King George | Virginia | 51099 | 25 | 4 |
92248 | 92248 | 2020-04-26 | King George | Virginia | 51099 | 27 | 4 |
95077 | 95077 | 2020-04-27 | King George | Virginia | 51099 | 28 | 4 |
97920 | 97920 | 2020-04-28 | King George | Virginia | 51099 | 30 | 4 |
100770 | 100770 | 2020-04-29 | King George | Virginia | 51099 | 30 | 4 |
103625 | 103625 | 2020-04-30 | King George | Virginia | 51099 | 32 | 4 |
106489 | 106489 | 2020-05-01 | King George | Virginia | 51099 | 34 | 4 |
109358 | 109358 | 2020-05-02 | King George | Virginia | 51099 | 33 | 4 |
112232 | 112232 | 2020-05-03 | King George | Virginia | 51099 | 35 | 4 |
115115 | 115115 | 2020-05-04 | King George | Virginia | 51099 | 35 | 4 |
118074 | 118074 | 2020-05-05 | King George | Virginia | 51099 | 36 | 4 |
121038 | 121038 | 2020-05-06 | King George | Virginia | 51099 | 36 | 4 |
124019 | 124019 | 2020-05-07 | King George | Virginia | 51099 | 38 | 4 |
127004 | 127004 | 2020-05-08 | King George | Virginia | 51099 | 38 | 4 |
129994 | 129994 | 2020-05-09 | King George | Virginia | 51099 | 38 | 4 |
132984 | 132984 | 2020-05-10 | King George | Virginia | 51099 | 41 | 4 |
135974 | 135974 | 2020-05-11 | King George | Virginia | 51099 | 42 | 4 |
138965 | 138965 | 2020-05-12 | King George | Virginia | 51099 | 44 | 4 |
141961 | 141961 | 2020-05-13 | King George | Virginia | 51099 | 44 | 4 |
144958 | 144958 | 2020-05-14 | King George | Virginia | 51099 | 44 | 4 |
147961 | 147961 | 2020-05-15 | King George | Virginia | 51099 | 45 | 4 |
150970 | 150970 | 2020-05-16 | King George | Virginia | 51099 | 47 | 4 |
153981 | 153981 | 2020-05-17 | King George | Virginia | 51099 | 48 | 4 |
156998 | 156998 | 2020-05-18 | King George | Virginia | 51099 | 48 | 4 |
160022 | 160022 | 2020-05-19 | King George | Virginia | 51099 | 48 | 4 |
163050 | 163050 | 2020-05-20 | King George | Virginia | 51099 | 48 | 4 |
166079 | 166079 | 2020-05-21 | King George | Virginia | 51099 | 49 | 4 |
169115 | 169115 | 2020-05-22 | King George | Virginia | 51099 | 50 | 4 |
172156 | 172156 | 2020-05-23 | King George | Virginia | 51099 | 52 | 4 |
175199 | 175199 | 2020-05-24 | King George | Virginia | 51099 | 54 | 4 |
178244 | 178244 | 2020-05-25 | King George | Virginia | 51099 | 56 | 4 |
181288 | 181288 | 2020-05-26 | King George | Virginia | 51099 | 60 | 4 |
184339 | 184339 | 2020-05-27 | King George | Virginia | 51099 | 60 | 4 |
187396 | 187396 | 2020-05-28 | King George | Virginia | 51099 | 62 | 4 |
190460 | 190460 | 2020-05-29 | King George | Virginia | 51099 | 62 | 4 |
193526 | 193526 | 2020-05-30 | King George | Virginia | 51099 | 65 | 4 |
196596 | 196596 | 2020-05-31 | King George | Virginia | 51099 | 68 | 4 |
199669 | 199669 | 2020-06-01 | King George | Virginia | 51099 | 69 | 4 |
202745 | 202745 | 2020-06-02 | King George | Virginia | 51099 | 70 | 4 |
205824 | 205824 | 2020-06-03 | King George | Virginia | 51099 | 70 | 4 |
208906 | 208906 | 2020-06-04 | King George | Virginia | 51099 | 72 | 4 |
211991 | 211991 | 2020-06-05 | King George | Virginia | 51099 | 72 | 4 |
215078 | 215078 | 2020-06-06 | King George | Virginia | 51099 | 73 | 4 |
218168 | 218168 | 2020-06-07 | King George | Virginia | 51099 | 78 | 4 |
221260 | 221260 | 2020-06-08 | King George | Virginia | 51099 | 78 | 4 |
224356 | 224356 | 2020-06-09 | King George | Virginia | 51099 | 79 | 4 |
227456 | 227456 | 2020-06-10 | King George | Virginia | 51099 | 83 | 4 |
230560 | 230560 | 2020-06-11 | King George | Virginia | 51099 | 83 | 4 |
233665 | 233665 | 2020-06-12 | King George | Virginia | 51099 | 87 | 4 |
236772 | 236772 | 2020-06-13 | King George | Virginia | 51099 | 87 | 4 |
239880 | 239880 | 2020-06-14 | King George | Virginia | 51099 | 88 | 4 |
242991 | 242991 | 2020-06-15 | King George | Virginia | 51099 | 88 | 4 |
246104 | 246104 | 2020-06-16 | King George | Virginia | 51099 | 91 | 4 |
249216 | 249216 | 2020-06-17 | King George | Virginia | 51099 | 93 | 4 |
252331 | 252331 | 2020-06-18 | King George | Virginia | 51099 | 95 | 4 |
255450 | 255450 | 2020-06-19 | King George | Virginia | 51099 | 95 | 4 |
258577 | 258577 | 2020-06-20 | King George | Virginia | 51099 | 96 | 4 |
261704 | 261704 | 2020-06-21 | King George | Virginia | 51099 | 96 | 4 |
264833 | 264833 | 2020-06-22 | King George | Virginia | 51099 | 96 | 4 |
267962 | 267962 | 2020-06-23 | King George | Virginia | 51099 | 96 | 4 |
271096 | 271096 | 2020-06-24 | King George | Virginia | 51099 | 96 | 4 |
274236 | 274236 | 2020-06-25 | King George | Virginia | 51099 | 96 | 4 |
277384 | 277384 | 2020-06-26 | King George | Virginia | 51099 | 98 | 4 |
280532 | 280532 | 2020-06-27 | King George | Virginia | 51099 | 97 | 4 |
283678 | 283678 | 2020-06-28 | King George | Virginia | 51099 | 97 | 4 |
286824 | 286824 | 2020-06-29 | King George | Virginia | 51099 | 97 | 4 |
289974 | 289974 | 2020-06-30 | King George | Virginia | 51099 | 97 | 4 |
293127 | 293127 | 2020-07-01 | King George | Virginia | 51099 | 97 | 4 |
296282 | 296282 | 2020-07-02 | King George | Virginia | 51099 | 99 | 4 |
299444 | 299444 | 2020-07-03 | King George | Virginia | 51099 | 99 | 4 |
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);