ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 51510 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388835 | 388835 | 2020-07-31 | Alexandria city | Virginia | 51510 | 2798 | 58 |
385618 | 385618 | 2020-07-30 | Alexandria city | Virginia | 51510 | 2779 | 57 |
382400 | 382400 | 2020-07-29 | Alexandria city | Virginia | 51510 | 2759 | 57 |
379183 | 379183 | 2020-07-28 | Alexandria city | Virginia | 51510 | 2749 | 57 |
375967 | 375967 | 2020-07-27 | Alexandria city | Virginia | 51510 | 2735 | 57 |
372753 | 372753 | 2020-07-26 | Alexandria city | Virginia | 51510 | 2695 | 57 |
369541 | 369541 | 2020-07-25 | Alexandria city | Virginia | 51510 | 2687 | 57 |
366332 | 366332 | 2020-07-24 | Alexandria city | Virginia | 51510 | 2662 | 56 |
363126 | 363126 | 2020-07-23 | Alexandria city | Virginia | 51510 | 2639 | 56 |
359920 | 359920 | 2020-07-22 | Alexandria city | Virginia | 51510 | 2618 | 56 |
356715 | 356715 | 2020-07-21 | Alexandria city | Virginia | 51510 | 2582 | 56 |
353512 | 353512 | 2020-07-20 | Alexandria city | Virginia | 51510 | 2559 | 56 |
350310 | 350310 | 2020-07-19 | Alexandria city | Virginia | 51510 | 2547 | 56 |
347109 | 347109 | 2020-07-18 | Alexandria city | Virginia | 51510 | 2540 | 56 |
343909 | 343909 | 2020-07-17 | Alexandria city | Virginia | 51510 | 2523 | 56 |
340710 | 340710 | 2020-07-16 | Alexandria city | Virginia | 51510 | 2507 | 56 |
337514 | 337514 | 2020-07-15 | Alexandria city | Virginia | 51510 | 2486 | 57 |
334319 | 334319 | 2020-07-14 | Alexandria city | Virginia | 51510 | 2465 | 57 |
331126 | 331126 | 2020-07-13 | Alexandria city | Virginia | 51510 | 2456 | 57 |
327940 | 327940 | 2020-07-12 | Alexandria city | Virginia | 51510 | 2455 | 57 |
324755 | 324755 | 2020-07-11 | Alexandria city | Virginia | 51510 | 2453 | 57 |
321574 | 321574 | 2020-07-10 | Alexandria city | Virginia | 51510 | 2439 | 57 |
318395 | 318395 | 2020-07-09 | Alexandria city | Virginia | 51510 | 2419 | 57 |
315222 | 315222 | 2020-07-08 | Alexandria city | Virginia | 51510 | 2408 | 57 |
312048 | 312048 | 2020-07-07 | Alexandria city | Virginia | 51510 | 2399 | 57 |
308879 | 308879 | 2020-07-06 | Alexandria city | Virginia | 51510 | 2380 | 57 |
305711 | 305711 | 2020-07-05 | Alexandria city | Virginia | 51510 | 2376 | 57 |
302547 | 302547 | 2020-07-04 | Alexandria city | Virginia | 51510 | 2357 | 57 |
299383 | 299383 | 2020-07-03 | Alexandria city | Virginia | 51510 | 2338 | 57 |
296221 | 296221 | 2020-07-02 | Alexandria city | Virginia | 51510 | 2327 | 57 |
293066 | 293066 | 2020-07-01 | Alexandria city | Virginia | 51510 | 2325 | 57 |
289913 | 289913 | 2020-06-30 | Alexandria city | Virginia | 51510 | 2325 | 57 |
286763 | 286763 | 2020-06-29 | Alexandria city | Virginia | 51510 | 2317 | 57 |
283617 | 283617 | 2020-06-28 | Alexandria city | Virginia | 51510 | 2312 | 57 |
280471 | 280471 | 2020-06-27 | Alexandria city | Virginia | 51510 | 2303 | 57 |
277323 | 277323 | 2020-06-26 | Alexandria city | Virginia | 51510 | 2287 | 56 |
274175 | 274175 | 2020-06-25 | Alexandria city | Virginia | 51510 | 2271 | 50 |
271035 | 271035 | 2020-06-24 | Alexandria city | Virginia | 51510 | 2258 | 50 |
267901 | 267901 | 2020-06-23 | Alexandria city | Virginia | 51510 | 2248 | 49 |
264772 | 264772 | 2020-06-22 | Alexandria city | Virginia | 51510 | 2236 | 49 |
261643 | 261643 | 2020-06-21 | Alexandria city | Virginia | 51510 | 2227 | 49 |
258516 | 258516 | 2020-06-20 | Alexandria city | Virginia | 51510 | 2217 | 49 |
255389 | 255389 | 2020-06-19 | Alexandria city | Virginia | 51510 | 2198 | 48 |
252271 | 252271 | 2020-06-18 | Alexandria city | Virginia | 51510 | 2186 | 48 |
249156 | 249156 | 2020-06-17 | Alexandria city | Virginia | 51510 | 2175 | 48 |
246044 | 246044 | 2020-06-16 | Alexandria city | Virginia | 51510 | 2168 | 47 |
242932 | 242932 | 2020-06-15 | Alexandria city | Virginia | 51510 | 2160 | 48 |
239821 | 239821 | 2020-06-14 | Alexandria city | Virginia | 51510 | 2151 | 48 |
236713 | 236713 | 2020-06-13 | Alexandria city | Virginia | 51510 | 2134 | 48 |
233606 | 233606 | 2020-06-12 | Alexandria city | Virginia | 51510 | 2128 | 48 |
230501 | 230501 | 2020-06-11 | Alexandria city | Virginia | 51510 | 2127 | 48 |
227397 | 227397 | 2020-06-10 | Alexandria city | Virginia | 51510 | 2125 | 47 |
224297 | 224297 | 2020-06-09 | Alexandria city | Virginia | 51510 | 2115 | 47 |
221201 | 221201 | 2020-06-08 | Alexandria city | Virginia | 51510 | 2102 | 45 |
218109 | 218109 | 2020-06-07 | Alexandria city | Virginia | 51510 | 2095 | 45 |
215019 | 215019 | 2020-06-06 | Alexandria city | Virginia | 51510 | 2070 | 45 |
211932 | 211932 | 2020-06-05 | Alexandria city | Virginia | 51510 | 2045 | 45 |
208847 | 208847 | 2020-06-04 | Alexandria city | Virginia | 51510 | 2031 | 46 |
205765 | 205765 | 2020-06-03 | Alexandria city | Virginia | 51510 | 2016 | 46 |
202686 | 202686 | 2020-06-02 | Alexandria city | Virginia | 51510 | 2000 | 44 |
199610 | 199610 | 2020-06-01 | Alexandria city | Virginia | 51510 | 1981 | 45 |
196537 | 196537 | 2020-05-31 | Alexandria city | Virginia | 51510 | 1974 | 44 |
193467 | 193467 | 2020-05-30 | Alexandria city | Virginia | 51510 | 1960 | 44 |
190401 | 190401 | 2020-05-29 | Alexandria city | Virginia | 51510 | 1941 | 44 |
187337 | 187337 | 2020-05-28 | Alexandria city | Virginia | 51510 | 1887 | 44 |
184280 | 184280 | 2020-05-27 | Alexandria city | Virginia | 51510 | 1824 | 42 |
181229 | 181229 | 2020-05-26 | Alexandria city | Virginia | 51510 | 1785 | 41 |
178185 | 178185 | 2020-05-25 | Alexandria city | Virginia | 51510 | 1754 | 38 |
175140 | 175140 | 2020-05-24 | Alexandria city | Virginia | 51510 | 1733 | 38 |
172097 | 172097 | 2020-05-23 | Alexandria city | Virginia | 51510 | 1703 | 38 |
169056 | 169056 | 2020-05-22 | Alexandria city | Virginia | 51510 | 1657 | 37 |
166020 | 166020 | 2020-05-21 | Alexandria city | Virginia | 51510 | 1627 | 37 |
162991 | 162991 | 2020-05-20 | Alexandria city | Virginia | 51510 | 1577 | 34 |
159963 | 159963 | 2020-05-19 | Alexandria city | Virginia | 51510 | 1544 | 34 |
156939 | 156939 | 2020-05-18 | Alexandria city | Virginia | 51510 | 1510 | 34 |
153922 | 153922 | 2020-05-17 | Alexandria city | Virginia | 51510 | 1476 | 34 |
150911 | 150911 | 2020-05-16 | Alexandria city | Virginia | 51510 | 1460 | 34 |
147902 | 147902 | 2020-05-15 | Alexandria city | Virginia | 51510 | 1396 | 32 |
144899 | 144899 | 2020-05-14 | Alexandria city | Virginia | 51510 | 1349 | 32 |
141902 | 141902 | 2020-05-13 | Alexandria city | Virginia | 51510 | 1305 | 31 |
138906 | 138906 | 2020-05-12 | Alexandria city | Virginia | 51510 | 1240 | 30 |
135915 | 135915 | 2020-05-11 | Alexandria city | Virginia | 51510 | 1224 | 30 |
132925 | 132925 | 2020-05-10 | Alexandria city | Virginia | 51510 | 1193 | 30 |
129935 | 129935 | 2020-05-09 | Alexandria city | Virginia | 51510 | 1142 | 30 |
126946 | 126946 | 2020-05-08 | Alexandria city | Virginia | 51510 | 1110 | 29 |
123961 | 123961 | 2020-05-07 | Alexandria city | Virginia | 51510 | 1060 | 29 |
120980 | 120980 | 2020-05-06 | Alexandria city | Virginia | 51510 | 983 | 26 |
118016 | 118016 | 2020-05-05 | Alexandria city | Virginia | 51510 | 983 | 26 |
115057 | 115057 | 2020-05-04 | Alexandria city | Virginia | 51510 | 940 | 26 |
112174 | 112174 | 2020-05-03 | Alexandria city | Virginia | 51510 | 899 | 26 |
109300 | 109300 | 2020-05-02 | Alexandria city | Virginia | 51510 | 848 | 26 |
106431 | 106431 | 2020-05-01 | Alexandria city | Virginia | 51510 | 802 | 24 |
103567 | 103567 | 2020-04-30 | Alexandria city | Virginia | 51510 | 754 | 21 |
100712 | 100712 | 2020-04-29 | Alexandria city | Virginia | 51510 | 700 | 21 |
97862 | 97862 | 2020-04-28 | Alexandria city | Virginia | 51510 | 653 | 20 |
95020 | 95020 | 2020-04-27 | Alexandria city | Virginia | 51510 | 627 | 18 |
92191 | 92191 | 2020-04-26 | Alexandria city | Virginia | 51510 | 591 | 19 |
89374 | 89374 | 2020-04-25 | Alexandria city | Virginia | 51510 | 575 | 18 |
86559 | 86559 | 2020-04-24 | Alexandria city | Virginia | 51510 | 547 | 15 |
83752 | 83752 | 2020-04-23 | Alexandria city | Virginia | 51510 | 512 | 14 |
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);