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)
Suggested facets: date, cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502138 | 2502138 | 2022-05-13 | Giles | Tennessee | 47055 | 9448 | 190 |
2502558 | 2502558 | 2022-05-13 | Giles | Virginia | 51071 | 4115 | 50 |
2498880 | 2498880 | 2022-05-12 | Giles | Tennessee | 47055 | 9448 | 190 |
2499300 | 2499300 | 2022-05-12 | Giles | Virginia | 51071 | 4104 | 50 |
2495622 | 2495622 | 2022-05-11 | Giles | Tennessee | 47055 | 9448 | 190 |
2496042 | 2496042 | 2022-05-11 | Giles | Virginia | 51071 | 4100 | 50 |
2492364 | 2492364 | 2022-05-10 | Giles | Tennessee | 47055 | 9429 | 190 |
2492784 | 2492784 | 2022-05-10 | Giles | Virginia | 51071 | 4095 | 50 |
2489106 | 2489106 | 2022-05-09 | Giles | Tennessee | 47055 | 9429 | 190 |
2489526 | 2489526 | 2022-05-09 | Giles | Virginia | 51071 | 4091 | 50 |
2485849 | 2485849 | 2022-05-08 | Giles | Tennessee | 47055 | 9429 | 190 |
2486269 | 2486269 | 2022-05-08 | Giles | Virginia | 51071 | 4085 | 50 |
2482591 | 2482591 | 2022-05-07 | Giles | Tennessee | 47055 | 9429 | 190 |
2483011 | 2483011 | 2022-05-07 | Giles | Virginia | 51071 | 4085 | 50 |
2479333 | 2479333 | 2022-05-06 | Giles | Tennessee | 47055 | 9429 | 190 |
2479753 | 2479753 | 2022-05-06 | Giles | Virginia | 51071 | 4085 | 50 |
2476075 | 2476075 | 2022-05-05 | Giles | Tennessee | 47055 | 9429 | 190 |
2476495 | 2476495 | 2022-05-05 | Giles | Virginia | 51071 | 4083 | 50 |
2472818 | 2472818 | 2022-05-04 | Giles | Tennessee | 47055 | 9429 | 190 |
2473237 | 2473237 | 2022-05-04 | Giles | Virginia | 51071 | 4081 | 50 |
2469562 | 2469562 | 2022-05-03 | Giles | Tennessee | 47055 | 9418 | 190 |
2469981 | 2469981 | 2022-05-03 | Giles | Virginia | 51071 | 4080 | 50 |
2466306 | 2466306 | 2022-05-02 | Giles | Tennessee | 47055 | 9418 | 190 |
2466725 | 2466725 | 2022-05-02 | Giles | Virginia | 51071 | 4079 | 50 |
2463051 | 2463051 | 2022-05-01 | Giles | Tennessee | 47055 | 9418 | 190 |
2463470 | 2463470 | 2022-05-01 | Giles | Virginia | 51071 | 4070 | 50 |
2459795 | 2459795 | 2022-04-30 | Giles | Tennessee | 47055 | 9418 | 190 |
2460214 | 2460214 | 2022-04-30 | Giles | Virginia | 51071 | 4070 | 50 |
2456539 | 2456539 | 2022-04-29 | Giles | Tennessee | 47055 | 9418 | 190 |
2456958 | 2456958 | 2022-04-29 | Giles | Virginia | 51071 | 4070 | 50 |
2453283 | 2453283 | 2022-04-28 | Giles | Tennessee | 47055 | 9418 | 190 |
2453702 | 2453702 | 2022-04-28 | Giles | Virginia | 51071 | 4068 | 50 |
2450027 | 2450027 | 2022-04-27 | Giles | Tennessee | 47055 | 9418 | 190 |
2450446 | 2450446 | 2022-04-27 | Giles | Virginia | 51071 | 4066 | 50 |
2446770 | 2446770 | 2022-04-26 | Giles | Tennessee | 47055 | 9412 | 190 |
2447189 | 2447189 | 2022-04-26 | Giles | Virginia | 51071 | 4063 | 50 |
2443515 | 2443515 | 2022-04-25 | Giles | Tennessee | 47055 | 9412 | 190 |
2443934 | 2443934 | 2022-04-25 | Giles | Virginia | 51071 | 4061 | 50 |
2440259 | 2440259 | 2022-04-24 | Giles | Tennessee | 47055 | 9412 | 190 |
2440678 | 2440678 | 2022-04-24 | Giles | Virginia | 51071 | 4058 | 50 |
2437003 | 2437003 | 2022-04-23 | Giles | Tennessee | 47055 | 9412 | 190 |
2437422 | 2437422 | 2022-04-23 | Giles | Virginia | 51071 | 4058 | 50 |
2433747 | 2433747 | 2022-04-22 | Giles | Tennessee | 47055 | 9412 | 190 |
2434166 | 2434166 | 2022-04-22 | Giles | Virginia | 51071 | 4058 | 50 |
2430491 | 2430491 | 2022-04-21 | Giles | Tennessee | 47055 | 9412 | 190 |
2430910 | 2430910 | 2022-04-21 | Giles | Virginia | 51071 | 4056 | 50 |
2427235 | 2427235 | 2022-04-20 | Giles | Tennessee | 47055 | 9412 | 190 |
2427654 | 2427654 | 2022-04-20 | Giles | Virginia | 51071 | 4057 | 50 |
2423979 | 2423979 | 2022-04-19 | Giles | Tennessee | 47055 | 9407 | 190 |
2424398 | 2424398 | 2022-04-19 | Giles | Virginia | 51071 | 4057 | 50 |
2420723 | 2420723 | 2022-04-18 | Giles | Tennessee | 47055 | 9407 | 190 |
2421142 | 2421142 | 2022-04-18 | Giles | Virginia | 51071 | 4058 | 49 |
2417467 | 2417467 | 2022-04-17 | Giles | Tennessee | 47055 | 9407 | 190 |
2417886 | 2417886 | 2022-04-17 | Giles | Virginia | 51071 | 4056 | 49 |
2414211 | 2414211 | 2022-04-16 | Giles | Tennessee | 47055 | 9407 | 190 |
2414630 | 2414630 | 2022-04-16 | Giles | Virginia | 51071 | 4056 | 49 |
2410955 | 2410955 | 2022-04-15 | Giles | Tennessee | 47055 | 9407 | 190 |
2411374 | 2411374 | 2022-04-15 | Giles | Virginia | 51071 | 4056 | 49 |
2407699 | 2407699 | 2022-04-14 | Giles | Tennessee | 47055 | 9407 | 190 |
2408118 | 2408118 | 2022-04-14 | Giles | Virginia | 51071 | 4054 | 49 |
2404443 | 2404443 | 2022-04-13 | Giles | Tennessee | 47055 | 9407 | 190 |
2404862 | 2404862 | 2022-04-13 | Giles | Virginia | 51071 | 4054 | 49 |
2401188 | 2401188 | 2022-04-12 | Giles | Tennessee | 47055 | 9401 | 189 |
2401607 | 2401607 | 2022-04-12 | Giles | Virginia | 51071 | 4053 | 48 |
2397933 | 2397933 | 2022-04-11 | Giles | Tennessee | 47055 | 9401 | 189 |
2398352 | 2398352 | 2022-04-11 | Giles | Virginia | 51071 | 4051 | 48 |
2394678 | 2394678 | 2022-04-10 | Giles | Tennessee | 47055 | 9401 | 189 |
2395097 | 2395097 | 2022-04-10 | Giles | Virginia | 51071 | 4052 | 48 |
2391422 | 2391422 | 2022-04-09 | Giles | Tennessee | 47055 | 9401 | 189 |
2391841 | 2391841 | 2022-04-09 | Giles | Virginia | 51071 | 4052 | 48 |
2388166 | 2388166 | 2022-04-08 | Giles | Tennessee | 47055 | 9401 | 189 |
2388585 | 2388585 | 2022-04-08 | Giles | Virginia | 51071 | 4052 | 48 |
2384911 | 2384911 | 2022-04-07 | Giles | Tennessee | 47055 | 9401 | 189 |
2385330 | 2385330 | 2022-04-07 | Giles | Virginia | 51071 | 4051 | 47 |
2381656 | 2381656 | 2022-04-06 | Giles | Tennessee | 47055 | 9401 | 189 |
2382075 | 2382075 | 2022-04-06 | Giles | Virginia | 51071 | 4051 | 47 |
2378401 | 2378401 | 2022-04-05 | Giles | Tennessee | 47055 | 9399 | 188 |
2378820 | 2378820 | 2022-04-05 | Giles | Virginia | 51071 | 4051 | 46 |
2375147 | 2375147 | 2022-04-04 | Giles | Tennessee | 47055 | 9399 | 188 |
2375566 | 2375566 | 2022-04-04 | Giles | Virginia | 51071 | 4049 | 46 |
2371895 | 2371895 | 2022-04-03 | Giles | Tennessee | 47055 | 9399 | 188 |
2372314 | 2372314 | 2022-04-03 | Giles | Virginia | 51071 | 4048 | 46 |
2368642 | 2368642 | 2022-04-02 | Giles | Tennessee | 47055 | 9399 | 188 |
2369061 | 2369061 | 2022-04-02 | Giles | Virginia | 51071 | 4048 | 46 |
2365389 | 2365389 | 2022-04-01 | Giles | Tennessee | 47055 | 9399 | 188 |
2365808 | 2365808 | 2022-04-01 | Giles | Virginia | 51071 | 4048 | 46 |
2362136 | 2362136 | 2022-03-31 | Giles | Tennessee | 47055 | 9399 | 188 |
2362555 | 2362555 | 2022-03-31 | Giles | Virginia | 51071 | 4046 | 46 |
2358882 | 2358882 | 2022-03-30 | Giles | Tennessee | 47055 | 9399 | 188 |
2359301 | 2359301 | 2022-03-30 | Giles | Virginia | 51071 | 4045 | 46 |
2355628 | 2355628 | 2022-03-29 | Giles | Tennessee | 47055 | 9397 | 186 |
2356047 | 2356047 | 2022-03-29 | Giles | Virginia | 51071 | 4044 | 46 |
2352375 | 2352375 | 2022-03-28 | Giles | Tennessee | 47055 | 9397 | 186 |
2352794 | 2352794 | 2022-03-28 | Giles | Virginia | 51071 | 4044 | 46 |
2349123 | 2349123 | 2022-03-27 | Giles | Tennessee | 47055 | 9397 | 186 |
2349542 | 2349542 | 2022-03-27 | Giles | Virginia | 51071 | 4041 | 46 |
2345870 | 2345870 | 2022-03-26 | Giles | Tennessee | 47055 | 9397 | 186 |
2346289 | 2346289 | 2022-03-26 | Giles | Virginia | 51071 | 4041 | 46 |
2342617 | 2342617 | 2022-03-25 | Giles | Tennessee | 47055 | 9397 | 186 |
2343036 | 2343036 | 2022-03-25 | Giles | Virginia | 51071 | 4041 | 46 |
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);