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 = "UK009X" 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
9610840 9610840 20260404222112_Wj1tN UK009X 2026-04-06T12:11:35.127Z 2026-04-06T12:16:14.673Z
9610815 9610815 20260404220901_2oybE UK009X 2026-04-06T12:11:29.478Z 2026-04-06T12:16:14.667Z
9610812 9610812 20260404220654_VpOaA UK009X 2026-04-06T12:11:28.826Z 2026-04-06T12:16:14.667Z
9610654 9610654 20260404210133_TC8o0 UK009X 2026-04-06T12:10:35.170Z 2026-04-06T12:16:14.626Z
9609213 9609213 20260405040035_ykxV3 UK009X 2026-04-06T12:00:44.116Z 2026-04-06T12:00:44.116Z
9609139 9609139 20260405034309_NHBpf UK009X 2026-04-06T12:00:24.450Z 2026-04-06T12:00:24.450Z
9606737 9606737 20260402195517_KRPjF UK009X 2026-04-04T12:11:19.368Z 2026-04-06T12:23:35.174Z
9595516 9595516 20260330042727_VW64X UK009X 2026-03-31T12:01:37.570Z 2026-04-06T12:30:07.207Z
9595351 9595351 20260330034609_cDtVb UK009X 2026-03-31T12:01:12.030Z 2026-04-06T12:29:59.056Z
9595239 9595239 20260330030811_kiFvz UK009X 2026-03-31T12:00:51.490Z 2026-04-06T12:29:49.444Z
9595227 9595227 20260330030729_qdQ5w UK009X 2026-03-31T12:00:50.433Z 2026-04-06T12:29:48.960Z
9594929 9594929 20260329010418_ByjAd UK009X 2026-03-30T12:10:39.012Z 2026-04-06T12:40:20.894Z
9594850 9594850 20260329004411_v6t67 UK009X 2026-03-30T12:10:25.853Z 2026-04-06T12:40:18.046Z
9594614 9594614 20260328233442_B2Wz2 UK009X 2026-03-30T12:09:59.933Z 2026-04-06T12:40:01.772Z
9594611 9594611 20260328233411_jfApG UK009X 2026-03-30T12:09:59.418Z 2026-04-06T12:40:01.670Z
9594602 9594602 20260328232859_sgzMr UK009X 2026-03-30T12:09:56.985Z 2026-04-06T12:40:01.227Z
9594556 9594556 20260328225806_nMT3f UK009X 2026-03-30T12:09:49.268Z 2026-04-06T12:39:57.020Z
9592978 9592978 20260329040849_GMyAw UK009X 2026-03-30T12:02:29.482Z 2026-04-06T12:34:43.274Z
9592951 9592951 20260329040205_yb3IJ UK009X 2026-03-30T12:02:25.210Z 2026-04-06T12:34:42.146Z
9592941 9592941 20260329035922_7mnFd UK009X 2026-03-30T12:02:22.981Z 2026-04-06T12:34:41.591Z
9592896 9592896 20260329034906_pJjtf UK009X 2026-03-30T12:02:14.910Z 2026-04-06T12:34:39.379Z
9592855 9592855 20260329034014_xMtou UK009X 2026-03-30T12:02:06.677Z 2026-04-06T12:34:37.283Z
9592801 9592801 20260329032311_2MOkw UK009X 2026-03-30T12:01:56.662Z 2026-04-06T12:34:28.457Z
9592707 9592707 20260329030441_RZYlk UK009X 2026-03-30T12:01:40.264Z 2026-04-06T12:34:22.057Z
9592627 9592627 20260329024807_ieG6s UK009X 2026-03-30T12:01:27.201Z 2026-04-06T12:34:18.091Z
9592609 9592609 20260329024726_7BnsX UK009X 2026-03-30T12:01:26.235Z 2026-04-06T12:34:17.792Z
9592441 9592441 20260329020546_M2DEE UK009X 2026-03-30T12:00:58.419Z 2026-04-06T12:34:10.452Z
9592420 9592420 20260329020529_FoS5v UK009X 2026-03-30T12:00:56.547Z 2026-04-06T12:34:09.987Z
9592394 9592394 20260329015937_QXjfn UK009X 2026-03-30T12:00:51.842Z 2026-04-06T12:34:08.906Z
9592346 9592346 20260329015637_7BuPa UK009X 2026-03-30T12:00:45.084Z 2026-04-06T12:34:01.721Z
9592178 9592178 20260329011843_A30yY UK009X 2026-03-30T12:00:16.871Z 2026-04-06T12:33:52.430Z
9592161 9592161 20260329011404_FMhYR UK009X 2026-03-30T12:00:15.054Z 2026-04-06T12:33:51.920Z
9590000 9590000 20260328042607_xZW2S UK009X 2026-03-29T12:01:50.570Z 2026-04-06T12:37:45.482Z
9589842 9589842 20260328041053_rtluV UK009X 2026-03-29T12:01:39.772Z 2026-04-06T12:37:35.929Z
9589665 9589665 20260328035735_Ol26y UK009X 2026-03-29T12:01:32.893Z 2026-04-06T12:37:31.005Z
9589497 9589497 20260328033557_ZoVHH UK009X 2026-03-29T12:01:20.240Z 2026-04-06T12:37:25.711Z
9589435 9589435 20260328032850_Ujwr3 UK009X 2026-03-29T12:01:13.993Z 2026-04-06T12:37:23.395Z
9589387 9589387 20260328032219_p9Za3 UK009X 2026-03-29T12:01:10.700Z 2026-04-06T12:37:21.759Z
9589299 9589299 20260328031252_NPzs1 UK009X 2026-03-29T12:01:04.303Z 2026-04-06T12:37:19.252Z
9585363 9585363 20260326002430_sSswi UK009X 2026-03-27T12:17:11.676Z 2026-04-03T12:39:57.963Z
9584997 9584997 20260325230013_1hU9C UK009X 2026-03-27T12:16:29.865Z 2026-04-03T12:39:46.019Z
9584926 9584926 20260325224643_tN2ek UK009X 2026-03-27T12:16:23.130Z 2026-04-03T12:39:44.410Z
9581986 9581986 20260326041922_VHYsD UK009X 2026-03-27T12:04:19.821Z 2026-04-04T12:39:33.836Z
9581826 9581826 20260326040151_yPRrm UK009X 2026-03-27T12:03:55.049Z 2026-04-04T12:39:21.627Z
9581733 9581733 20260326035351_tsBIR UK009X 2026-03-27T12:03:46.312Z 2026-04-04T12:39:17.392Z
9581730 9581730 20260326035326_vn6Hn UK009X 2026-03-27T12:03:45.839Z 2026-04-04T12:39:17.221Z
9581703 9581703 20260326034537_3L7BY UK009X 2026-03-27T12:03:41.806Z 2026-04-04T12:39:15.678Z
9581471 9581471 20260326031617_46F3t UK009X 2026-03-27T12:03:12.295Z 2026-04-04T12:39:07.316Z
9581455 9581455 20260326031446_o0HWz UK009X 2026-03-27T12:03:10.095Z 2026-04-04T12:39:06.584Z
9581376 9581376 20260326030104_tytl5 UK009X 2026-03-27T12:02:54.117Z 2026-04-04T12:38:54.697Z
9581351 9581351 20260326025621_moY4W UK009X 2026-03-27T12:02:49.314Z 2026-04-04T12:38:53.708Z
9581313 9581313 20260326024808_9Epol UK009X 2026-03-27T12:02:41.041Z 2026-04-04T12:38:52.162Z
9581265 9581265 20260326024455_KoNt3 UK009X 2026-03-27T12:02:34.775Z 2026-04-04T12:38:51.012Z
9581218 9581218 20260326023740_kSqBq UK009X 2026-03-27T12:02:25.086Z 2026-04-04T12:38:46.407Z
9581203 9581203 20260326023624_qmkxj UK009X 2026-03-27T12:02:21.843Z 2026-04-04T12:38:45.577Z
9581115 9581115 20260326022650_hXDVE UK009X 2026-03-27T12:02:10.938Z 2026-04-04T12:38:43.282Z
9581108 9581108 20260326022412_AFJOx UK009X 2026-03-27T12:02:09.543Z 2026-04-04T12:38:42.990Z
9581083 9581083 20260326022107_uBcJx UK009X 2026-03-27T12:02:05.336Z 2026-04-04T12:38:41.933Z
9581073 9581073 20260326022027_enCu2 UK009X 2026-03-27T12:02:03.759Z 2026-04-04T12:38:41.505Z
9580885 9580885 20260326014843_VF9Ao UK009X 2026-03-27T12:01:37.499Z 2026-04-04T12:38:32.142Z
9580868 9580868 20260326014801_J51nm UK009X 2026-03-27T12:01:36.282Z 2026-04-04T12:38:31.620Z
9580718 9580718 20260326012133_Hm285 UK009X 2026-03-27T12:01:14.280Z 2026-04-04T12:38:21.397Z
9580498 9580498 20260326005550_XGAs2 UK009X 2026-03-27T12:00:39.162Z 2026-04-04T12:38:12.395Z
9580489 9580489 20260326005524_l1kWK UK009X 2026-03-27T12:00:36.789Z 2026-04-04T12:38:12.049Z
9580154 9580154 20260325001307_2aDfr UK009X 2026-03-26T12:15:11.021Z 2026-04-02T12:37:44.096Z
9577222 9577222 20260325041917_GObmu UK009X 2026-03-26T12:04:27.441Z 2026-04-03T12:36:52.204Z
9577182 9577182 20260325040810_1KMA1 UK009X 2026-03-26T12:04:19.834Z 2026-04-03T12:36:37.497Z
9577171 9577171 20260325040702_mXi5A UK009X 2026-03-26T12:04:18.188Z 2026-04-03T12:36:37.063Z
9577000 9577000 20260325033715_FFuE0 UK009X 2026-03-26T12:03:51.891Z 2026-04-03T12:36:28.738Z
9576853 9576853 20260325031656_WArMS UK009X 2026-03-26T12:03:30.023Z 2026-04-03T12:36:23.669Z
9576811 9576811 20260325031252_aOmgq UK009X 2026-03-26T12:03:22.265Z 2026-04-03T12:36:21.920Z
9576570 9576570 20260325023439_Vf37I UK009X 2026-03-26T12:02:38.549Z 2026-04-03T12:36:12.784Z
9576553 9576553 20260325023110_8VIh6 UK009X 2026-03-26T12:02:35.948Z 2026-04-03T12:36:12.331Z
9576456 9576456 20260325021009_XeKMh UK009X 2026-03-26T12:02:19.305Z 2026-04-03T12:35:59.778Z
9576169 9576169 20260325012738_rIsHq UK009X 2026-03-26T12:01:28.729Z 2026-04-03T12:35:46.972Z
9575877 9575877 20260325003158_9BWhD UK009X 2026-03-26T12:00:31.164Z 2026-04-03T12:35:27.410Z
9575816 9575816 20260325002103_k2NyJ UK009X 2026-03-26T12:00:17.768Z 2026-04-03T12:35:23.230Z
9575694 9575694 20260321002017_5yZNL UK009X 2026-03-25T12:27:33.139Z 2026-03-29T12:18:46.230Z
9563003 9563003 20260323042858_H89yE UK009X 2026-03-24T12:04:42.747Z 2026-03-31T12:26:32.067Z
9562928 9562928 20260323035034_tApwR UK009X 2026-03-24T12:04:28.907Z 2026-03-31T12:26:29.558Z
9562876 9562876 20260323033042_2nqij UK009X 2026-03-24T12:04:19.272Z 2026-03-31T12:26:28.292Z
9562858 9562858 20260323032739_EzAPo UK009X 2026-03-24T12:04:17.209Z 2026-03-31T12:26:27.972Z
9562808 9562808 20260323031643_8ND4G UK009X 2026-03-24T12:04:07.028Z 2026-03-31T12:26:26.386Z
9562733 9562733 20260323030708_SDwHo UK009X 2026-03-24T12:03:53.314Z 2026-03-31T12:26:24.364Z
9562530 9562530 20260323022921_T5z57 UK009X 2026-03-24T12:03:19.822Z 2026-03-31T12:26:13.518Z
9562511 9562511 20260323022725_C5ftx UK009X 2026-03-24T12:03:17.612Z 2026-03-31T12:26:13.236Z
9562507 9562507 20260323022616_USxVe UK009X 2026-03-24T12:03:17.255Z 2026-03-31T12:26:13.136Z
9562379 9562379 20260323021605_giO2l UK009X 2026-03-24T12:02:57.135Z 2026-03-31T12:26:09.043Z
9561325 9561325 20260321232121_hix08 UK009X 2026-03-23T12:12:16.470Z 2026-03-29T12:21:06.357Z
9561169 9561169 20260321230424_S3ZIX UK009X 2026-03-23T12:12:12.727Z 2026-03-29T12:21:05.430Z
9560959 9560959 20260321223916_oekKm UK009X 2026-03-23T12:12:08.425Z 2026-03-29T12:21:04.174Z
9560714 9560714 20260321220511_62hTb UK009X 2026-03-23T12:12:01.529Z 2026-03-29T12:21:02.328Z
9560704 9560704 20260321220511_XIWQY UK009X 2026-03-23T12:12:01.453Z 2026-03-29T12:21:02.292Z
9560436 9560436 20260321212254_97nKC UK009X 2026-03-23T12:11:47.011Z 2026-03-29T12:21:00.168Z
9560428 9560428 20260321212207_5dyIC UK009X 2026-03-23T12:11:46.645Z 2026-03-29T12:21:00.098Z
9560235 9560235 20260321204918_HjP3E UK009X 2026-03-23T12:11:40.463Z 2026-03-29T12:20:58.710Z
9560204 9560204 20260321204652_YRSEA UK009X 2026-03-23T12:11:40.182Z 2026-03-29T12:20:58.556Z
9560070 9560070 20260321202919_hc20P UK009X 2026-03-23T12:11:37.160Z 2026-03-29T12:20:57.713Z
9560018 9560018 20260321202327_WpDTC UK009X 2026-03-23T12:11:36.319Z 2026-03-29T12:20:57.434Z
9559807 9559807 20260321195120_XtRxi UK009X 2026-03-23T12:11:30.893Z 2026-03-29T12:20:55.664Z

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