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

3,370 rows where station_code = "USL00Z" 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
7807326 7807326 20250911113112_p7qIT USL00Z 2025-09-12T12:13:26.980Z 2025-09-19T12:57:45.950Z
7720787 7720787 20250830110836_Xn1na USL00Z 2025-09-01T12:40:30.207Z 2025-09-07T12:59:25.590Z
7717272 7717272 20250831063054_hxic3 USL00Z 2025-09-01T12:24:26.902Z 2025-09-08T12:53:27.835Z
7676761 7676761 20250827115023_jGDmC USL00Z 2025-08-29T12:04:30.131Z 2025-09-05T13:03:51.126Z
7676653 7676653 20250827112707_TeChE USL00Z 2025-08-29T12:04:06.049Z 2025-09-05T13:03:50.361Z
7676432 7676432 20250827103718_9XX12 USL00Z 2025-08-29T12:03:32.633Z 2025-09-05T13:03:47.355Z
7676193 7676193 20250827092438_TFr3P USL00Z 2025-08-29T12:02:49.601Z 2025-09-05T13:03:40.857Z
7652105 7652105 20250826084222_u9UpT USL00Z 2025-08-27T12:00:34.506Z 2025-09-04T12:55:00.764Z
7640186 7640186 20250824112014_P9usz USL00Z 2025-08-26T12:08:11.868Z 2025-09-02T12:50:52.739Z
7627416 7627416 20250824103047_CBYG6 USL00Z 2025-08-25T12:02:05.622Z 2025-09-02T12:50:50.890Z
7615963 7615963 20250823112452_qSrXy USL00Z 2025-08-24T12:03:30.516Z 2025-09-01T12:55:33.178Z
7615745 7615745 20250823092235_wZ9hJ USL00Z 2025-08-24T12:02:33.789Z 2025-09-01T12:55:26.617Z
7615681 7615681 20250823084932_b5GWZ USL00Z 2025-08-24T12:02:21.611Z 2025-09-01T12:55:25.251Z
7615596 7615596 20250823081003_q4YnS USL00Z 2025-08-24T12:01:56.787Z 2025-09-01T12:55:24.355Z
7615451 7615451 20250823070554_54qWj USL00Z 2025-08-24T12:01:12.568Z 2025-09-01T12:55:20.876Z
7615402 7615402 20250823064844_CX2IA USL00Z 2025-08-24T12:01:02.694Z 2025-09-01T12:55:20.105Z
7615284 7615284 20250823060041_iEP7F USL00Z 2025-08-24T12:00:29.066Z 2025-09-01T12:55:17.570Z
7606079 7606079 20250821111740_ACsEa USL00Z 2025-08-23T12:09:34.605Z 2025-08-30T12:59:00.137Z
7605896 7605896 20250821102616_qBGTp USL00Z 2025-08-23T12:08:49.465Z 2025-08-30T12:58:58.700Z
7605860 7605860 20250821101913_1EfXB USL00Z 2025-08-23T12:08:43.610Z 2025-08-30T12:58:58.236Z
7594717 7594717 20250820113132_wkvmR USL00Z 2025-08-22T12:11:14.633Z 2025-08-29T12:55:49.789Z
7594530 7594530 20250820111701_3FB8D USL00Z 2025-08-22T12:10:44.583Z 2025-08-29T12:55:48.908Z
7557331 7557331 20250817105623_GnFDG USL00Z 2025-08-19T12:36:44.168Z 2025-08-25T12:51:56.457Z
7557227 7557227 20250817103540_K2BQl USL00Z 2025-08-19T12:36:09.228Z 2025-08-25T12:51:56.130Z
7557046 7557046 20250817102128_MLGO2 USL00Z 2025-08-19T12:35:21.270Z 2025-08-25T12:51:55.660Z
7556310 7556310 20250817084752_NuZG4 USL00Z 2025-08-19T12:31:34.556Z 2025-08-25T12:51:53.490Z
7534088 7534088 20250816054153_WG2Gn USL00Z 2025-08-18T12:14:50.134Z 2025-08-24T12:47:53.327Z
7399817 7399817 20250806112408_JB5mt USL00Z 2025-08-08T12:26:51.308Z 2025-08-14T12:59:43.448Z
7398388 7398388 20250806085159_dSqyv USL00Z 2025-08-08T12:25:28.882Z 2025-08-14T12:59:21.505Z
7397369 7397369 20250806061650_BKslV USL00Z 2025-08-08T12:23:45.766Z 2025-08-14T12:59:06.152Z
7302468 7302468 20250801112438_QONFy USL00Z 2025-08-03T12:02:22.103Z 2025-08-10T12:57:35.586Z
7271087 7271087 20250730105849_3DG97 USL00Z 2025-08-01T12:01:48.383Z 2025-08-08T12:55:39.595Z
7271048 7271048 20250730105639_OGgIb USL00Z 2025-08-01T12:01:47.759Z 2025-08-08T12:55:39.525Z
7254142 7254142 20250729085204_zMJ6P USL00Z 2025-07-31T12:02:21.104Z 2025-08-07T12:48:11.088Z
7254109 7254109 20250729084823_Fn622 USL00Z 2025-07-31T12:02:19.052Z 2025-08-07T12:48:11.016Z
7253850 7253850 20250729081408_zZfUW USL00Z 2025-07-31T12:02:03.993Z 2025-08-07T12:48:09.297Z
7252959 7252959 20250729064118_pIgln USL00Z 2025-07-31T12:00:58.453Z 2025-08-07T12:48:03.532Z
7234914 7234914 20250728053910_EqzJE USL00Z 2025-07-30T12:00:22.686Z 2025-08-06T12:34:23.144Z
7223299 7223299 20250727095127_HZH1H USL00Z 2025-07-29T12:11:40.330Z 2025-08-05T12:39:10.615Z
7222825 7222825 20250727085912_9iFbN USL00Z 2025-07-29T12:10:21.272Z 2025-08-05T12:39:09.641Z
7222599 7222599 20250727083724_i8kTR USL00Z 2025-07-29T12:10:01.480Z 2025-08-05T12:39:08.708Z
7222512 7222512 20250727082836_FTwDj USL00Z 2025-07-29T12:09:40.108Z 2025-08-05T12:39:08.459Z
7222437 7222437 20250727081927_mvHC2 USL00Z 2025-07-29T12:09:27.061Z 2025-08-05T12:39:06.777Z
7222288 7222288 20250727080502_gdWVm USL00Z 2025-07-29T12:09:12.483Z 2025-08-05T12:39:06.463Z
7192550 7192550 20250725102500_8wyN1 USL00Z 2025-07-27T12:12:07.089Z 2025-08-03T13:04:12.285Z
7192528 7192528 20250725102215_G2v2t USL00Z 2025-07-27T12:12:05.477Z 2025-08-03T13:04:12.239Z
7192050 7192050 20250725094814_n8W3R USL00Z 2025-07-27T12:11:05.226Z 2025-08-03T13:04:10.449Z
7162267 7162267 20250724105334_c55Tv USL00Z 2025-07-25T12:00:19.560Z 2025-08-01T12:15:55.012Z
7132207 7132207 20250721085046_NgexF USL00Z 2025-07-22T12:01:10.667Z 2025-07-29T12:47:41.016Z
6966011 6966011 20250624095346_1uk7h USL00Z 2025-06-25T12:19:42.297Z 2025-07-02T12:49:22.154Z
6958425 6958425 20250623103947_7Hl3j USL00Z 2025-06-24T12:26:55.340Z 2025-07-01T12:54:20.150Z
6950175 6950175 20250622093513_oitQx USL00Z 2025-06-23T12:28:54.665Z 2025-06-30T12:36:00.837Z
6949618 6949618 20250622075532_1nLN2 USL00Z 2025-06-23T12:27:50.473Z 2025-06-30T12:35:59.465Z
6937347 6937347 20250621062349_LmCol USL00Z 2025-06-22T12:17:02.417Z 2025-06-29T12:36:50.609Z
6937135 6937135 20250621052348_4EiZR USL00Z 2025-06-22T12:16:25.350Z 2025-06-29T12:36:47.863Z
6916998 6916998 20250619101557_GglHy USL00Z 2025-06-20T12:00:40.889Z 2025-06-28T12:40:08.203Z
6916983 6916983 20250619101040_awdw3 USL00Z 2025-06-20T12:00:37.929Z 2025-06-28T12:40:08.138Z
6912328 6912328 20250618101859_22ayq USL00Z 2025-06-19T12:02:13.699Z 2025-06-27T12:39:17.048Z
6911844 6911844 20250618082520_EhA82 USL00Z 2025-06-19T12:00:25.898Z 2025-06-27T12:39:11.379Z
6904838 6904838 20250617095545_yEK32 USL00Z 2025-06-18T12:04:10.572Z 2025-06-26T12:36:22.736Z
6904577 6904577 20250617092223_DPZfq USL00Z 2025-06-18T12:03:24.945Z 2025-06-26T12:36:22.011Z
6904430 6904430 20250617085959_rDYG2 USL00Z 2025-06-18T12:02:53.517Z 2025-06-26T12:36:21.502Z
6893890 6893890 20250615085252_ENXkk USL00Z 2025-06-16T12:02:16.953Z 2025-06-24T12:58:36.634Z
6881982 6881982 20250611092406_2SoP3 USL00Z 2025-06-12T12:02:46.476Z 2025-06-20T12:53:13.022Z
6879481 6879481 20250610084143_s9tYN USL00Z 2025-06-11T12:01:03.702Z 2025-06-18T12:41:05.886Z
6879352 6879352 20250610050958_jtIJv USL00Z 2025-06-11T12:00:36.698Z 2025-06-18T12:40:59.637Z
6874181 6874181 20250608082724_UX5AI USL00Z 2025-06-09T12:04:20.983Z 2025-06-16T12:25:35.644Z
6874153 6874153 20250608082258_5Bqqr USL00Z 2025-06-09T12:04:14.510Z 2025-06-16T12:25:34.986Z
6867044 6867044 20250606111814_MmcRA USL00Z 2025-06-07T12:08:07.129Z 2025-06-14T12:29:12.621Z
6867004 6867004 20250606110940_0w8CQ USL00Z 2025-06-07T12:08:01.130Z 2025-06-14T12:29:11.829Z
6725500 6725500 20250515075933_WR8uT USL00Z 2025-05-16T12:06:56.783Z 2025-05-23T12:36:28.267Z
6708322 6708322 20250511094343_INWwd USL00Z 2025-05-12T12:10:09.464Z 2025-05-19T12:37:08.984Z
6708296 6708296 20250511093529_3x0jo USL00Z 2025-05-12T12:10:06.352Z 2025-05-19T12:37:08.443Z
6708109 6708109 20250511083825_NWfRG USL00Z 2025-05-12T12:09:36.778Z 2025-05-19T12:37:03.244Z
6701988 6701988 20250510111045_xHdTl USL00Z 2025-05-11T12:13:22.553Z 2025-05-18T12:34:48.008Z
6701863 6701863 20250510105354_yISzr USL00Z 2025-05-11T12:13:00.242Z 2025-05-18T12:34:44.183Z
6701853 6701853 20250510105257_tKQIE USL00Z 2025-05-11T12:12:59.135Z 2025-05-18T12:34:43.842Z
6701777 6701777 20250510104127_RQJMy USL00Z 2025-05-11T12:12:52.487Z 2025-05-18T12:34:40.227Z
6701534 6701534 20250510100026_aOclS USL00Z 2025-05-11T12:12:22.604Z 2025-05-18T12:34:35.563Z
6694565 6694565 20250509113111_WpdOG USL00Z 2025-05-10T12:15:44.848Z 2025-05-17T12:36:37.923Z
6694263 6694263 20250509105837_uM2ip USL00Z 2025-05-10T12:15:18.494Z 2025-05-17T12:36:33.749Z
6693802 6693802 20250509100206_A7prX USL00Z 2025-05-10T12:14:40.839Z 2025-05-17T12:36:22.885Z
6692987 6692987 20250509063802_njy9G USL00Z 2025-05-10T12:12:57.617Z 2025-05-17T12:36:10.900Z
6688379 6688379 20250508113157_3oBbQ USL00Z 2025-05-09T12:16:08.799Z 2025-05-16T12:35:29.968Z
6688063 6688063 20250508104217_R3NDm USL00Z 2025-05-09T12:15:27.774Z 2025-05-16T12:35:26.257Z
6688060 6688060 20250508104208_iYd1r USL00Z 2025-05-09T12:15:26.815Z 2025-05-16T12:35:26.208Z
6688030 6688030 20250508103727_XWsS3 USL00Z 2025-05-09T12:15:23.391Z 2025-05-16T12:35:26.039Z
6687942 6687942 20250508102524_RNtOK USL00Z 2025-05-09T12:15:12.518Z 2025-05-16T12:35:25.356Z
6687702 6687702 20250508095412_HHrpE USL00Z 2025-05-09T12:14:57.277Z 2025-05-16T12:35:21.327Z
6687692 6687692 20250508095153_yH3BY USL00Z 2025-05-09T12:14:56.643Z 2025-05-16T12:35:21.116Z
6687646 6687646 20250508093846_4WxC4 USL00Z 2025-05-09T12:14:52.754Z 2025-05-16T12:35:20.731Z
6687593 6687593 20250508092636_LJy2P USL00Z 2025-05-09T12:14:40.973Z 2025-05-16T12:35:20.112Z
6687530 6687530 20250508085939_jPzEU USL00Z 2025-05-09T12:14:34.285Z 2025-05-16T12:35:19.136Z
6687479 6687479 20250508084132_WKXJR USL00Z 2025-05-09T12:14:29.244Z 2025-05-16T12:35:17.651Z
6687399 6687399 20250508081452_JgKgo USL00Z 2025-05-09T12:14:07.406Z 2025-05-16T12:35:16.861Z
6680740 6680740 20250507111731_iRc9B USL00Z 2025-05-08T12:19:44.628Z 2025-05-15T12:38:20.148Z
6680625 6680625 20250507110301_r4lPm USL00Z 2025-05-08T12:19:38.992Z 2025-05-15T12:38:17.829Z
6680493 6680493 20250507103912_TQwwS USL00Z 2025-05-08T12:19:31.806Z 2025-05-15T12:38:15.308Z
6680434 6680434 20250507102802_LLrEK USL00Z 2025-05-08T12:19:28.678Z 2025-05-15T12:38:14.161Z
6680383 6680383 20250507101919_awcgm USL00Z 2025-05-08T12:19:20.750Z 2025-05-15T12:38:13.054Z

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