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 = "NL0009" 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
9262735 9262735 20260126014443_6dhrQ NL0009 2026-01-27T14:15:03.675Z 2026-01-29T14:38:39.988Z
9262641 9262641 20260125225315_ZLSVN NL0009 2026-01-27T14:14:33.370Z 2026-01-29T14:38:30.903Z
9262576 9262576 20260125202403_xeDN2 NL0009 2026-01-27T14:13:45.089Z 2026-01-29T14:38:20.733Z
9260448 9260448 20260125043026_Vonvm NL0009 2026-01-26T14:21:51.120Z 2026-01-29T14:44:13.635Z
9260368 9260368 20260125040104_Kr1hx NL0009 2026-01-26T14:21:25.799Z 2026-01-29T14:44:08.568Z
9260294 9260294 20260125032902_8p28N NL0009 2026-01-26T14:21:05.783Z 2026-01-29T14:44:04.343Z
9260290 9260290 20260125032707_zQEx4 NL0009 2026-01-26T14:21:05.171Z 2026-01-29T14:44:04.134Z
9260208 9260208 20260125030905_Hw8ey NL0009 2026-01-26T14:20:48.257Z 2026-01-29T14:43:59.826Z
9260205 9260205 20260125030743_cnOV3 NL0009 2026-01-26T14:20:47.682Z 2026-01-29T14:43:59.586Z
9260137 9260137 20260125024251_v3yZh NL0009 2026-01-26T14:20:23.546Z 2026-01-29T14:43:50.623Z
9260112 9260112 20260125023752_hQYXr NL0009 2026-01-26T14:20:18.760Z 2026-01-29T14:43:49.208Z
9260036 9260036 20260125021426_UUtJm NL0009 2026-01-26T14:19:51.978Z 2026-01-29T14:43:42.881Z
9260033 9260033 20260125021118_0SzvQ NL0009 2026-01-26T14:19:51.422Z 2026-01-29T14:43:42.682Z
9259975 9259975 20260125013748_2ldU6 NL0009 2026-01-26T14:19:37.818Z 2026-01-29T14:43:38.393Z
9259910 9259910 20260125010907_3luSi NL0009 2026-01-26T14:19:15.616Z 2026-01-29T14:43:34.710Z
9259889 9259889 20260125010313_jyVbx NL0009 2026-01-26T14:19:12.087Z 2026-01-29T14:43:33.669Z
9259836 9259836 20260125004214_oxQJS NL0009 2026-01-26T14:18:51.311Z 2026-01-29T14:43:24.553Z
9259764 9259764 20260124235959_lIkpy NL0009 2026-01-26T14:18:31.092Z 2026-01-29T14:43:17.942Z
9259760 9259760 20260124235926_TUBoJ NL0009 2026-01-26T14:18:30.592Z 2026-01-29T14:43:17.819Z
9259581 9259581 20260124214451_e3KYa NL0009 2026-01-26T14:17:30.813Z 2026-01-29T14:43:07.266Z
9259463 9259463 20260124205550_Z3E2K NL0009 2026-01-26T14:17:06.694Z 2026-01-29T14:42:56.030Z
9259246 9259246 20260124195850_GSg2A NL0009 2026-01-26T14:16:20.170Z 2026-01-29T14:42:44.467Z
9258848 9258848 20260124173353_hONVV NL0009 2026-01-26T14:14:42.944Z 2026-01-29T14:42:14.901Z
9256019 9256019 20260124054432_gZqGx NL0009 2026-01-25T14:15:34.507Z 2026-01-29T14:48:18.503Z
9255935 9255935 20260124052929_8uUvK NL0009 2026-01-25T14:15:12.077Z 2026-01-29T14:48:08.851Z
9252726 9252726 20260123054911_uLlSs NL0009 2026-01-24T14:16:55.781Z 2026-01-29T14:53:21.145Z
9252249 9252249 20260123015747_WqUQH NL0009 2026-01-24T14:14:51.101Z 2026-01-29T14:52:41.789Z
9252057 9252057 20260123004942_nofDz NL0009 2026-01-24T14:14:13.557Z 2026-01-29T14:52:26.374Z
9251945 9251945 20260123000547_Z15Xy NL0009 2026-01-24T14:13:47.413Z 2026-01-29T14:52:18.197Z
9251802 9251802 20260122230104_6DlHs NL0009 2026-01-24T14:13:16.942Z 2026-01-29T14:52:10.952Z
9251756 9251756 20260122222613_H1Q9A NL0009 2026-01-24T14:13:07.412Z 2026-01-29T14:52:08.009Z
9249594 9249594 20260122060309_2jPgp NL0009 2026-01-23T14:15:46.140Z 2026-01-29T14:58:46.280Z
9249458 9249458 20260122052642_Ua8l0 NL0009 2026-01-23T14:15:27.752Z 2026-01-29T14:58:40.657Z
9249449 9249449 20260122052324_Ue3Ne NL0009 2026-01-23T14:15:26.963Z 2026-01-29T14:58:40.019Z
9249362 9249362 20260122050259_TBIjR NL0009 2026-01-23T14:15:13.869Z 2026-01-29T14:58:27.312Z
9248804 9248804 20260122021518_tJE7l NL0009 2026-01-23T14:13:53.375Z 2026-01-29T14:57:47.324Z
9248793 9248793 20260122021053_BY27r NL0009 2026-01-23T14:13:52.005Z 2026-01-29T14:57:46.825Z
9248507 9248507 20260122002339_jhiHX NL0009 2026-01-23T14:12:57.094Z 2026-01-29T14:57:24.275Z
9248483 9248483 20260122001000_wEWNd NL0009 2026-01-23T14:12:54.125Z 2026-01-29T14:57:23.079Z
9248447 9248447 20260121234922_8yI9g NL0009 2026-01-23T14:12:49.144Z 2026-01-29T14:57:19.396Z
9248321 9248321 20260121225416_IxDH2 NL0009 2026-01-23T14:12:30.315Z 2026-01-29T14:57:13.772Z
9248229 9248229 20260121222452_4qTRz NL0009 2026-01-23T14:12:16.382Z 2026-01-29T14:57:09.223Z
9248016 9248016 20260121211048_ETy31 NL0009 2026-01-23T14:11:43.574Z 2026-01-29T14:56:48.432Z
9237586 9237586 20260120054030_6sndg NL0009 2026-01-21T14:27:04.791Z 2026-01-28T15:01:32.185Z
9237427 9237427 20260120051746_zQfEe NL0009 2026-01-21T14:26:29.754Z 2026-01-28T15:01:25.391Z
9237292 9237292 20260120045900_ZTV2q NL0009 2026-01-21T14:25:51.948Z 2026-01-28T15:01:08.257Z
9236796 9236796 20260120040007_niMHP NL0009 2026-01-21T14:24:14.546Z 2026-01-28T15:00:36.518Z
9236786 9236786 20260120035928_SLyJk NL0009 2026-01-21T14:24:13.177Z 2026-01-28T15:00:35.986Z
9236608 9236608 20260120034023_TpHgw NL0009 2026-01-21T14:23:31.870Z 2026-01-28T15:00:24.757Z
9236424 9236424 20260120031502_TI7g1 NL0009 2026-01-21T14:22:47.419Z 2026-01-28T14:59:59.590Z
9236210 9236210 20260120024734_giZ3w NL0009 2026-01-21T14:21:58.556Z 2026-01-28T14:59:50.268Z
9236137 9236137 20260120023929_DyYnq NL0009 2026-01-21T14:21:36.112Z 2026-01-28T14:59:46.640Z
9235962 9235962 20260120022053_76oJi NL0009 2026-01-21T14:20:53.328Z 2026-01-28T14:59:30.488Z
9235920 9235920 20260120021759_tdiye NL0009 2026-01-21T14:20:45.737Z 2026-01-28T14:59:29.101Z
9235841 9235841 20260120020713_TQDyT NL0009 2026-01-21T14:20:32.588Z 2026-01-28T14:59:23.739Z
9235702 9235702 20260120015059_4lKy4 NL0009 2026-01-21T14:20:01.382Z 2026-01-28T14:59:16.670Z
9235656 9235656 20260120014359_y3hVB NL0009 2026-01-21T14:19:50.021Z 2026-01-28T14:59:14.879Z
9235440 9235440 20260120011405_3V1i8 NL0009 2026-01-21T14:18:54.595Z 2026-01-28T14:58:55.401Z
9235436 9235436 20260120011253_Xtmy3 NL0009 2026-01-21T14:18:53.856Z 2026-01-28T14:58:55.211Z
9235401 9235401 20260120010528_MP3aK NL0009 2026-01-21T14:18:48.253Z 2026-01-28T14:58:53.018Z
9234749 9234749 20260119231456_dQijU NL0009 2026-01-21T14:15:58.809Z 2026-01-28T14:58:04.354Z
9234603 9234603 20260119223509_Yuwef NL0009 2026-01-21T14:15:26.079Z 2026-01-28T14:57:56.244Z
9229440 9229440 20260119014644_Nq3ji NL0009 2026-01-20T14:22:37.059Z 2026-01-27T15:03:26.217Z
9228781 9228781 20260118235018_1hTpQ NL0009 2026-01-20T14:19:27.140Z 2026-01-27T15:02:34.574Z
9228641 9228641 20260118232250_H2cK0 NL0009 2026-01-20T14:18:47.650Z 2026-01-27T15:02:12.572Z
9228057 9228057 20260118193012_o020L NL0009 2026-01-20T14:15:47.482Z 2026-01-27T15:01:23.231Z
9227813 9227813 20260118175856_8mgSn NL0009 2026-01-20T14:14:14.323Z 2026-01-27T15:00:54.923Z
9223725 9223725 20260118021317_5ceD4 NL0009 2026-01-19T14:20:46.836Z 2026-01-26T15:02:33.939Z
9223559 9223559 20260118012352_uQ3HQ NL0009 2026-01-19T14:19:57.270Z 2026-01-26T15:02:14.427Z
9223552 9223552 20260118011951_iCRcG NL0009 2026-01-19T14:19:56.077Z 2026-01-26T15:02:14.139Z
9223527 9223527 20260118011208_q4C3Y NL0009 2026-01-19T14:19:45.210Z 2026-01-26T15:02:13.188Z
9223432 9223432 20260118003951_3PhQT NL0009 2026-01-19T14:19:19.671Z 2026-01-26T15:02:06.674Z
9223330 9223330 20260118001616_3nss5 NL0009 2026-01-19T14:18:47.842Z 2026-01-26T15:02:02.557Z
9223182 9223182 20260117233807_eOnDV NL0009 2026-01-19T14:18:05.012Z 2026-01-26T15:01:57.003Z
9207503 9207503 20260115015750_FSe3Z NL0009 2026-01-16T14:08:59.847Z 2026-01-22T15:03:23.410Z
9194804 9194804 20260112224602_plY9u NL0009 2026-01-14T14:10:44.924Z 2026-01-21T15:04:21.283Z
9180973 9180973 20260110233759_amw8g NL0009 2026-01-12T14:09:06.928Z 2026-01-19T15:16:42.631Z
9180928 9180928 20260110232900_KFmSh NL0009 2026-01-12T14:08:57.640Z 2026-01-19T15:16:39.330Z
9180915 9180915 20260110232338_gEDQT NL0009 2026-01-12T14:08:52.778Z 2026-01-19T15:16:38.765Z
9180885 9180885 20260110231014_PrI2j NL0009 2026-01-12T14:08:45.450Z 2026-01-19T15:16:37.407Z
9180883 9180883 20260110230847_AUaqC NL0009 2026-01-12T14:08:44.766Z 2026-01-19T15:16:37.218Z
9180847 9180847 20260110225718_5Pk5d NL0009 2026-01-12T14:08:35.420Z 2026-01-19T15:16:35.096Z
9180796 9180796 20260110223506_UPhAU NL0009 2026-01-12T14:08:23.654Z 2026-01-19T15:16:32.933Z
9162054 9162054 20260106192231_bRLWa NL0009 2026-01-08T14:02:21.850Z 2026-01-13T15:01:29.027Z
9162045 9162045 20260106185417_4CjJH NL0009 2026-01-08T14:02:10.679Z 2026-01-13T15:01:26.182Z
9162016 9162016 20260106182821_DXK2o NL0009 2026-01-08T14:01:52.176Z 2026-01-13T15:01:22.794Z
9161988 9161988 20260106181310_BQmtR NL0009 2026-01-08T14:01:35.778Z 2026-01-13T15:01:14.827Z
9158974 9158974 20260106010843_OHSjY NL0009 2026-01-07T14:07:50.083Z 2026-01-13T15:07:53.295Z
9158920 9158920 20260106005527_o9YEm NL0009 2026-01-07T14:07:40.429Z 2026-01-13T15:07:50.829Z
9158916 9158916 20260106005317_wFSBR NL0009 2026-01-07T14:07:39.813Z 2026-01-13T15:07:50.627Z
9147648 9147648 20260104062204_Y7440 NL0009 2026-01-05T14:24:39.655Z 2026-01-12T15:11:27.689Z
9146913 9146913 20260104044321_Zz8FT NL0009 2026-01-05T14:23:15.665Z 2026-01-12T15:09:40.738Z
9146907 9146907 20260104044236_dTPrs NL0009 2026-01-05T14:23:14.978Z 2026-01-12T15:09:40.182Z
9128167 9128167 20260102063230_2yKGu NL0009 2026-01-03T14:13:47.012Z 2026-01-09T14:50:27.918Z
9127635 9127635 20260102044246_jMBxd NL0009 2026-01-03T14:11:10.691Z 2026-01-09T14:50:01.441Z
9127633 9127633 20260102044245_4FnJh NL0009 2026-01-03T14:11:09.876Z 2026-01-09T14:50:01.296Z
9127544 9127544 20260102042709_azu8m NL0009 2026-01-03T14:10:42.966Z 2026-01-09T14:49:57.661Z
9126963 9126963 20260102015117_qQJ6M NL0009 2026-01-03T14:07:43.731Z 2026-01-09T14:49:20.567Z
9126879 9126879 20260102011810_C84g3 NL0009 2026-01-03T14:07:13.347Z 2026-01-09T14:49:08.429Z
9118702 9118702 20251230040620_Q10Vl NL0009 2026-01-01T14:46:34.386Z 2026-01-07T15:08:31.402Z

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