ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 51013 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388840 | 388840 | 2020-07-31 | Arlington | Virginia | 51013 | 2897 | 136 |
385623 | 385623 | 2020-07-30 | Arlington | Virginia | 51013 | 2874 | 135 |
382405 | 382405 | 2020-07-29 | Arlington | Virginia | 51013 | 2857 | 135 |
379188 | 379188 | 2020-07-28 | Arlington | Virginia | 51013 | 2843 | 135 |
375972 | 375972 | 2020-07-27 | Arlington | Virginia | 51013 | 2823 | 135 |
372758 | 372758 | 2020-07-26 | Arlington | Virginia | 51013 | 2807 | 135 |
369546 | 369546 | 2020-07-25 | Arlington | Virginia | 51013 | 2801 | 135 |
366337 | 366337 | 2020-07-24 | Arlington | Virginia | 51013 | 2783 | 135 |
363131 | 363131 | 2020-07-23 | Arlington | Virginia | 51013 | 2776 | 135 |
359925 | 359925 | 2020-07-22 | Arlington | Virginia | 51013 | 2763 | 135 |
356720 | 356720 | 2020-07-21 | Arlington | Virginia | 51013 | 2750 | 135 |
353517 | 353517 | 2020-07-20 | Arlington | Virginia | 51013 | 2737 | 135 |
350315 | 350315 | 2020-07-19 | Arlington | Virginia | 51013 | 2733 | 135 |
347114 | 347114 | 2020-07-18 | Arlington | Virginia | 51013 | 2726 | 135 |
343914 | 343914 | 2020-07-17 | Arlington | Virginia | 51013 | 2704 | 135 |
340715 | 340715 | 2020-07-16 | Arlington | Virginia | 51013 | 2691 | 134 |
337519 | 337519 | 2020-07-15 | Arlington | Virginia | 51013 | 2677 | 134 |
334324 | 334324 | 2020-07-14 | Arlington | Virginia | 51013 | 2660 | 134 |
331131 | 331131 | 2020-07-13 | Arlington | Virginia | 51013 | 2626 | 134 |
327945 | 327945 | 2020-07-12 | Arlington | Virginia | 51013 | 2615 | 134 |
324760 | 324760 | 2020-07-11 | Arlington | Virginia | 51013 | 2597 | 134 |
321579 | 321579 | 2020-07-10 | Arlington | Virginia | 51013 | 2582 | 133 |
318400 | 318400 | 2020-07-09 | Arlington | Virginia | 51013 | 2567 | 132 |
315227 | 315227 | 2020-07-08 | Arlington | Virginia | 51013 | 2558 | 132 |
312053 | 312053 | 2020-07-07 | Arlington | Virginia | 51013 | 2550 | 131 |
308884 | 308884 | 2020-07-06 | Arlington | Virginia | 51013 | 2533 | 131 |
305716 | 305716 | 2020-07-05 | Arlington | Virginia | 51013 | 2533 | 131 |
302552 | 302552 | 2020-07-04 | Arlington | Virginia | 51013 | 2519 | 131 |
299388 | 299388 | 2020-07-03 | Arlington | Virginia | 51013 | 2500 | 132 |
296226 | 296226 | 2020-07-02 | Arlington | Virginia | 51013 | 2496 | 132 |
293071 | 293071 | 2020-07-01 | Arlington | Virginia | 51013 | 2484 | 132 |
289918 | 289918 | 2020-06-30 | Arlington | Virginia | 51013 | 2479 | 132 |
286768 | 286768 | 2020-06-29 | Arlington | Virginia | 51013 | 2466 | 132 |
283622 | 283622 | 2020-06-28 | Arlington | Virginia | 51013 | 2464 | 132 |
280476 | 280476 | 2020-06-27 | Arlington | Virginia | 51013 | 2454 | 132 |
277328 | 277328 | 2020-06-26 | Arlington | Virginia | 51013 | 2449 | 132 |
274180 | 274180 | 2020-06-25 | Arlington | Virginia | 51013 | 2445 | 127 |
271040 | 271040 | 2020-06-24 | Arlington | Virginia | 51013 | 2438 | 126 |
267906 | 267906 | 2020-06-23 | Arlington | Virginia | 51013 | 2431 | 126 |
264777 | 264777 | 2020-06-22 | Arlington | Virginia | 51013 | 2424 | 126 |
261648 | 261648 | 2020-06-21 | Arlington | Virginia | 51013 | 2418 | 126 |
258521 | 258521 | 2020-06-20 | Arlington | Virginia | 51013 | 2405 | 126 |
255394 | 255394 | 2020-06-19 | Arlington | Virginia | 51013 | 2396 | 126 |
252276 | 252276 | 2020-06-18 | Arlington | Virginia | 51013 | 2382 | 126 |
249161 | 249161 | 2020-06-17 | Arlington | Virginia | 51013 | 2372 | 124 |
246049 | 246049 | 2020-06-16 | Arlington | Virginia | 51013 | 2363 | 125 |
242937 | 242937 | 2020-06-15 | Arlington | Virginia | 51013 | 2346 | 125 |
239826 | 239826 | 2020-06-14 | Arlington | Virginia | 51013 | 2338 | 125 |
236718 | 236718 | 2020-06-13 | Arlington | Virginia | 51013 | 2321 | 125 |
233611 | 233611 | 2020-06-12 | Arlington | Virginia | 51013 | 2307 | 125 |
230506 | 230506 | 2020-06-11 | Arlington | Virginia | 51013 | 2299 | 124 |
227402 | 227402 | 2020-06-10 | Arlington | Virginia | 51013 | 2280 | 121 |
224302 | 224302 | 2020-06-09 | Arlington | Virginia | 51013 | 2265 | 122 |
221206 | 221206 | 2020-06-08 | Arlington | Virginia | 51013 | 2256 | 122 |
218114 | 218114 | 2020-06-07 | Arlington | Virginia | 51013 | 2225 | 121 |
215024 | 215024 | 2020-06-06 | Arlington | Virginia | 51013 | 2195 | 120 |
211937 | 211937 | 2020-06-05 | Arlington | Virginia | 51013 | 2173 | 121 |
208852 | 208852 | 2020-06-04 | Arlington | Virginia | 51013 | 2150 | 120 |
205770 | 205770 | 2020-06-03 | Arlington | Virginia | 51013 | 2142 | 120 |
202691 | 202691 | 2020-06-02 | Arlington | Virginia | 51013 | 2133 | 117 |
199615 | 199615 | 2020-06-01 | Arlington | Virginia | 51013 | 2123 | 116 |
196542 | 196542 | 2020-05-31 | Arlington | Virginia | 51013 | 2116 | 115 |
193472 | 193472 | 2020-05-30 | Arlington | Virginia | 51013 | 2107 | 113 |
190406 | 190406 | 2020-05-29 | Arlington | Virginia | 51013 | 2089 | 111 |
187342 | 187342 | 2020-05-28 | Arlington | Virginia | 51013 | 2039 | 109 |
184285 | 184285 | 2020-05-27 | Arlington | Virginia | 51013 | 1988 | 109 |
181234 | 181234 | 2020-05-26 | Arlington | Virginia | 51013 | 1935 | 104 |
178190 | 178190 | 2020-05-25 | Arlington | Virginia | 51013 | 1897 | 101 |
175145 | 175145 | 2020-05-24 | Arlington | Virginia | 51013 | 1873 | 98 |
172102 | 172102 | 2020-05-23 | Arlington | Virginia | 51013 | 1804 | 95 |
169061 | 169061 | 2020-05-22 | Arlington | Virginia | 51013 | 1795 | 91 |
166025 | 166025 | 2020-05-21 | Arlington | Virginia | 51013 | 1763 | 89 |
162996 | 162996 | 2020-05-20 | Arlington | Virginia | 51013 | 1728 | 81 |
159968 | 159968 | 2020-05-19 | Arlington | Virginia | 51013 | 1688 | 79 |
156944 | 156944 | 2020-05-18 | Arlington | Virginia | 51013 | 1638 | 77 |
153927 | 153927 | 2020-05-17 | Arlington | Virginia | 51013 | 1590 | 75 |
150916 | 150916 | 2020-05-16 | Arlington | Virginia | 51013 | 1560 | 74 |
147907 | 147907 | 2020-05-15 | Arlington | Virginia | 51013 | 1534 | 71 |
144904 | 144904 | 2020-05-14 | Arlington | Virginia | 51013 | 1499 | 70 |
141907 | 141907 | 2020-05-13 | Arlington | Virginia | 51013 | 1460 | 69 |
138911 | 138911 | 2020-05-12 | Arlington | Virginia | 51013 | 1416 | 66 |
135920 | 135920 | 2020-05-11 | Arlington | Virginia | 51013 | 1399 | 60 |
132930 | 132930 | 2020-05-10 | Arlington | Virginia | 51013 | 1368 | 61 |
129940 | 129940 | 2020-05-09 | Arlington | Virginia | 51013 | 1332 | 60 |
126951 | 126951 | 2020-05-08 | Arlington | Virginia | 51013 | 1281 | 57 |
123966 | 123966 | 2020-05-07 | Arlington | Virginia | 51013 | 1248 | 52 |
120985 | 120985 | 2020-05-06 | Arlington | Virginia | 51013 | 1169 | 49 |
118021 | 118021 | 2020-05-05 | Arlington | Virginia | 51013 | 1169 | 49 |
115062 | 115062 | 2020-05-04 | Arlington | Virginia | 51013 | 1139 | 47 |
112179 | 112179 | 2020-05-03 | Arlington | Virginia | 51013 | 1106 | 46 |
109305 | 109305 | 2020-05-02 | Arlington | Virginia | 51013 | 1044 | 46 |
106436 | 106436 | 2020-05-01 | Arlington | Virginia | 51013 | 1004 | 42 |
103572 | 103572 | 2020-04-30 | Arlington | Virginia | 51013 | 967 | 41 |
100717 | 100717 | 2020-04-29 | Arlington | Virginia | 51013 | 912 | 32 |
97867 | 97867 | 2020-04-28 | Arlington | Virginia | 51013 | 865 | 32 |
95025 | 95025 | 2020-04-27 | Arlington | Virginia | 51013 | 836 | 32 |
92196 | 92196 | 2020-04-26 | Arlington | Virginia | 51013 | 790 | 32 |
89379 | 89379 | 2020-04-25 | Arlington | Virginia | 51013 | 764 | 29 |
86564 | 86564 | 2020-04-24 | Arlington | Virginia | 51013 | 722 | 24 |
83757 | 83757 | 2020-04-23 | Arlington | Virginia | 51013 | 686 | 24 |
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);