home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

>10,000 rows count all where station_code = "USL01D" sorted by created_at descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

Link rowid meteor_unique_trajectory_identifier station_code created_at ▲ updated_at
8691482 8691482 20251205055938_Mxi3a USL01D 2025-12-06T14:17:53.377Z 2025-12-06T14:18:01.125Z
8687562 8687562 20251205073316_XzXGA USL01D 2025-12-06T14:00:46.208Z 2025-12-06T14:00:46.208Z
8687497 8687497 20251205065311_ntvJP USL01D 2025-12-06T14:00:29.972Z 2025-12-06T14:00:29.972Z
8687453 8687453 20251205062737_UVqgt USL01D 2025-12-06T14:00:18.205Z 2025-12-06T14:00:18.205Z
8687206 8687206 20251204054551_Ak3F3 USL01D 2025-12-05T14:14:23.734Z 2025-12-06T14:22:38.499Z
8676610 8676610 20251202060719_l120E USL01D 2025-12-03T14:25:21.717Z 2025-12-06T14:35:24.630Z
8676300 8676300 20251202054443_ELsuP USL01D 2025-12-03T14:24:58.123Z 2025-12-06T14:35:19.803Z
8675266 8675266 20251202042528_WJgxi USL01D 2025-12-03T14:23:25.295Z 2025-12-06T14:34:48.492Z
8674836 8674836 20251202032830_z33pM USL01D 2025-12-03T14:22:28.168Z 2025-12-06T14:34:20.224Z
8671861 8671861 20251201130925_5hA83 USL01D 2025-12-03T14:14:00.958Z 2025-12-06T14:31:23.866Z
8671851 8671851 20251201130657_2ji0d USL01D 2025-12-03T14:13:59.786Z 2025-12-06T14:31:22.733Z
8671836 8671836 20251201130414_3k5iO USL01D 2025-12-03T14:13:54.450Z 2025-12-06T14:31:21.413Z
8671801 8671801 20251201130112_2phFI USL01D 2025-12-03T14:13:49.369Z 2025-12-06T14:31:20.095Z
8671374 8671374 20251201120916_HMFNH USL01D 2025-12-03T14:12:17.045Z 2025-12-06T14:30:57.040Z
8671229 8671229 20251201114206_VyM6H USL01D 2025-12-03T14:11:51.985Z 2025-12-06T14:30:48.291Z
8671216 8671216 20251201113715_BwWAA USL01D 2025-12-03T14:11:47.581Z 2025-12-06T14:30:47.691Z
8671213 8671213 20251201113532_7GyDV USL01D 2025-12-03T14:11:47.057Z 2025-12-06T14:30:47.574Z
8671189 8671189 20251201113327_UPAlf USL01D 2025-12-03T14:11:41.547Z 2025-12-06T14:30:46.772Z
8671167 8671167 20251201112724_3QU73 USL01D 2025-12-03T14:11:39.120Z 2025-12-06T14:30:46.140Z
8671158 8671158 20251201112648_8yAzR USL01D 2025-12-03T14:11:28.310Z 2025-12-06T14:30:45.849Z
8671074 8671074 20251201111044_GegC4 USL01D 2025-12-03T14:11:12.890Z 2025-12-06T14:30:42.518Z
8671022 8671022 20251201110424_Rfy3e USL01D 2025-12-03T14:11:06.270Z 2025-12-06T14:30:40.078Z
8671009 8671009 20251201110116_5vbrg USL01D 2025-12-03T14:11:03.033Z 2025-12-06T14:30:39.375Z
8671005 8671005 20251201110113_trUkS USL01D 2025-12-03T14:11:02.654Z 2025-12-06T14:30:39.275Z
8670973 8670973 20251201105554_unqXI USL01D 2025-12-03T14:10:57.202Z 2025-12-06T14:30:38.410Z
8670946 8670946 20251201105128_kWfDu USL01D 2025-12-03T14:10:47.867Z 2025-12-06T14:30:37.471Z
8670941 8670941 20251201105014_Xg7xd USL01D 2025-12-03T14:10:47.237Z 2025-12-06T14:30:37.241Z
8670934 8670934 20251201104815_r90J7 USL01D 2025-12-03T14:10:45.550Z 2025-12-06T14:30:36.938Z
8670912 8670912 20251201104505_2DlZ1 USL01D 2025-12-03T14:10:41.679Z 2025-12-06T14:30:35.031Z
8670674 8670674 20251201095526_pTOgs USL01D 2025-12-03T14:09:43.783Z 2025-12-06T14:30:15.701Z
8670099 8670099 20251202130836_I2Jib USL01D 2025-12-03T14:06:54.374Z 2025-12-06T14:24:36.267Z
8670076 8670076 20251202130221_hd9hC USL01D 2025-12-03T14:06:44.390Z 2025-12-06T14:24:35.144Z
8670069 8670069 20251202130052_2u0zU USL01D 2025-12-03T14:06:40.062Z 2025-12-06T14:24:34.579Z
8669863 8669863 20251202121835_gxOsp USL01D 2025-12-03T14:05:51.809Z 2025-12-06T14:24:23.750Z
8669827 8669827 20251202121357_3vOml USL01D 2025-12-03T14:05:36.525Z 2025-12-06T14:24:22.067Z
8669790 8669790 20251202121144_ix3wQ USL01D 2025-12-03T14:05:27.485Z 2025-12-06T14:24:20.869Z
8669709 8669709 20251202120244_EAv53 USL01D 2025-12-03T14:05:14.183Z 2025-12-06T14:24:16.770Z
8669601 8669601 20251202114044_0xetL USL01D 2025-12-03T14:04:40.215Z 2025-12-06T14:24:05.421Z
8669542 8669542 20251202112857_5CZaS USL01D 2025-12-03T14:04:24.296Z 2025-12-06T14:24:00.279Z
8669519 8669519 20251202112501_lqPnv USL01D 2025-12-03T14:04:18.213Z 2025-12-06T14:23:59.238Z
8669509 8669509 20251202112254_J5XMS USL01D 2025-12-03T14:04:12.553Z 2025-12-06T14:23:58.723Z
8669463 8669463 20251202111507_wCPZk USL01D 2025-12-03T14:04:01.875Z 2025-12-06T14:23:56.324Z
8669400 8669400 20251202110824_ZONlg USL01D 2025-12-03T14:03:35.072Z 2025-12-06T14:23:52.160Z
8669223 8669223 20251202103409_v73uv USL01D 2025-12-03T14:02:54.074Z 2025-12-06T14:23:41.067Z
8668677 8668677 20251202081849_f1s2T USL01D 2025-12-03T14:00:48.526Z 2025-12-06T14:23:02.943Z
8668600 8668600 20251202075418_jxdNK USL01D 2025-12-03T14:00:32.188Z 2025-12-06T14:22:56.789Z
8668450 8668450 20251129051047_rX8FC USL01D 2025-12-02T14:48:27.500Z 2025-12-06T14:56:44.510Z
8668394 8668394 20251128114157_pciR0 USL01D 2025-12-02T14:43:27.142Z 2025-12-06T14:51:25.759Z
8668313 8668313 20251130071723_YlJvM USL01D 2025-12-02T14:42:18.089Z 2025-12-06T14:50:30.153Z
8668208 8668208 20251130064022_qiJvN USL01D 2025-12-02T14:42:11.243Z 2025-12-06T14:50:26.656Z
8668194 8668194 20251130063318_2dsj7 USL01D 2025-12-02T14:42:09.641Z 2025-12-06T14:50:26.054Z
8668175 8668175 20251130063043_Zt7Ue USL01D 2025-12-02T14:42:08.349Z 2025-12-06T14:50:25.587Z
8668063 8668063 20251130054731_jXVna USL01D 2025-12-02T14:41:33.215Z 2025-12-06T14:50:03.239Z
8667967 8667967 20251130052932_OKQaO USL01D 2025-12-02T14:41:24.321Z 2025-12-06T14:49:44.690Z
8667937 8667937 20251130051356_86ss1 USL01D 2025-12-02T14:41:20.016Z 2025-12-06T14:49:42.363Z
8667882 8667882 20251130045033_qztpv USL01D 2025-12-02T14:41:09.243Z 2025-12-06T14:49:33.759Z
8667876 8667876 20251130044625_moo8o USL01D 2025-12-02T14:40:53.161Z 2025-12-06T14:49:32.972Z
8667820 8667820 20251130041706_wpyv4 USL01D 2025-12-02T14:40:29.707Z 2025-12-06T14:49:27.514Z
8660615 8660615 20251130131533_aixdk USL01D 2025-12-02T14:08:31.112Z 2025-12-06T14:37:20.252Z
8660247 8660247 20251130121222_ZOaZA USL01D 2025-12-02T14:07:01.636Z 2025-12-06T14:36:57.876Z
8660167 8660167 20251130120130_rj2GU USL01D 2025-12-02T14:06:47.118Z 2025-12-06T14:36:54.146Z
8660151 8660151 20251130115935_E61e7 USL01D 2025-12-02T14:06:43.826Z 2025-12-06T14:36:53.803Z
8660102 8660102 20251130115547_T3Kkh USL01D 2025-12-02T14:06:30.255Z 2025-12-06T14:36:52.740Z
8660083 8660083 20251130115450_qZkdj USL01D 2025-12-02T14:06:28.137Z 2025-12-06T14:36:52.391Z
8660047 8660047 20251130114816_veHVf USL01D 2025-12-02T14:06:21.551Z 2025-12-06T14:36:51.230Z
8660024 8660024 20251130114307_Raxf2 USL01D 2025-12-02T14:06:15.313Z 2025-12-06T14:36:50.329Z
8659903 8659903 20251130112820_1WqxH USL01D 2025-12-02T14:05:46.261Z 2025-12-06T14:36:46.815Z
8659787 8659787 20251130111501_n532O USL01D 2025-12-02T14:05:17.903Z 2025-12-06T14:36:41.953Z
8659636 8659636 20251130105808_kiOSY USL01D 2025-12-02T14:04:41.609Z 2025-12-06T14:36:25.865Z
8659496 8659496 20251130103557_cIuYy USL01D 2025-12-02T14:04:10.502Z 2025-12-06T14:36:21.807Z
8659481 8659481 20251130103327_03u2E USL01D 2025-12-02T14:04:06.390Z 2025-12-06T14:36:20.007Z
8659396 8659396 20251130101946_ttwZS USL01D 2025-12-02T14:03:47.970Z 2025-12-06T14:36:17.242Z
8659380 8659380 20251130101705_CcW2Q USL01D 2025-12-02T14:03:45.105Z 2025-12-06T14:36:16.794Z
8659346 8659346 20251130101242_l4VV7 USL01D 2025-12-02T14:03:33.643Z 2025-12-06T14:36:15.445Z
8659314 8659314 20251130100813_3Fv3y USL01D 2025-12-02T14:03:27.712Z 2025-12-06T14:36:13.978Z
8659296 8659296 20251130100407_R2RLO USL01D 2025-12-02T14:03:23.904Z 2025-12-06T14:36:13.347Z
8659258 8659258 20251130095915_lyBnJ USL01D 2025-12-02T14:03:16.429Z 2025-12-06T14:36:12.393Z
8659252 8659252 20251130095856_HQszw USL01D 2025-12-02T14:03:14.848Z 2025-12-06T14:36:12.303Z
8659168 8659168 20251130094120_RTD7J USL01D 2025-12-02T14:02:47.724Z 2025-12-06T14:36:09.259Z
8659124 8659124 20251130093626_I0Apb USL01D 2025-12-02T14:02:41.220Z 2025-12-06T14:36:07.758Z
8659106 8659106 20251130093442_9MHaq USL01D 2025-12-02T14:02:34.932Z 2025-12-06T14:36:06.894Z
8659036 8659036 20251130092014_BPJdl USL01D 2025-12-02T14:02:19.225Z 2025-12-06T14:36:03.523Z
8658974 8658974 20251130090838_C2H0N USL01D 2025-12-02T14:01:58.077Z 2025-12-06T14:36:00.954Z
8658957 8658957 20251130090551_8hNxw USL01D 2025-12-02T14:01:49.155Z 2025-12-06T14:35:59.316Z
8658785 8658785 20251130080608_QrqDc USL01D 2025-12-02T14:00:50.806Z 2025-12-06T14:35:41.143Z
8658676 8658676 20251125063125_RGWS4 USL01D 2025-12-01T15:12:30.262Z 2025-12-02T15:09:36.972Z
8658346 8658346 20251127010450_tgoSU USL01D 2025-12-01T14:57:47.592Z 2025-12-05T15:03:59.139Z
8658290 8658290 20251127091849_5a8kv USL01D 2025-12-01T14:46:45.218Z 2025-12-06T14:57:57.698Z
8648392 8648392 20251129074214_bCHdP USL01D 2025-11-30T14:30:07.763Z 2025-12-06T14:57:36.647Z
8647804 8647804 20251129053501_GB0iZ USL01D 2025-11-30T14:28:57.379Z 2025-12-06T14:56:48.254Z
8647728 8647728 20251129051518_GqQw9 USL01D 2025-11-30T14:28:49.415Z 2025-12-06T14:56:45.367Z
8647248 8647248 20251129041230_zgPrn USL01D 2025-11-30T14:27:53.350Z 2025-12-06T14:56:34.590Z
8640206 8640206 20251129130610_8hhrE USL01D 2025-11-30T14:07:31.990Z 2025-12-06T14:44:03.477Z
8640181 8640181 20251129130245_Y7fud USL01D 2025-11-30T14:07:28.946Z 2025-12-06T14:44:00.375Z
8639934 8639934 20251129122610_FeddM USL01D 2025-11-30T14:06:32.292Z 2025-12-06T14:43:54.453Z
8639493 8639493 20251129111215_aE9UO USL01D 2025-11-30T14:05:08.332Z 2025-12-06T14:43:42.791Z
8639466 8639466 20251129110845_gqCM3 USL01D 2025-11-30T14:05:05.045Z 2025-12-06T14:43:42.494Z
8639422 8639422 20251129110452_WFUFj USL01D 2025-11-30T14:04:51.918Z 2025-12-06T14:43:41.438Z
8639246 8639246 20251129104828_fLzNM USL01D 2025-11-30T14:04:14.499Z 2025-12-06T14:43:36.921Z
8639226 8639226 20251129104434_O2tEk USL01D 2025-11-30T14:04:11.064Z 2025-12-06T14:43:36.574Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE participating_station
(
    meteor_unique_trajectory_identifier text     NOT NULL,
    station_code                        text     NOT NULL,
    created_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    updated_at                          datetime NOT NULL DEFAULT (
        strftime(
                '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc'
            )
        ),
    FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier),
    FOREIGN KEY (station_code) REFERENCES station (code),
    UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE
);
CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier);
CREATE INDEX participating_station_created_at_index ON participating_station (created_at);
CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network