mildbyte/complex_dataset

7 Tables
  • jfk_flights

    Preview
    6 Objects
     | 358 kB | 
    53.1k Rows
    Run SQL
    SELECT "fly_month", "passengers", "seats", "flights"
      FROM "mildbyte/complex_dataset:latest"."jfk_flights"
      LIMIT 100;
    timestamp without time zone
    fly_month
    integer
    passengers
    integer
    seats
    integer
    flights
     
  • lax_flights

    Preview
    9 Objects
     | 685 kB | 
    87.3k Rows
    Run SQL
    SELECT "fly_month", "passengers", "seats", "flights"
      FROM "mildbyte/complex_dataset:latest"."lax_flights"
      LIMIT 100;
    timestamp without time zone
    fly_month
    integer
    passengers
    integer
    seats
    integer
    flights
     
  • qoz_vote_fraction

    Preview
    1 Object
     | 107 kB | 
    3.11k Rows
    Run SQL
    SELECT "county_id", "qoz_tract_fraction", "trump_vote_fraction", "clinton_vote_fraction", "total_votes"
      FROM "mildbyte/complex_dataset:latest"."qoz_vote_fraction"
      LIMIT 100;
     
    text
    county_id
    numeric
    qoz_tract_fraction
    numeric
    trump_vote_fraction
    numeric
    clinton_vote_fraction
    numeric
    total_votes
     
  • total_flights

    Preview
    1 Object
     | 8429 bytes | 
    240 Rows
    Run SQL
    SELECT "fly_month", "jfk_passengers", "jfk_seats", "jfk_flights", "lax_passengers", "lax_seats", "lax_flights"
      FROM "mildbyte/complex_dataset:latest"."total_flights"
      LIMIT 100;
     
    timestamp without time zone
    fly_month
    bigint
    jfk_passengers
    bigint
    jfk_seats
    bigint
    jfk_flights
    bigint
    lax_passengers
    bigint
    lax_seats
    bigint
    lax_flights
     
  • total_flights_by_origin

    Preview
    8 Objects
     | 774 kB | 
    74.8k Rows
    Run SQL
    SELECT "fly_month", "origin_airport", "total_passengers", "total_seats", "total_flights"
      FROM "mildbyte/complex_dataset:latest"."total_flights_by_origin"
      LIMIT 100;
    timestamp without time zone
    fly_month
    character varying
    origin_airport
    bigint
    total_passengers
    bigint
    total_seats
    bigint
    total_flights
     
  • votes_by_county

    Preview
    1 Object
     | 98 kB | 
    3.11k Rows
    Run SQL
    SELECT "county_id", "trump_vote_fraction", "clinton_vote_fraction", "total_votes"
      FROM "mildbyte/complex_dataset:latest"."votes_by_county"
      LIMIT 100;
    text
    county_id
    numeric
    trump_vote_fraction
    numeric
    clinton_vote_fraction
    numeric
    total_votes
     
  • votes_by_state

    Preview
    1 Object
     | 6523 bytes | 
    793 Rows
    Run SQL
    SELECT "candidate_normalized", "state_postal", "sum"
      FROM "mildbyte/complex_dataset:latest"."votes_by_state"
      LIMIT 100;
    character varying
    candidate_normalized
    character varying
    state_postal
    numeric
    sum