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 = "USL00P" 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
9556986 9556986 20260322122915_jOZbv USL00P 2026-03-23T12:05:26.516Z 2026-03-30T12:29:18.133Z
9556899 9556899 20260322120821_D9rSr USL00P 2026-03-23T12:05:19.829Z 2026-03-30T12:29:14.376Z
9556844 9556844 20260322115407_44Oqj USL00P 2026-03-23T12:05:16.781Z 2026-03-30T12:29:12.761Z
9556838 9556838 20260322115331_61KO9 USL00P 2026-03-23T12:05:16.315Z 2026-03-30T12:29:12.400Z
9556836 9556836 20260322115256_dqGg5 USL00P 2026-03-23T12:05:16.052Z 2026-03-30T12:29:12.368Z
9556580 9556580 20260322111107_gzlDC USL00P 2026-03-23T12:04:58.579Z 2026-03-30T12:29:05.503Z
9556496 9556496 20260322104525_hchhf USL00P 2026-03-23T12:04:51.591Z 2026-03-30T12:29:02.694Z
9556197 9556197 20260322093230_BG44C USL00P 2026-03-23T12:04:27.938Z 2026-03-30T12:28:47.180Z
9556129 9556129 20260322092156_zXoYl USL00P 2026-03-23T12:04:22.885Z 2026-03-30T12:28:45.537Z
9555888 9555888 20260322083125_NEfVf USL00P 2026-03-23T12:04:06.000Z 2026-03-30T12:28:38.069Z
9555807 9555807 20260322080742_36dGy USL00P 2026-03-23T12:03:57.382Z 2026-03-30T12:28:35.995Z
9555805 9555805 20260322080648_HMkJl USL00P 2026-03-23T12:03:57.203Z 2026-03-30T12:28:35.938Z
9555714 9555714 20260322073806_zpx73 USL00P 2026-03-23T12:03:48.567Z 2026-03-30T12:28:32.809Z
9555655 9555655 20260322072029_z28c3 USL00P 2026-03-23T12:03:44.690Z 2026-03-30T12:28:31.531Z
9555542 9555542 20260322062016_fG2sL USL00P 2026-03-23T12:03:36.000Z 2026-03-30T12:28:28.898Z
9555477 9555477 20260322050755_ond8k USL00P 2026-03-23T12:03:28.276Z 2026-03-30T12:28:27.062Z
9287784 9287784 20260203131928_enWMp USL00P 2026-02-04T14:05:18.779Z 2026-02-12T14:51:11.995Z
9287741 9287741 20260203125811_X3CFT USL00P 2026-02-04T14:05:01.099Z 2026-02-12T14:51:08.680Z
9287720 9287720 20260203125407_OA5oS USL00P 2026-02-04T14:04:54.766Z 2026-02-12T14:51:06.838Z
9287685 9287685 20260203124051_Ocf58 USL00P 2026-02-04T14:04:40.702Z 2026-02-12T14:51:03.562Z
9287664 9287664 20260203122616_u6I9D USL00P 2026-02-04T14:04:32.034Z 2026-02-12T14:51:00.980Z
9287655 9287655 20260203122604_vANTp USL00P 2026-02-04T14:04:30.353Z 2026-02-12T14:51:00.638Z
9287597 9287597 20260203120804_whyyR USL00P 2026-02-04T14:04:08.781Z 2026-02-12T14:50:50.336Z
9287454 9287454 20260203103646_XE24x USL00P 2026-02-04T14:03:04.736Z 2026-02-12T14:50:35.930Z
9287446 9287446 20260203103242_DXa52 USL00P 2026-02-04T14:03:01.314Z 2026-02-12T14:50:35.171Z
9287444 9287444 20260203103208_hb3Ec USL00P 2026-02-04T14:03:00.259Z 2026-02-12T14:50:35.085Z
9287418 9287418 20260203101811_khX09 USL00P 2026-02-04T14:02:51.620Z 2026-02-12T14:50:33.442Z
9287378 9287378 20260203100414_wrd1C USL00P 2026-02-04T14:02:33.118Z 2026-02-12T14:50:25.190Z
9287366 9287366 20260203095717_jutfC USL00P 2026-02-04T14:02:27.962Z 2026-02-12T14:50:24.090Z
9287356 9287356 20260203095112_9eFT5 USL00P 2026-02-04T14:02:22.511Z 2026-02-12T14:50:22.820Z
9287336 9287336 20260203094250_UoWa3 USL00P 2026-02-04T14:02:13.357Z 2026-02-12T14:50:19.363Z
9287296 9287296 20260203092011_cDtJP USL00P 2026-02-04T14:01:56.435Z 2026-02-12T14:50:16.044Z
9287271 9287271 20260203091002_y7on6 USL00P 2026-02-04T14:01:46.513Z 2026-02-12T14:50:13.743Z
9287268 9287268 20260203091000_5jGRO USL00P 2026-02-04T14:01:45.464Z 2026-02-12T14:50:13.620Z
9286726 9286726 20260202131848_gdMTq USL00P 2026-02-03T14:02:47.915Z 2026-02-11T14:50:27.118Z
9286211 9286211 20260201021602_Pi6p5 USL00P 2026-02-02T14:11:18.190Z 2026-02-09T14:52:44.582Z
9285931 9285931 20260131130247_FrdLE USL00P 2026-02-02T14:07:51.532Z 2026-02-09T14:50:56.939Z
9282833 9282833 20260131121105_Thpof USL00P 2026-02-01T14:05:28.905Z 2026-02-09T14:50:38.229Z
9282708 9282708 20260131114358_nyZcw USL00P 2026-02-01T14:04:58.724Z 2026-02-09T14:50:30.062Z
9282702 9282702 20260131114336_eno1h USL00P 2026-02-01T14:04:57.464Z 2026-02-09T14:50:29.721Z
9282654 9282654 20260131113349_iNrB1 USL00P 2026-02-01T14:04:43.430Z 2026-02-09T14:50:26.437Z
9282151 9282151 20260131093413_mnc2Y USL00P 2026-02-01T14:02:23.665Z 2026-02-09T14:49:41.124Z
9282016 9282016 20260131084808_cGqhs USL00P 2026-02-01T14:01:41.215Z 2026-02-09T14:49:29.032Z
9281867 9281867 20260131063301_W3ion USL00P 2026-02-01T14:00:46.961Z 2026-02-09T14:49:11.521Z
9281834 9281834 20260131061807_9NZwV USL00P 2026-02-01T14:00:35.331Z 2026-02-09T14:49:09.351Z
9281347 9281347 20260130020552_f2zkL USL00P 2026-01-31T14:18:51.654Z 2026-02-07T14:54:28.551Z
9274988 9274988 20260129125826_jrN21 USL00P 2026-01-30T14:06:36.255Z 2026-02-07T14:50:48.050Z
9274688 9274688 20260129122535_13B23 USL00P 2026-01-30T14:05:26.206Z 2026-02-07T14:50:25.751Z
9274618 9274618 20260129122048_cwqjr USL00P 2026-01-30T14:05:11.504Z 2026-02-07T14:50:19.243Z
9274567 9274567 20260129121138_xitck USL00P 2026-01-30T14:04:52.619Z 2026-02-07T14:50:13.869Z
9274549 9274549 20260129120902_rhd1x USL00P 2026-01-30T14:04:46.918Z 2026-02-07T14:50:11.481Z
9274470 9274470 20260129115507_uS1nh USL00P 2026-01-30T14:04:27.925Z 2026-02-07T14:50:07.198Z
9274468 9274468 20260129115439_85t6t USL00P 2026-01-30T14:04:24.845Z 2026-02-07T14:50:07.063Z
9274448 9274448 20260129115021_SBFi9 USL00P 2026-01-30T14:04:18.148Z 2026-02-07T14:50:05.575Z
9274378 9274378 20260129113542_CsY2e USL00P 2026-01-30T14:03:59.180Z 2026-02-07T14:49:56.231Z
9274359 9274359 20260129113232_wIGF1 USL00P 2026-01-30T14:03:51.613Z 2026-02-07T14:49:53.230Z
9274115 9274115 20260129103832_fMuES USL00P 2026-01-30T14:02:53.254Z 2026-02-07T14:49:40.393Z
9273974 9273974 20260129100606_7hSmV USL00P 2026-01-30T14:02:09.477Z 2026-02-07T14:49:25.462Z
9273868 9273868 20260129094151_SN2sM USL00P 2026-01-30T14:01:41.439Z 2026-02-07T14:49:18.419Z
9273855 9273855 20260129093910_bOasP USL00P 2026-01-30T14:01:35.668Z 2026-02-07T14:49:17.834Z
9267880 9267880 20260127062650_r3kiS USL00P 2026-01-28T14:23:44.447Z 2026-02-04T14:50:03.446Z
9267873 9267873 20260127062239_fnoiN USL00P 2026-01-28T14:23:39.205Z 2026-02-04T14:50:02.917Z
9267867 9267867 20260127062106_4TCib USL00P 2026-01-28T14:23:38.083Z 2026-02-04T14:50:02.594Z
9267813 9267813 20260127051222_wXdp2 USL00P 2026-01-28T14:23:24.987Z 2026-02-04T14:49:56.747Z
9267811 9267811 20260127050827_DoDHv USL00P 2026-01-28T14:23:24.344Z 2026-02-04T14:49:56.567Z
9267797 9267797 20260127045952_o82Rx USL00P 2026-01-28T14:23:21.038Z 2026-02-04T14:49:55.441Z
9267785 9267785 20260127045633_qvgRj USL00P 2026-01-28T14:23:18.009Z 2026-02-04T14:49:54.397Z
9267782 9267782 20260127045632_pXmbF USL00P 2026-01-28T14:23:17.492Z 2026-02-04T14:49:54.130Z
9262886 9262886 20260126041724_6a7wd USL00P 2026-01-27T14:15:59.279Z 2026-02-03T14:46:21.816Z
9262877 9262877 20260126041200_cjoxO USL00P 2026-01-27T14:15:50.005Z 2026-02-03T14:46:21.029Z
9261749 9261749 20260126130703_pbFwb USL00P 2026-01-27T14:05:21.433Z 2026-02-04T14:47:08.214Z
9261677 9261677 20260126124639_9vofw USL00P 2026-01-27T14:05:04.164Z 2026-02-04T14:47:03.434Z
9261590 9261590 20260126122342_Ik9Ms USL00P 2026-01-27T14:04:30.934Z 2026-02-04T14:46:51.578Z
9261586 9261586 20260126122112_XGYDQ USL00P 2026-01-27T14:04:29.467Z 2026-02-04T14:46:51.183Z
9261557 9261557 20260126121407_BqlxX USL00P 2026-01-27T14:04:20.245Z 2026-02-04T14:46:49.672Z
9261488 9261488 20260126115216_hBAgX USL00P 2026-01-27T14:03:57.553Z 2026-02-04T14:46:43.924Z
9261469 9261469 20260126114857_KNM1o USL00P 2026-01-27T14:03:50.856Z 2026-02-04T14:46:42.878Z
9261465 9261465 20260126114834_yWz7C USL00P 2026-01-27T14:03:49.734Z 2026-02-04T14:46:42.386Z
9261255 9261255 20260126104852_cw5fj USL00P 2026-01-27T14:02:50.849Z 2026-02-04T14:46:25.555Z
9261239 9261239 20260126104126_EXoJq USL00P 2026-01-27T14:02:45.790Z 2026-02-04T14:46:24.160Z
9261209 9261209 20260126102728_gehtS USL00P 2026-01-27T14:02:34.298Z 2026-02-04T14:46:22.094Z
9261196 9261196 20260126102243_kop7X USL00P 2026-01-27T14:02:27.654Z 2026-02-04T14:46:19.572Z
9261143 9261143 20260126100020_Ili93 USL00P 2026-01-27T14:02:12.017Z 2026-02-04T14:46:15.631Z
9261131 9261131 20260126095740_hfz9O USL00P 2026-01-27T14:02:09.611Z 2026-02-04T14:46:15.143Z
9261091 9261091 20260126095100_JCFny USL00P 2026-01-27T14:01:51.107Z 2026-02-04T14:46:12.341Z
9261062 9261062 20260126093947_bhUVB USL00P 2026-01-27T14:01:41.835Z 2026-02-04T14:46:10.215Z
9261026 9261026 20260126092921_M01t2 USL00P 2026-01-27T14:01:29.509Z 2026-02-04T14:46:08.260Z
9261022 9261022 20260126092804_2Gtog USL00P 2026-01-27T14:01:28.101Z 2026-02-04T14:46:07.786Z
9260980 9260980 20260126090928_zC6ih USL00P 2026-01-27T14:01:14.263Z 2026-02-04T14:46:05.061Z
9260953 9260953 20260126090039_353Ed USL00P 2026-01-27T14:01:07.557Z 2026-02-04T14:45:59.650Z
9260865 9260865 20260126082441_fR2dA USL00P 2026-01-27T14:00:33.571Z 2026-02-04T14:45:52.888Z
9260853 9260853 20260126081352_MfgKv USL00P 2026-01-27T14:00:28.971Z 2026-02-04T14:45:52.296Z
9256197 9256197 20260124061734_ZZh9E USL00P 2026-01-25T14:16:10.910Z 2026-02-01T14:51:12.988Z
9255705 9255705 20260124043628_czxtS USL00P 2026-01-25T14:14:26.788Z 2026-02-01T14:50:47.359Z
9253456 9253456 20260124115919_BwhgP USL00P 2026-01-25T14:02:50.913Z 2026-02-02T14:46:26.055Z
9253452 9253452 20260124115310_biMfJ USL00P 2026-01-25T14:02:49.186Z 2026-02-02T14:46:25.767Z
9253090 9253090 20260124091538_pq3gW USL00P 2026-01-25T14:00:38.249Z 2026-02-02T14:45:52.675Z
9253038 9253038 20260124084505_T9fui USL00P 2026-01-25T14:00:15.733Z 2026-02-02T14:45:45.212Z
9237979 9237979 20260120064238_AgSMu USL00P 2026-01-21T14:28:10.960Z 2026-01-28T15:02:01.544Z
9237951 9237951 20260120063345_c7xa8 USL00P 2026-01-21T14:28:07.777Z 2026-01-28T15:02:00.360Z

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