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

4,685 rows where station_code = "NL000D" 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
9610757 9610757 20260404213457_0163z NL000D 2026-04-06T12:11:06.223Z 2026-04-06T12:16:14.653Z
9607057 9607057 20260404032108_CNE8E NL000D 2026-04-05T12:00:16.649Z 2026-04-06T12:16:14.352Z
9606939 9606939 20260403002747_J5JFV NL000D 2026-04-04T12:12:24.260Z 2026-04-06T12:23:57.786Z
9606935 9606935 20260403002727_axUeJ NL000D 2026-04-04T12:12:23.185Z 2026-04-06T12:23:57.471Z
9606933 9606933 20260403002524_wmZG1 NL000D 2026-04-04T12:12:21.644Z 2026-04-06T12:23:57.314Z
9606922 9606922 20260403001624_wunpr NL000D 2026-04-04T12:12:18.333Z 2026-04-06T12:23:56.509Z
9606896 9606896 20260402232012_pc5Mz NL000D 2026-04-04T12:12:11.439Z 2026-04-06T12:23:54.635Z
9606891 9606891 20260402230828_sQ4WN NL000D 2026-04-04T12:12:10.207Z 2026-04-06T12:23:54.272Z
9606772 9606772 20260402204936_qVXSG NL000D 2026-04-04T12:11:34.122Z 2026-04-06T12:23:40.647Z
9602593 9602593 20260401000712_RdLYq NL000D 2026-04-02T12:09:28.298Z 2026-04-06T12:29:24.974Z
9602577 9602577 20260331235206_Y9dRe NL000D 2026-04-02T12:09:24.631Z 2026-04-06T12:29:24.130Z
9602452 9602452 20260331211658_z18Kp NL000D 2026-04-02T12:08:55.662Z 2026-04-06T12:29:09.945Z
9600587 9600587 20260330234507_9NiDL NL000D 2026-04-01T12:11:15.915Z 2026-04-06T12:33:41.342Z
9600531 9600531 20260330231446_beXaD NL000D 2026-04-01T12:11:05.946Z 2026-04-06T12:33:32.769Z
9594828 9594828 20260329003922_8QbeC NL000D 2026-03-30T12:10:23.992Z 2026-04-06T12:40:17.372Z
9592317 9592317 20260329015222_o08gD NL000D 2026-03-30T12:00:40.173Z 2026-04-06T12:34:00.388Z
9588369 9588369 20260326221051_qx3oy NL000D 2026-03-28T12:10:57.462Z 2026-04-04T12:42:01.729Z
9588358 9588358 20260326220608_42qt5 NL000D 2026-03-28T12:10:56.611Z 2026-04-04T12:42:01.028Z
9585796 9585796 20260327023412_SzsEM NL000D 2026-03-28T12:01:21.561Z 2026-04-05T12:32:45.961Z
9585728 9585728 20260327021659_djMMW NL000D 2026-03-28T12:01:09.293Z 2026-04-05T12:32:36.593Z
9585212 9585212 20260325234131_RxOFn NL000D 2026-03-27T12:16:54.602Z 2026-04-03T12:39:51.489Z
9585114 9585114 20260325233215_6ykXO NL000D 2026-03-27T12:16:46.337Z 2026-04-03T12:39:49.909Z
9584540 9584540 20260325203222_vtQ1w NL000D 2026-03-27T12:15:36.422Z 2026-04-03T12:39:19.161Z
9581871 9581871 20260326040413_30xGN NL000D 2026-03-27T12:04:00.910Z 2026-04-04T12:39:23.660Z
9579516 9579516 20260324211054_LnPTD NL000D 2026-03-26T12:13:51.343Z 2026-04-02T12:37:13.374Z
9579384 9579384 20260324193552_T2xZH NL000D 2026-03-26T12:13:31.468Z 2026-04-02T12:37:07.315Z
9571109 9571109 20260322234616_Hy7u8 NL000D 2026-03-24T12:24:21.005Z 2026-03-30T12:30:55.319Z
9571042 9571042 20260322234050_l23I7 NL000D 2026-03-24T12:24:12.267Z 2026-03-30T12:30:54.408Z
9570917 9570917 20260322231234_AdlFW NL000D 2026-03-24T12:24:01.789Z 2026-03-30T12:30:52.062Z
9570839 9570839 20260322225748_BSywJ NL000D 2026-03-24T12:23:53.945Z 2026-03-30T12:30:50.222Z
9570431 9570431 20260322212027_DRDId NL000D 2026-03-24T12:23:16.446Z 2026-03-30T12:30:42.771Z
9570397 9570397 20260322210753_S8EJC NL000D 2026-03-24T12:23:09.305Z 2026-03-30T12:30:41.827Z
9562226 9562226 20260323015143_Deo1D NL000D 2026-03-24T12:02:31.230Z 2026-03-31T12:26:04.384Z
9562214 9562214 20260323015112_lk5Fv NL000D 2026-03-24T12:02:29.001Z 2026-03-31T12:26:04.041Z
9561958 9561958 20260323010215_8nAzf NL000D 2026-03-24T12:01:41.649Z 2026-03-31T12:25:57.435Z
9561635 9561635 20260323001657_V0Zuo NL000D 2026-03-24T12:00:44.990Z 2026-03-31T12:25:49.171Z
9561598 9561598 20260323000801_4G3c0 NL000D 2026-03-24T12:00:36.011Z 2026-03-31T12:25:48.098Z
9559634 9559634 20260321185352_w5IsK NL000D 2026-03-23T12:11:16.503Z 2026-03-29T12:20:42.255Z
9555193 9555193 20260322041526_M4ZUD NL000D 2026-03-23T12:03:14.563Z 2026-03-30T12:28:22.718Z
9555018 9555018 20260322035525_sK05x NL000D 2026-03-23T12:03:02.960Z 2026-03-30T12:28:13.304Z
9554553 9554553 20260322031711_5yTOv NL000D 2026-03-23T12:02:40.268Z 2026-03-30T12:28:05.480Z
9554305 9554305 20260322025655_LbmpG NL000D 2026-03-23T12:02:25.424Z 2026-03-30T12:28:02.023Z
9553683 9553683 20260322020554_lI69O NL000D 2026-03-23T12:01:45.806Z 2026-03-30T12:27:50.937Z
9553541 9553541 20260322014900_mOOKd NL000D 2026-03-23T12:01:37.291Z 2026-03-30T12:27:44.427Z
9552905 9552905 20260322005337_lob2V NL000D 2026-03-23T12:00:58.906Z 2026-03-30T12:27:31.958Z
9530737 9530737 20260318213429_bsNeI NL000D 2026-03-20T12:24:45.007Z 2026-03-26T12:39:15.094Z
9530481 9530481 20260318210117_mIhlr NL000D 2026-03-20T12:24:26.081Z 2026-03-26T12:39:12.876Z
9530327 9530327 20260318203914_20Au9 NL000D 2026-03-20T12:24:18.406Z 2026-03-26T12:39:11.360Z
9519693 9519693 20260319022842_DLRZA NL000D 2026-03-20T12:04:55.751Z 2026-03-27T12:40:34.424Z
9519277 9519277 20260319015848_7nsRL NL000D 2026-03-20T12:04:13.985Z 2026-03-27T12:40:19.745Z
9519086 9519086 20260319014636_I3REc NL000D 2026-03-20T12:03:52.876Z 2026-03-27T12:40:17.960Z
9518830 9518830 20260319012833_3WWqD NL000D 2026-03-20T12:03:28.266Z 2026-03-27T12:40:15.554Z
9518103 9518103 20260319002751_pR2kM NL000D 2026-03-20T12:01:53.068Z 2026-03-27T12:40:06.324Z
9517932 9517932 20260319001225_sVV82 NL000D 2026-03-20T12:01:32.859Z 2026-03-27T12:40:04.738Z
9517779 9517779 20260319000126_129lT NL000D 2026-03-20T12:01:14.712Z 2026-03-27T12:40:03.175Z
9516915 9516915 20260317221317_O2RaI NL000D 2026-03-19T12:26:54.391Z 2026-03-25T12:43:07.530Z
9506649 9506649 20260316184347_tKKT4 NL000D 2026-03-18T12:19:08.853Z 2026-03-24T12:41:33.982Z
9501817 9501817 20260316231501_3FQap NL000D 2026-03-18T12:00:17.818Z 2026-03-25T12:41:42.847Z
9495044 9495044 20260316040220_Iw7J5 NL000D 2026-03-17T12:05:56.315Z 2026-03-24T12:40:53.811Z
9467717 9467717 20260311224102_aZQv7 NL000D 2026-03-13T12:19:43.775Z 2026-03-19T12:45:54.452Z
9467311 9467311 20260311211518_WwUh3 NL000D 2026-03-13T12:19:02.693Z 2026-03-19T12:45:51.459Z
9467117 9467117 20260311201252_BuvEK NL000D 2026-03-13T12:18:26.506Z 2026-03-19T12:45:48.496Z
9467011 9467011 20260311193008_FAufQ NL000D 2026-03-13T12:18:00.777Z 2026-03-19T12:45:46.505Z
9463056 9463056 20260312005851_ZK9Rc NL000D 2026-03-13T12:02:59.866Z 2026-03-20T12:36:19.540Z
9451855 9451855 20260310042710_jLw3o NL000D 2026-03-11T12:04:03.529Z 2026-03-18T12:39:05.924Z
9451687 9451687 20260310032240_6eBQg NL000D 2026-03-11T12:03:35.330Z 2026-03-18T12:39:02.784Z
9451102 9451102 20260310004248_HhLGk NL000D 2026-03-11T12:01:44.105Z 2026-03-18T12:38:40.515Z
9450339 9450339 20260308202821_c2ItG NL000D 2026-03-10T12:19:18.734Z 2026-03-16T12:44:40.711Z
9446857 9446857 20260309031726_ber2d NL000D 2026-03-10T12:04:10.958Z 2026-03-17T12:41:43.923Z
9446824 9446824 20260309030930_fcwe8 NL000D 2026-03-10T12:04:04.853Z 2026-03-17T12:41:43.398Z
9446519 9446519 20260309015705_tpTlX NL000D 2026-03-10T12:02:46.605Z 2026-03-17T12:41:39.302Z
9446390 9446390 20260309012510_taVsb NL000D 2026-03-10T12:02:14.645Z 2026-03-17T12:41:37.468Z
9446282 9446282 20260309005239_GgWWb NL000D 2026-03-10T12:01:50.201Z 2026-03-17T12:41:35.662Z
9437525 9437525 20260307042850_B0chX NL000D 2026-03-08T12:04:23.740Z 2026-03-15T12:41:08.770Z
9437328 9437328 20260307030927_wCqlX NL000D 2026-03-08T12:03:34.641Z 2026-03-15T12:41:06.266Z
9436532 9436532 20260302033142_VfXZ5 NL000D 2026-03-07T14:35:37.400Z 2026-03-10T12:35:49.134Z
9436529 9436529 20260302025810_ap9Nw NL000D 2026-03-07T14:35:32.797Z 2026-03-10T12:35:47.583Z
9436527 9436527 20260302025704_0nwxw NL000D 2026-03-07T14:35:32.075Z 2026-03-10T12:35:47.385Z
9436526 9436526 20260303040026_ebAdP NL000D 2026-03-07T14:31:34.082Z 2026-03-11T12:28:01.361Z
9436524 9436524 20260303025625_28TxK NL000D 2026-03-07T14:31:21.302Z 2026-03-11T12:27:58.027Z
9436521 9436521 20260303021210_X7Jdm NL000D 2026-03-07T14:31:10.482Z 2026-03-11T12:27:46.647Z
9436520 9436520 20260303005447_Wxphr NL000D 2026-03-07T14:30:58.562Z 2026-03-11T12:27:44.295Z
9431896 9431896 20260306022930_0Hcqz NL000D 2026-03-07T14:02:24.447Z 2026-03-14T12:39:19.788Z
9412545 9412545 20260301040715_sHkx2 NL000D 2026-03-02T14:01:38.230Z 2026-03-09T12:39:42.666Z
9412384 9412384 20260301031453_IlsYs NL000D 2026-03-02T14:01:15.525Z 2026-03-09T12:39:36.935Z
9411963 9411963 20260223024341_jXUiy NL000D 2026-03-01T14:17:37.620Z 2026-03-03T14:31:01.215Z
9411961 9411961 20260226025408_2Gyy8 NL000D 2026-03-01T14:10:17.962Z 2026-03-06T14:43:31.943Z
9411959 9411959 20260226013859_FwC7w NL000D 2026-03-01T14:09:59.036Z 2026-03-06T14:43:09.795Z
9411957 9411957 20260226004940_c7Fqd NL000D 2026-03-01T14:09:51.565Z 2026-03-06T14:43:02.113Z
9411689 9411689 20260227034930_XV85f NL000D 2026-03-01T14:05:56.463Z 2026-03-07T14:46:46.462Z
9411688 9411688 20260227025738_uO20A NL000D 2026-03-01T14:05:42.235Z 2026-03-07T14:46:25.909Z
9411686 9411686 20260227023622_7Gd8f NL000D 2026-03-01T14:05:39.689Z 2026-03-07T14:46:21.856Z
9224326 9224326 20260118042029_7bf8M NL000D 2026-01-19T14:23:53.188Z 2026-01-26T15:03:14.228Z
9224179 9224179 20260118034333_e5V6m NL000D 2026-01-19T14:23:10.989Z 2026-01-26T15:03:07.783Z
9223198 9223198 20260117234354_qftmd NL000D 2026-01-19T14:18:09.185Z 2026-01-26T15:01:57.705Z
9222835 9222835 20260117210114_2i4gX NL000D 2026-01-19T14:16:26.879Z 2026-01-26T15:01:22.659Z
9222775 9222775 20260117204837_QBbHD NL000D 2026-01-19T14:16:11.469Z 2026-01-26T15:01:20.459Z
9221957 9221957 20260117172448_V234q NL000D 2026-01-19T14:12:33.722Z 2026-01-26T15:00:32.408Z
9182596 9182596 20260111055302_seLPB NL000D 2026-01-12T14:15:05.867Z 2026-01-19T15:18:50.735Z
9182508 9182508 20260111053327_F02nm NL000D 2026-01-12T14:14:46.898Z 2026-01-19T15:18:46.493Z

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