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 = "USL01B" 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
8687266 8687266 20251204063353_77JUO USL01B 2025-12-05T14:14:33.183Z 2025-12-05T14:14:35.673Z
8684207 8684207 20251204112018_17WSX USL01B 2025-12-05T14:02:10.707Z 2025-12-05T14:02:10.707Z
8684167 8684167 20251204110431_Nl21x USL01B 2025-12-05T14:02:04.738Z 2025-12-05T14:02:04.738Z
8683875 8683875 20251204090931_cRr8b USL01B 2025-12-05T14:00:58.091Z 2025-12-05T14:00:58.091Z
8683736 8683736 20251204072956_gp8ET USL01B 2025-12-05T14:00:23.566Z 2025-12-05T14:00:23.566Z
8683687 8683687 20251204064816_gqlYX USL01B 2025-12-05T14:00:11.146Z 2025-12-05T14:00:11.146Z
8683681 8683681 20251204064430_Ia2vM USL01B 2025-12-05T14:00:08.974Z 2025-12-05T14:00:08.974Z
8677216 8677216 20251203071613_ovyPm USL01B 2025-12-04T14:00:23.180Z 2025-12-05T14:14:34.766Z
8677032 8677032 20251202064124_HrG7L USL01B 2025-12-03T14:26:12.662Z 2025-12-05T14:29:18.856Z
8675501 8675501 20251202045015_ANhTR USL01B 2025-12-03T14:23:47.601Z 2025-12-05T14:28:33.951Z
8675171 8675171 20251202041107_fu2Nm USL01B 2025-12-03T14:23:14.777Z 2025-12-05T14:28:14.135Z
8671886 8671886 20251201131340_ynSYJ USL01B 2025-12-03T14:14:05.578Z 2025-12-05T14:24:58.364Z
8671821 8671821 20251201130302_4bcVE USL01B 2025-12-03T14:13:52.720Z 2025-12-05T14:24:55.520Z
8671697 8671697 20251201125005_eGKWv USL01B 2025-12-03T14:13:21.317Z 2025-12-05T14:24:40.915Z
8671619 8671619 20251201124320_zni24 USL01B 2025-12-03T14:13:11.197Z 2025-12-05T14:24:37.750Z
8671614 8671614 20251201124256_HxeeF USL01B 2025-12-03T14:13:10.829Z 2025-12-05T14:24:37.646Z
8671514 8671514 20251201122849_z9PwM USL01B 2025-12-03T14:12:53.121Z 2025-12-05T14:24:32.496Z
8671414 8671414 20251201121403_SEk5v USL01B 2025-12-03T14:12:25.292Z 2025-12-05T14:24:27.876Z
8671394 8671394 20251201121206_xTCuE USL01B 2025-12-03T14:12:19.798Z 2025-12-05T14:24:26.730Z
8671333 8671333 20251201120242_ZXy2x USL01B 2025-12-03T14:12:11.190Z 2025-12-05T14:24:24.427Z
8671259 8671259 20251201114742_MxY5O USL01B 2025-12-03T14:11:56.497Z 2025-12-05T14:24:20.362Z
8671171 8671171 20251201113131_ycdHw USL01B 2025-12-03T14:11:39.989Z 2025-12-05T14:24:16.683Z
8671133 8671133 20251201112027_O4IQ1 USL01B 2025-12-03T14:11:19.762Z 2025-12-05T14:24:06.852Z
8671128 8671128 20251201111857_zaT9t USL01B 2025-12-03T14:11:18.641Z 2025-12-05T14:24:06.557Z
8671125 8671125 20251201111854_ZiAUf USL01B 2025-12-03T14:11:18.278Z 2025-12-05T14:24:06.454Z
8670936 8670936 20251201104847_MOnHK USL01B 2025-12-03T14:10:46.180Z 2025-12-05T14:23:56.463Z
8670846 8670846 20251201103124_2rXou USL01B 2025-12-03T14:10:31.746Z 2025-12-05T14:23:52.865Z
8670112 8670112 20251202131115_G1k7T USL01B 2025-12-03T14:06:57.060Z 2025-12-05T14:18:12.425Z
8670042 8670042 20251202125505_lyss2 USL01B 2025-12-03T14:06:35.535Z 2025-12-05T14:18:07.686Z
8670024 8670024 20251202124703_DOekc USL01B 2025-12-03T14:06:31.256Z 2025-12-05T14:18:06.158Z
8669983 8669983 20251202123915_6VGri USL01B 2025-12-03T14:06:18.645Z 2025-12-05T14:18:03.411Z
8669969 8669969 20251202123835_7uMT2 USL01B 2025-12-03T14:06:13.524Z 2025-12-05T14:18:03.027Z
8669952 8669952 20251202123311_n8Ghk USL01B 2025-12-03T14:06:07.413Z 2025-12-05T14:17:59.623Z
8669950 8669950 20251202123140_uZDNP USL01B 2025-12-03T14:06:06.909Z 2025-12-05T14:17:59.491Z
8669940 8669940 20251202123041_XtBjB USL01B 2025-12-03T14:06:05.653Z 2025-12-05T14:17:59.155Z
8669927 8669927 20251202122927_lfTTp USL01B 2025-12-03T14:06:03.696Z 2025-12-05T14:17:58.699Z
8669906 8669906 20251202122516_Ess47 USL01B 2025-12-03T14:06:00.026Z 2025-12-05T14:17:57.313Z
8669899 8669899 20251202122346_A72Cf USL01B 2025-12-03T14:05:57.857Z 2025-12-05T14:17:56.450Z
8669837 8669837 20251202121544_3zTIK USL01B 2025-12-03T14:05:48.423Z 2025-12-05T14:17:51.563Z
8669829 8669829 20251202121424_RRwL3 USL01B 2025-12-03T14:05:37.124Z 2025-12-05T14:17:50.864Z
8669754 8669754 20251202120753_U1hF8 USL01B 2025-12-03T14:05:21.415Z 2025-12-05T14:17:45.671Z
8669691 8669691 20251202115909_4Le47 USL01B 2025-12-03T14:05:10.822Z 2025-12-05T14:17:42.061Z
8669678 8669678 20251202115636_G6dqa USL01B 2025-12-03T14:04:55.982Z 2025-12-05T14:17:40.872Z
8669671 8669671 20251202115542_2aYMu USL01B 2025-12-03T14:04:54.681Z 2025-12-05T14:17:40.326Z
8669625 8669625 20251202114347_dBMxW USL01B 2025-12-03T14:04:44.175Z 2025-12-05T14:17:35.834Z
8669611 8669611 20251202114212_VrZGK USL01B 2025-12-03T14:04:41.850Z 2025-12-05T14:17:35.324Z
8669607 8669607 20251202114156_NN3pm USL01B 2025-12-03T14:04:41.362Z 2025-12-05T14:17:35.098Z
8669590 8669590 20251202113849_jVw1t USL01B 2025-12-03T14:04:38.504Z 2025-12-05T14:17:34.398Z
8669565 8669565 20251202113137_Kcvhi USL01B 2025-12-03T14:04:32.789Z 2025-12-05T14:17:30.854Z
8669556 8669556 20251202113058_mCpFq USL01B 2025-12-03T14:04:31.191Z 2025-12-05T14:17:30.619Z
8669521 8669521 20251202112557_x6W4d USL01B 2025-12-03T14:04:18.661Z 2025-12-05T14:17:28.170Z
8669502 8669502 20251202112234_dZq0r USL01B 2025-12-03T14:04:11.362Z 2025-12-05T14:17:26.817Z
8669494 8669494 20251202112100_ThBy1 USL01B 2025-12-03T14:04:09.171Z 2025-12-05T14:17:25.083Z
8669420 8669420 20251202111003_8ICMq USL01B 2025-12-03T14:03:40.938Z 2025-12-05T14:17:20.150Z
8669382 8669382 20251202110254_8Fzsn USL01B 2025-12-03T14:03:30.905Z 2025-12-05T14:17:17.026Z
8669342 8669342 20251202105603_iJ8hV USL01B 2025-12-03T14:03:24.921Z 2025-12-05T14:17:09.743Z
8669245 8669245 20251202103844_kFOg3 USL01B 2025-12-03T14:03:01.137Z 2025-12-05T14:17:01.270Z
8669194 8669194 20251202102947_1f9lq USL01B 2025-12-03T14:02:49.372Z 2025-12-05T14:16:57.177Z
8669166 8669166 20251202102657_QSaQY USL01B 2025-12-03T14:02:46.443Z 2025-12-05T14:16:56.060Z
8669129 8669129 20251202101700_4UI7g USL01B 2025-12-03T14:02:40.642Z 2025-12-05T14:16:53.417Z
8669092 8669092 20251202101111_jF83B USL01B 2025-12-03T14:02:22.575Z 2025-12-05T14:16:50.269Z
8669070 8669070 20251202100759_YNibN USL01B 2025-12-03T14:02:13.110Z 2025-12-05T14:16:48.415Z
8669054 8669054 20251202100315_E7wIG USL01B 2025-12-03T14:02:09.985Z 2025-12-05T14:16:47.369Z
8669016 8669016 20251202095219_JfLpm USL01B 2025-12-03T14:02:00.787Z 2025-12-05T14:16:43.593Z
8668995 8668995 20251202095012_yUZkT USL01B 2025-12-03T14:01:57.915Z 2025-12-05T14:16:40.224Z
8668937 8668937 20251202093210_XxUdK USL01B 2025-12-03T14:01:37.919Z 2025-12-05T14:16:16.766Z
8668913 8668913 20251202092330_7RemL USL01B 2025-12-03T14:01:35.357Z 2025-12-05T14:16:04.629Z
8668887 8668887 20251202091746_8uzKZ USL01B 2025-12-03T14:01:31.915Z 2025-12-05T14:15:48.938Z
8668873 8668873 20251202091527_6QeVh USL01B 2025-12-03T14:01:30.665Z 2025-12-05T14:15:46.691Z
8668813 8668813 20251202090334_45Go3 USL01B 2025-12-03T14:01:21.995Z 2025-12-05T14:15:31.197Z
8668777 8668777 20251202085829_Hxe4y USL01B 2025-12-03T14:01:12.754Z 2025-12-05T14:15:21.651Z
8668751 8668751 20251202085109_wFCji USL01B 2025-12-03T14:01:01.845Z 2025-12-05T14:15:12.646Z
8668734 8668734 20251202084346_yIg4A USL01B 2025-12-03T14:00:58.921Z 2025-12-05T14:15:08.700Z
8668725 8668725 20251202084119_5m5wj USL01B 2025-12-03T14:00:57.401Z 2025-12-05T14:15:07.625Z
8668708 8668708 20251202083511_KddC5 USL01B 2025-12-03T14:00:54.192Z 2025-12-05T14:15:04.466Z
8668687 8668687 20251202082232_HY0R9 USL01B 2025-12-03T14:00:50.637Z 2025-12-05T14:14:59.779Z
8668641 8668641 20251202080514_C2ikD USL01B 2025-12-03T14:00:38.741Z 2025-12-05T14:14:48.436Z
8668606 8668606 20251202075706_Vf24j USL01B 2025-12-03T14:00:32.670Z 2025-12-05T14:14:46.211Z
8668549 8668549 20251202073033_PAxfR USL01B 2025-12-03T14:00:18.525Z 2025-12-05T14:14:39.321Z
8668535 8668535 20251202072712_K3iae USL01B 2025-12-03T14:00:15.752Z 2025-12-05T14:14:38.659Z
8668527 8668527 20251202072559_1yoFS USL01B 2025-12-03T14:00:14.616Z 2025-12-05T14:14:38.403Z
8668524 8668524 20251202072501_oJ3BH USL01B 2025-12-03T14:00:13.599Z 2025-12-05T14:14:38.249Z
8668504 8668504 20251128011954_Oqngn USL01B 2025-12-02T14:53:41.134Z 2025-12-05T14:58:25.308Z
8668364 8668364 20251130074219_9N3WL USL01B 2025-12-02T14:42:20.933Z 2025-12-05T14:46:07.372Z
8668344 8668344 20251130072747_tnClC USL01B 2025-12-02T14:42:19.819Z 2025-12-05T14:46:06.929Z
8668336 8668336 20251130072708_JU7k7 USL01B 2025-12-02T14:42:19.713Z 2025-12-05T14:46:06.898Z
8668332 8668332 20251130072543_cy3ss USL01B 2025-12-02T14:42:19.504Z 2025-12-05T14:46:06.786Z
8668288 8668288 20251130071034_xbwOm USL01B 2025-12-02T14:42:17.078Z 2025-12-05T14:46:05.982Z
8668283 8668283 20251130070839_HHWKG USL01B 2025-12-02T14:42:16.728Z 2025-12-05T14:46:05.861Z
8668270 8668270 20251130070359_CJMfK USL01B 2025-12-02T14:42:15.406Z 2025-12-05T14:46:05.354Z
8668197 8668197 20251130063559_wfLE4 USL01B 2025-12-02T14:42:10.263Z 2025-12-05T14:46:01.942Z
8668172 8668172 20251130062940_xBa2U USL01B 2025-12-02T14:42:07.900Z 2025-12-05T14:46:00.810Z
8668154 8668154 20251130062049_yiLd3 USL01B 2025-12-02T14:42:05.647Z 2025-12-05T14:45:58.987Z
8668119 8668119 20251130061100_3XSBl USL01B 2025-12-02T14:42:02.680Z 2025-12-05T14:45:42.108Z
8668092 8668092 20251130060109_DTrHj USL01B 2025-12-02T14:42:00.458Z 2025-12-05T14:45:35.682Z
8668031 8668031 20251130054102_wDPHd USL01B 2025-12-02T14:41:30.723Z 2025-12-05T14:45:29.061Z
8667544 8667544 20251130020735_fLKqU USL01B 2025-12-02T14:38:49.297Z 2025-12-05T14:43:26.084Z
8660611 8660611 20251130131353_vJzov USL01B 2025-12-02T14:08:26.365Z 2025-12-05T14:31:16.291Z
8660573 8660573 20251130130702_HeceM USL01B 2025-12-02T14:08:18.106Z 2025-12-05T14:31:15.115Z
8660561 8660561 20251130130410_yacmH USL01B 2025-12-02T14:08:17.259Z 2025-12-05T14:31:14.770Z

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