ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,543 rows where county = "Giles" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2339364 | 2339364 | 2022-03-24 | Giles | Tennessee | 47055 | 9397 | 186 |
2339783 | 2339783 | 2022-03-24 | Giles | Virginia | 51071 | 4037 | 46 |
2336110 | 2336110 | 2022-03-23 | Giles | Tennessee | 47055 | 9397 | 186 |
2336529 | 2336529 | 2022-03-23 | Giles | Virginia | 51071 | 4036 | 46 |
2332856 | 2332856 | 2022-03-22 | Giles | Tennessee | 47055 | 9390 | 185 |
2333275 | 2333275 | 2022-03-22 | Giles | Virginia | 51071 | 4036 | 46 |
2329603 | 2329603 | 2022-03-21 | Giles | Tennessee | 47055 | 9390 | 185 |
2330022 | 2330022 | 2022-03-21 | Giles | Virginia | 51071 | 4036 | 46 |
2326351 | 2326351 | 2022-03-20 | Giles | Tennessee | 47055 | 9390 | 185 |
2326770 | 2326770 | 2022-03-20 | Giles | Virginia | 51071 | 4036 | 46 |
2323098 | 2323098 | 2022-03-19 | Giles | Tennessee | 47055 | 9390 | 185 |
2323517 | 2323517 | 2022-03-19 | Giles | Virginia | 51071 | 4036 | 46 |
2319844 | 2319844 | 2022-03-18 | Giles | Tennessee | 47055 | 9390 | 185 |
2320263 | 2320263 | 2022-03-18 | Giles | Virginia | 51071 | 4036 | 46 |
2316590 | 2316590 | 2022-03-17 | Giles | Tennessee | 47055 | 9390 | 185 |
2317009 | 2317009 | 2022-03-17 | Giles | Virginia | 51071 | 4036 | 46 |
2313337 | 2313337 | 2022-03-16 | Giles | Tennessee | 47055 | 9390 | 185 |
2313756 | 2313756 | 2022-03-16 | Giles | Virginia | 51071 | 4036 | 46 |
2310084 | 2310084 | 2022-03-15 | Giles | Tennessee | 47055 | 9382 | 172 |
2310503 | 2310503 | 2022-03-15 | Giles | Virginia | 51071 | 4033 | 46 |
2306831 | 2306831 | 2022-03-14 | Giles | Tennessee | 47055 | 9382 | 172 |
2307250 | 2307250 | 2022-03-14 | Giles | Virginia | 51071 | 4030 | 46 |
2303580 | 2303580 | 2022-03-13 | Giles | Tennessee | 47055 | 9382 | 172 |
2303999 | 2303999 | 2022-03-13 | Giles | Virginia | 51071 | 4028 | 45 |
2300328 | 2300328 | 2022-03-12 | Giles | Tennessee | 47055 | 9382 | 172 |
2300747 | 2300747 | 2022-03-12 | Giles | Virginia | 51071 | 4028 | 45 |
2297076 | 2297076 | 2022-03-11 | Giles | Tennessee | 47055 | 9382 | 172 |
2297495 | 2297495 | 2022-03-11 | Giles | Virginia | 51071 | 4028 | 45 |
2293824 | 2293824 | 2022-03-10 | Giles | Tennessee | 47055 | 9382 | 172 |
2294243 | 2294243 | 2022-03-10 | Giles | Virginia | 51071 | 4021 | 44 |
2290572 | 2290572 | 2022-03-09 | Giles | Tennessee | 47055 | 9382 | 172 |
2290991 | 2290991 | 2022-03-09 | Giles | Virginia | 51071 | 4017 | 44 |
2287320 | 2287320 | 2022-03-08 | Giles | Tennessee | 47055 | 9374 | 172 |
2287739 | 2287739 | 2022-03-08 | Giles | Virginia | 51071 | 4014 | 44 |
2284068 | 2284068 | 2022-03-07 | Giles | Tennessee | 47055 | 9374 | 172 |
2284487 | 2284487 | 2022-03-07 | Giles | Virginia | 51071 | 4014 | 44 |
2280816 | 2280816 | 2022-03-06 | Giles | Tennessee | 47055 | 9374 | 172 |
2281235 | 2281235 | 2022-03-06 | Giles | Virginia | 51071 | 4004 | 44 |
2277563 | 2277563 | 2022-03-05 | Giles | Tennessee | 47055 | 9374 | 172 |
2277982 | 2277982 | 2022-03-05 | Giles | Virginia | 51071 | 4004 | 44 |
2274310 | 2274310 | 2022-03-04 | Giles | Tennessee | 47055 | 9374 | 172 |
2274729 | 2274729 | 2022-03-04 | Giles | Virginia | 51071 | 4004 | 44 |
2271057 | 2271057 | 2022-03-03 | Giles | Tennessee | 47055 | 9374 | 172 |
2271476 | 2271476 | 2022-03-03 | Giles | Virginia | 51071 | 3999 | 44 |
2267805 | 2267805 | 2022-03-02 | Giles | Tennessee | 47055 | 9374 | 172 |
2268224 | 2268224 | 2022-03-02 | Giles | Virginia | 51071 | 3995 | 44 |
2264552 | 2264552 | 2022-03-01 | Giles | Tennessee | 47055 | 9342 | 166 |
2264971 | 2264971 | 2022-03-01 | Giles | Virginia | 51071 | 3986 | 44 |
2261302 | 2261302 | 2022-02-28 | Giles | Tennessee | 47055 | 9342 | 166 |
2261721 | 2261721 | 2022-02-28 | Giles | Virginia | 51071 | 3981 | 44 |
2258051 | 2258051 | 2022-02-27 | Giles | Tennessee | 47055 | 9342 | 166 |
2258470 | 2258470 | 2022-02-27 | Giles | Virginia | 51071 | 3968 | 43 |
2254800 | 2254800 | 2022-02-26 | Giles | Tennessee | 47055 | 9342 | 166 |
2255219 | 2255219 | 2022-02-26 | Giles | Virginia | 51071 | 3968 | 43 |
2251549 | 2251549 | 2022-02-25 | Giles | Tennessee | 47055 | 9342 | 166 |
2251968 | 2251968 | 2022-02-25 | Giles | Virginia | 51071 | 3968 | 43 |
2248298 | 2248298 | 2022-02-24 | Giles | Tennessee | 47055 | 9342 | 166 |
2248717 | 2248717 | 2022-02-24 | Giles | Virginia | 51071 | 3963 | 43 |
2245047 | 2245047 | 2022-02-23 | Giles | Tennessee | 47055 | 9342 | 166 |
2245466 | 2245466 | 2022-02-23 | Giles | Virginia | 51071 | 3958 | 43 |
2241796 | 2241796 | 2022-02-22 | Giles | Tennessee | 47055 | 9251 | 164 |
2242215 | 2242215 | 2022-02-22 | Giles | Virginia | 51071 | 3950 | 43 |
2238545 | 2238545 | 2022-02-21 | Giles | Tennessee | 47055 | 9251 | 164 |
2238964 | 2238964 | 2022-02-21 | Giles | Virginia | 51071 | 3945 | 43 |
2235294 | 2235294 | 2022-02-20 | Giles | Tennessee | 47055 | 9251 | 164 |
2235713 | 2235713 | 2022-02-20 | Giles | Virginia | 51071 | 3905 | 43 |
2232043 | 2232043 | 2022-02-19 | Giles | Tennessee | 47055 | 9251 | 164 |
2232462 | 2232462 | 2022-02-19 | Giles | Virginia | 51071 | 3905 | 43 |
2228792 | 2228792 | 2022-02-18 | Giles | Tennessee | 47055 | 9251 | 164 |
2229211 | 2229211 | 2022-02-18 | Giles | Virginia | 51071 | 3905 | 43 |
2225541 | 2225541 | 2022-02-17 | Giles | Tennessee | 47055 | 9251 | 164 |
2225960 | 2225960 | 2022-02-17 | Giles | Virginia | 51071 | 3890 | 43 |
2222290 | 2222290 | 2022-02-16 | Giles | Tennessee | 47055 | 9251 | 164 |
2222709 | 2222709 | 2022-02-16 | Giles | Virginia | 51071 | 3868 | 43 |
2219039 | 2219039 | 2022-02-15 | Giles | Tennessee | 47055 | 9117 | 161 |
2219458 | 2219458 | 2022-02-15 | Giles | Virginia | 51071 | 3844 | 43 |
2215788 | 2215788 | 2022-02-14 | Giles | Tennessee | 47055 | 9117 | 161 |
2216208 | 2216208 | 2022-02-14 | Giles | Virginia | 51071 | 3831 | 43 |
2212537 | 2212537 | 2022-02-13 | Giles | Tennessee | 47055 | 9117 | 161 |
2212957 | 2212957 | 2022-02-13 | Giles | Virginia | 51071 | 3778 | 42 |
2209284 | 2209284 | 2022-02-12 | Giles | Tennessee | 47055 | 9117 | 161 |
2209704 | 2209704 | 2022-02-12 | Giles | Virginia | 51071 | 3778 | 42 |
2206031 | 2206031 | 2022-02-11 | Giles | Tennessee | 47055 | 9117 | 161 |
2206451 | 2206451 | 2022-02-11 | Giles | Virginia | 51071 | 3778 | 42 |
2202778 | 2202778 | 2022-02-10 | Giles | Tennessee | 47055 | 9117 | 161 |
2203198 | 2203198 | 2022-02-10 | Giles | Virginia | 51071 | 3745 | 42 |
2199524 | 2199524 | 2022-02-09 | Giles | Tennessee | 47055 | 9117 | 161 |
2199944 | 2199944 | 2022-02-09 | Giles | Virginia | 51071 | 3720 | 42 |
2196270 | 2196270 | 2022-02-08 | Giles | Tennessee | 47055 | 8743 | 161 |
2196690 | 2196690 | 2022-02-08 | Giles | Virginia | 51071 | 3692 | 42 |
2193016 | 2193016 | 2022-02-07 | Giles | Tennessee | 47055 | 8743 | 161 |
2193435 | 2193435 | 2022-02-07 | Giles | Virginia | 51071 | 3679 | 42 |
2189762 | 2189762 | 2022-02-06 | Giles | Tennessee | 47055 | 8743 | 161 |
2190182 | 2190182 | 2022-02-06 | Giles | Virginia | 51071 | 3604 | 42 |
2186509 | 2186509 | 2022-02-05 | Giles | Tennessee | 47055 | 8743 | 161 |
2186929 | 2186929 | 2022-02-05 | Giles | Virginia | 51071 | 3604 | 42 |
2183257 | 2183257 | 2022-02-04 | Giles | Tennessee | 47055 | 8743 | 161 |
2183676 | 2183676 | 2022-02-04 | Giles | Virginia | 51071 | 3604 | 42 |
2180005 | 2180005 | 2022-02-03 | Giles | Tennessee | 47055 | 8743 | 161 |
2180424 | 2180424 | 2022-02-03 | Giles | Virginia | 51071 | 3574 | 41 |
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);