ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 47055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502138 | 2502138 | 2022-05-13 | Giles | Tennessee | 47055 | 9448 | 190 |
2498880 | 2498880 | 2022-05-12 | Giles | Tennessee | 47055 | 9448 | 190 |
2495622 | 2495622 | 2022-05-11 | Giles | Tennessee | 47055 | 9448 | 190 |
2492364 | 2492364 | 2022-05-10 | Giles | Tennessee | 47055 | 9429 | 190 |
2489106 | 2489106 | 2022-05-09 | Giles | Tennessee | 47055 | 9429 | 190 |
2485849 | 2485849 | 2022-05-08 | Giles | Tennessee | 47055 | 9429 | 190 |
2482591 | 2482591 | 2022-05-07 | Giles | Tennessee | 47055 | 9429 | 190 |
2479333 | 2479333 | 2022-05-06 | Giles | Tennessee | 47055 | 9429 | 190 |
2476075 | 2476075 | 2022-05-05 | Giles | Tennessee | 47055 | 9429 | 190 |
2472818 | 2472818 | 2022-05-04 | Giles | Tennessee | 47055 | 9429 | 190 |
2469562 | 2469562 | 2022-05-03 | Giles | Tennessee | 47055 | 9418 | 190 |
2466306 | 2466306 | 2022-05-02 | Giles | Tennessee | 47055 | 9418 | 190 |
2463051 | 2463051 | 2022-05-01 | Giles | Tennessee | 47055 | 9418 | 190 |
2459795 | 2459795 | 2022-04-30 | Giles | Tennessee | 47055 | 9418 | 190 |
2456539 | 2456539 | 2022-04-29 | Giles | Tennessee | 47055 | 9418 | 190 |
2453283 | 2453283 | 2022-04-28 | Giles | Tennessee | 47055 | 9418 | 190 |
2450027 | 2450027 | 2022-04-27 | Giles | Tennessee | 47055 | 9418 | 190 |
2446770 | 2446770 | 2022-04-26 | Giles | Tennessee | 47055 | 9412 | 190 |
2443515 | 2443515 | 2022-04-25 | Giles | Tennessee | 47055 | 9412 | 190 |
2440259 | 2440259 | 2022-04-24 | Giles | Tennessee | 47055 | 9412 | 190 |
2437003 | 2437003 | 2022-04-23 | Giles | Tennessee | 47055 | 9412 | 190 |
2433747 | 2433747 | 2022-04-22 | Giles | Tennessee | 47055 | 9412 | 190 |
2430491 | 2430491 | 2022-04-21 | Giles | Tennessee | 47055 | 9412 | 190 |
2427235 | 2427235 | 2022-04-20 | Giles | Tennessee | 47055 | 9412 | 190 |
2423979 | 2423979 | 2022-04-19 | Giles | Tennessee | 47055 | 9407 | 190 |
2420723 | 2420723 | 2022-04-18 | Giles | Tennessee | 47055 | 9407 | 190 |
2417467 | 2417467 | 2022-04-17 | Giles | Tennessee | 47055 | 9407 | 190 |
2414211 | 2414211 | 2022-04-16 | Giles | Tennessee | 47055 | 9407 | 190 |
2410955 | 2410955 | 2022-04-15 | Giles | Tennessee | 47055 | 9407 | 190 |
2407699 | 2407699 | 2022-04-14 | Giles | Tennessee | 47055 | 9407 | 190 |
2404443 | 2404443 | 2022-04-13 | Giles | Tennessee | 47055 | 9407 | 190 |
2401188 | 2401188 | 2022-04-12 | Giles | Tennessee | 47055 | 9401 | 189 |
2397933 | 2397933 | 2022-04-11 | Giles | Tennessee | 47055 | 9401 | 189 |
2394678 | 2394678 | 2022-04-10 | Giles | Tennessee | 47055 | 9401 | 189 |
2391422 | 2391422 | 2022-04-09 | Giles | Tennessee | 47055 | 9401 | 189 |
2388166 | 2388166 | 2022-04-08 | Giles | Tennessee | 47055 | 9401 | 189 |
2384911 | 2384911 | 2022-04-07 | Giles | Tennessee | 47055 | 9401 | 189 |
2381656 | 2381656 | 2022-04-06 | Giles | Tennessee | 47055 | 9401 | 189 |
2378401 | 2378401 | 2022-04-05 | Giles | Tennessee | 47055 | 9399 | 188 |
2375147 | 2375147 | 2022-04-04 | Giles | Tennessee | 47055 | 9399 | 188 |
2371895 | 2371895 | 2022-04-03 | Giles | Tennessee | 47055 | 9399 | 188 |
2368642 | 2368642 | 2022-04-02 | Giles | Tennessee | 47055 | 9399 | 188 |
2365389 | 2365389 | 2022-04-01 | Giles | Tennessee | 47055 | 9399 | 188 |
2362136 | 2362136 | 2022-03-31 | Giles | Tennessee | 47055 | 9399 | 188 |
2358882 | 2358882 | 2022-03-30 | Giles | Tennessee | 47055 | 9399 | 188 |
2355628 | 2355628 | 2022-03-29 | Giles | Tennessee | 47055 | 9397 | 186 |
2352375 | 2352375 | 2022-03-28 | Giles | Tennessee | 47055 | 9397 | 186 |
2349123 | 2349123 | 2022-03-27 | Giles | Tennessee | 47055 | 9397 | 186 |
2345870 | 2345870 | 2022-03-26 | Giles | Tennessee | 47055 | 9397 | 186 |
2342617 | 2342617 | 2022-03-25 | Giles | Tennessee | 47055 | 9397 | 186 |
2339364 | 2339364 | 2022-03-24 | Giles | Tennessee | 47055 | 9397 | 186 |
2336110 | 2336110 | 2022-03-23 | Giles | Tennessee | 47055 | 9397 | 186 |
2332856 | 2332856 | 2022-03-22 | Giles | Tennessee | 47055 | 9390 | 185 |
2329603 | 2329603 | 2022-03-21 | Giles | Tennessee | 47055 | 9390 | 185 |
2326351 | 2326351 | 2022-03-20 | Giles | Tennessee | 47055 | 9390 | 185 |
2323098 | 2323098 | 2022-03-19 | Giles | Tennessee | 47055 | 9390 | 185 |
2319844 | 2319844 | 2022-03-18 | Giles | Tennessee | 47055 | 9390 | 185 |
2316590 | 2316590 | 2022-03-17 | Giles | Tennessee | 47055 | 9390 | 185 |
2313337 | 2313337 | 2022-03-16 | Giles | Tennessee | 47055 | 9390 | 185 |
2310084 | 2310084 | 2022-03-15 | Giles | Tennessee | 47055 | 9382 | 172 |
2306831 | 2306831 | 2022-03-14 | Giles | Tennessee | 47055 | 9382 | 172 |
2303580 | 2303580 | 2022-03-13 | Giles | Tennessee | 47055 | 9382 | 172 |
2300328 | 2300328 | 2022-03-12 | Giles | Tennessee | 47055 | 9382 | 172 |
2297076 | 2297076 | 2022-03-11 | Giles | Tennessee | 47055 | 9382 | 172 |
2293824 | 2293824 | 2022-03-10 | Giles | Tennessee | 47055 | 9382 | 172 |
2290572 | 2290572 | 2022-03-09 | Giles | Tennessee | 47055 | 9382 | 172 |
2287320 | 2287320 | 2022-03-08 | Giles | Tennessee | 47055 | 9374 | 172 |
2284068 | 2284068 | 2022-03-07 | Giles | Tennessee | 47055 | 9374 | 172 |
2280816 | 2280816 | 2022-03-06 | Giles | Tennessee | 47055 | 9374 | 172 |
2277563 | 2277563 | 2022-03-05 | Giles | Tennessee | 47055 | 9374 | 172 |
2274310 | 2274310 | 2022-03-04 | Giles | Tennessee | 47055 | 9374 | 172 |
2271057 | 2271057 | 2022-03-03 | Giles | Tennessee | 47055 | 9374 | 172 |
2267805 | 2267805 | 2022-03-02 | Giles | Tennessee | 47055 | 9374 | 172 |
2264552 | 2264552 | 2022-03-01 | Giles | Tennessee | 47055 | 9342 | 166 |
2261302 | 2261302 | 2022-02-28 | Giles | Tennessee | 47055 | 9342 | 166 |
2258051 | 2258051 | 2022-02-27 | Giles | Tennessee | 47055 | 9342 | 166 |
2254800 | 2254800 | 2022-02-26 | Giles | Tennessee | 47055 | 9342 | 166 |
2251549 | 2251549 | 2022-02-25 | Giles | Tennessee | 47055 | 9342 | 166 |
2248298 | 2248298 | 2022-02-24 | Giles | Tennessee | 47055 | 9342 | 166 |
2245047 | 2245047 | 2022-02-23 | Giles | Tennessee | 47055 | 9342 | 166 |
2241796 | 2241796 | 2022-02-22 | Giles | Tennessee | 47055 | 9251 | 164 |
2238545 | 2238545 | 2022-02-21 | Giles | Tennessee | 47055 | 9251 | 164 |
2235294 | 2235294 | 2022-02-20 | Giles | Tennessee | 47055 | 9251 | 164 |
2232043 | 2232043 | 2022-02-19 | Giles | Tennessee | 47055 | 9251 | 164 |
2228792 | 2228792 | 2022-02-18 | Giles | Tennessee | 47055 | 9251 | 164 |
2225541 | 2225541 | 2022-02-17 | Giles | Tennessee | 47055 | 9251 | 164 |
2222290 | 2222290 | 2022-02-16 | Giles | Tennessee | 47055 | 9251 | 164 |
2219039 | 2219039 | 2022-02-15 | Giles | Tennessee | 47055 | 9117 | 161 |
2215788 | 2215788 | 2022-02-14 | Giles | Tennessee | 47055 | 9117 | 161 |
2212537 | 2212537 | 2022-02-13 | Giles | Tennessee | 47055 | 9117 | 161 |
2209284 | 2209284 | 2022-02-12 | Giles | Tennessee | 47055 | 9117 | 161 |
2206031 | 2206031 | 2022-02-11 | Giles | Tennessee | 47055 | 9117 | 161 |
2202778 | 2202778 | 2022-02-10 | Giles | Tennessee | 47055 | 9117 | 161 |
2199524 | 2199524 | 2022-02-09 | Giles | Tennessee | 47055 | 9117 | 161 |
2196270 | 2196270 | 2022-02-08 | Giles | Tennessee | 47055 | 8743 | 161 |
2193016 | 2193016 | 2022-02-07 | Giles | Tennessee | 47055 | 8743 | 161 |
2189762 | 2189762 | 2022-02-06 | Giles | Tennessee | 47055 | 8743 | 161 |
2186509 | 2186509 | 2022-02-05 | Giles | Tennessee | 47055 | 8743 | 161 |
2183257 | 2183257 | 2022-02-04 | Giles | Tennessee | 47055 | 8743 | 161 |
2180005 | 2180005 | 2022-02-03 | Giles | Tennessee | 47055 | 8743 | 161 |
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);