René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"More data!","articleBody":"Starting a discussion around datasets people want to see. We currently only have the following tables/columns:\r\n\r\ncrime_by_city\r\n- city (TEXT)\r\n- violent_crime (DOUBLE_PRECISION)\r\n- murder_and_nonnegligent_manslaughter (DOUBLE_PRECISION)\r\n- rape (DOUBLE_PRECISION)\r\n- robbery (DOUBLE_PRECISION)\r\n- aggravated_assault (DOUBLE_PRECISION)\r\n- property_crime (DOUBLE_PRECISION)\r\n- burglary (DOUBLE_PRECISION)\r\n- larceny_theft (DOUBLE_PRECISION)\r\n- motor_vehicle_theft (DOUBLE_PRECISION)\r\n- arson (DOUBLE_PRECISION), state (TEXT)\r\n\r\nacs_census_data\r\n- zip_code (TEXT)\r\n- city (TEXT)\r\n- state (TEXT)\r\n- county (TEXT)\r\n- lat (DOUBLE_PRECISION)\r\n- lon (DOUBLE_PRECISION)\r\n- total_population (DOUBLE_PRECISION)\r\n- elderly_population (DOUBLE_PRECISION)\r\n- male_population (DOUBLE_PRECISION)\r\n- female_population (DOUBLE_PRECISION)\r\n- white_population (DOUBLE_PRECISION)\r\n- black_population (DOUBLE_PRECISION)\r\n- native_american_population (DOUBLE_PRECISION)\r\n- asian_population (DOUBLE_PRECISION)\r\n- two_or_more_population (DOUBLE_PRECISION)\r\n- hispanic_population (DOUBLE_PRECISION)\r\n- adult_population (DOUBLE_PRECISION)\r\n- citizen_adult_population (DOUBLE_PRECISION)\r\n- average_household_size (DOUBLE_PRECISION)\r\n- pop_under_5_years (DOUBLE_PRECISION)\r\n- pop_5_to_9_years (DOUBLE_PRECISION)\r\n- pop_10_to_14_years (DOUBLE_PRECISION)\r\n- pop_15_to_19_years (DOUBLE_PRECISION)\r\n- pop_20_to_24_years (DOUBLE_PRECISION)\r\n- pop_25_to_34_years (DOUBLE_PRECISION)\r\n- pop_35_to_44_years (DOUBLE_PRECISION)\r\n- pop_45_to_54_years (DOUBLE_PRECISION)\r\n- pop_55_to_59_years (DOUBLE_PRECISION)\r\n- pop_60_to_64_years (DOUBLE_PRECISION)\r\n- pop_65_to_74_years (DOUBLE_PRECISION)\r\n- pop_75_to_84_years (DOUBLE_PRECISION)\r\n- pop_85_years_and_over (DOUBLE_PRECISION)\r\n- per_capita_income (DOUBLE_PRECISION)\r\n- median_income_for_workers (DOUBLE_PRECISION)","author":{"url":"https://github.com/alex-sun-kuo","@type":"Person","name":"alex-sun-kuo"},"datePublished":"2023-03-11T03:01:55.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/47/textSQL/issues/47"}