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 = "AU001X" 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
8683430 8683430 20251201200036_ByyPT AU001X 2025-12-04T14:24:25.704Z 2025-12-04T14:24:25.704Z
8683403 8683403 20251201184527_hz0zM AU001X 2025-12-04T14:24:06.819Z 2025-12-04T14:24:06.819Z
8683399 8683399 20251201183906_vszls AU001X 2025-12-04T14:24:05.980Z 2025-12-04T14:24:05.980Z
8683381 8683381 20251201175802_69xk1 AU001X 2025-12-04T14:23:55.569Z 2025-12-04T14:23:55.569Z
8683364 8683364 20251201171257_l8Jvr AU001X 2025-12-04T14:23:40.771Z 2025-12-04T14:23:40.771Z
8683354 8683354 20251201154636_sQhBS AU001X 2025-12-04T14:23:24.764Z 2025-12-04T14:23:24.764Z
8683347 8683347 20251201153436_mygSv AU001X 2025-12-04T14:23:20.625Z 2025-12-04T14:23:20.625Z
8683330 8683330 20251201142113_FB7MA AU001X 2025-12-04T14:22:48.094Z 2025-12-04T14:22:48.094Z
8683327 8683327 20251201140812_5BPbC AU001X 2025-12-04T14:22:39.121Z 2025-12-04T14:22:39.121Z
8683321 8683321 20251201133533_13Fa8 AU001X 2025-12-04T14:22:24.081Z 2025-12-04T14:22:24.081Z
8683315 8683315 20251201131812_PXnEW AU001X 2025-12-04T14:22:18.984Z 2025-12-04T14:22:18.984Z
8683305 8683305 20251201121348_zYp7u AU001X 2025-12-04T14:21:42.359Z 2025-12-04T14:21:42.359Z
8667140 8667140 20251129173818_kYzkG AU001X 2025-12-02T14:35:10.515Z 2025-12-04T14:38:01.119Z
8667032 8667032 20251129152754_seGbz AU001X 2025-12-02T14:34:07.372Z 2025-12-04T14:37:18.693Z
8666724 8666724 20251130192350_l4LTk AU001X 2025-12-02T14:27:12.581Z 2025-12-04T14:31:33.145Z
8666703 8666703 20251130184736_ReZkE AU001X 2025-12-02T14:27:10.441Z 2025-12-04T14:31:12.807Z
8666695 8666695 20251130184309_zPMNz AU001X 2025-12-02T14:27:09.547Z 2025-12-04T14:31:09.144Z
8666687 8666687 20251130183636_UG73L AU001X 2025-12-02T14:27:07.822Z 2025-12-04T14:31:06.523Z
8666666 8666666 20251130182455_rEvQC AU001X 2025-12-02T14:27:05.290Z 2025-12-04T14:31:00.726Z
8666654 8666654 20251130175249_ry3nN AU001X 2025-12-02T14:27:03.632Z 2025-12-04T14:30:52.029Z
8666647 8666647 20251130173031_aeqYC AU001X 2025-12-02T14:27:02.532Z 2025-12-04T14:30:32.006Z
8666642 8666642 20251130172352_J2NVQ AU001X 2025-12-02T14:27:02.023Z 2025-12-04T14:30:28.368Z
8666638 8666638 20251130170822_tozut AU001X 2025-12-02T14:27:01.603Z 2025-12-04T14:30:22.503Z
8666630 8666630 20251130165447_tatfK AU001X 2025-12-02T14:27:00.688Z 2025-12-04T14:30:17.946Z
8666626 8666626 20251130164636_YGRNL AU001X 2025-12-02T14:27:00.132Z 2025-12-04T14:30:15.320Z
8666623 8666623 20251130164453_yAwx3 AU001X 2025-12-02T14:26:59.874Z 2025-12-04T14:30:14.992Z
8666616 8666616 20251130161844_nrilV AU001X 2025-12-02T14:26:59.018Z 2025-12-04T14:30:11.025Z
8666584 8666584 20251130140405_Aoor1 AU001X 2025-12-02T14:26:54.039Z 2025-12-04T14:29:15.283Z
8666582 8666582 20251130135841_Kl5CA AU001X 2025-12-02T14:26:53.671Z 2025-12-04T14:29:13.899Z
8666578 8666578 20251130134524_YaPqX AU001X 2025-12-02T14:26:52.586Z 2025-12-04T14:29:10.017Z
8666565 8666565 20251130124704_mwllP AU001X 2025-12-02T14:26:49.962Z 2025-12-04T14:28:45.931Z
8666563 8666563 20251130120904_5gB6x AU001X 2025-12-02T14:26:49.460Z 2025-12-04T14:28:34.915Z
8666561 8666561 20251130120429_LK6c3 AU001X 2025-12-02T14:26:49.050Z 2025-12-04T14:28:33.677Z
8650261 8650261 20251129194652_z91Z8 AU001X 2025-12-01T14:15:39.640Z 2025-12-04T14:38:47.329Z
8650243 8650243 20251129194618_3tMyD AU001X 2025-12-01T14:15:33.354Z 2025-12-04T14:38:46.855Z
8650196 8650196 20251129193707_AUdyi AU001X 2025-12-01T14:15:23.551Z 2025-12-04T14:38:44.568Z
8650169 8650169 20251129193320_0KfZD AU001X 2025-12-01T14:15:17.543Z 2025-12-04T14:38:43.709Z
8650096 8650096 20251129192048_1pG63 AU001X 2025-12-01T14:15:03.735Z 2025-12-04T14:38:41.190Z
8650031 8650031 20251129190922_q2XAb AU001X 2025-12-01T14:14:44.717Z 2025-12-04T14:38:38.349Z
8649784 8649784 20251129182508_ahSfq AU001X 2025-12-01T14:13:56.089Z 2025-12-04T14:38:23.119Z
8649777 8649777 20251129182337_air5R AU001X 2025-12-01T14:13:54.596Z 2025-12-04T14:38:21.651Z
8649771 8649771 20251129182132_7WENf AU001X 2025-12-01T14:13:53.554Z 2025-12-04T14:38:15.294Z
8649536 8649536 20251129174242_k1C6v AU001X 2025-12-01T14:12:58.962Z 2025-12-04T14:38:02.402Z
8649377 8649377 20251129171710_Vqo90 AU001X 2025-12-01T14:12:19.910Z 2025-12-04T14:37:55.037Z
8649366 8649366 20251129171533_wtc5W AU001X 2025-12-01T14:12:13.230Z 2025-12-04T14:37:54.662Z
8649353 8649353 20251129171408_hJ8hf AU001X 2025-12-01T14:12:10.574Z 2025-12-04T14:37:54.072Z
8649351 8649351 20251129171327_o5sgU AU001X 2025-12-01T14:12:10.031Z 2025-12-04T14:37:53.848Z
8649170 8649170 20251129162952_WeHg7 AU001X 2025-12-01T14:11:17.107Z 2025-12-04T14:37:46.941Z
8649149 8649149 20251129162427_cgmeR AU001X 2025-12-01T14:11:12.650Z 2025-12-04T14:37:45.896Z
8649050 8649050 20251129155202_TO4BG AU001X 2025-12-01T14:10:37.211Z 2025-12-04T14:37:26.910Z
8649003 8649003 20251129154422_FRIKN AU001X 2025-12-01T14:10:25.079Z 2025-12-04T14:37:22.128Z
8648981 8648981 20251129153739_dZ5Jg AU001X 2025-12-01T14:10:17.076Z 2025-12-04T14:37:21.101Z
8648964 8648964 20251129153214_x5vnH AU001X 2025-12-01T14:10:10.629Z 2025-12-04T14:37:19.890Z
8648959 8648959 20251129153032_2KPYC AU001X 2025-12-01T14:10:06.763Z 2025-12-04T14:37:19.117Z
8648940 8648940 20251129152101_Vft3k AU001X 2025-12-01T14:10:00.685Z 2025-12-04T14:37:17.686Z
8648924 8648924 20251129151219_S629m AU001X 2025-12-01T14:09:43.675Z 2025-12-04T14:37:15.807Z
8648862 8648862 20251129141721_2f18n AU001X 2025-12-01T14:08:35.146Z 2025-12-04T14:37:06.760Z
8648847 8648847 20251129135517_6BBHT AU001X 2025-12-01T14:08:13.391Z 2025-12-04T14:37:04.072Z
8648813 8648813 20251129132330_fKMkt AU001X 2025-12-01T14:07:37.193Z 2025-12-04T14:36:49.304Z
8648568 8648568 20251127171053_z9ABD AU001X 2025-11-30T14:33:54.651Z 2025-12-04T14:54:17.480Z
8644725 8644725 20251128194835_eg6Ta AU001X 2025-11-30T14:22:21.077Z 2025-12-04T14:48:34.560Z
8643771 8643771 20251128182550_m9t39 AU001X 2025-11-30T14:20:39.902Z 2025-12-04T14:47:54.828Z
8643644 8643644 20251128181143_Ge7jE AU001X 2025-11-30T14:20:30.363Z 2025-12-04T14:47:49.836Z
8642889 8642889 20251128170117_76iUq AU001X 2025-11-30T14:18:56.286Z 2025-12-04T14:47:34.762Z
8642803 8642803 20251128165032_xXHH6 AU001X 2025-11-30T14:18:37.864Z 2025-12-04T14:47:33.077Z
8642662 8642662 20251128163445_C8PxE AU001X 2025-11-30T14:18:25.585Z 2025-12-04T14:47:30.304Z
8642488 8642488 20251128161044_cwtY1 AU001X 2025-11-30T14:18:02.390Z 2025-12-04T14:47:01.768Z
8642295 8642295 20251128154833_YLWTy AU001X 2025-11-30T14:17:45.014Z 2025-12-04T14:46:59.130Z
8641873 8641873 20251128151739_2u46a AU001X 2025-11-30T14:17:05.908Z 2025-12-04T14:46:51.327Z
8641082 8641082 20251128134407_FK8na AU001X 2025-11-30T14:14:11.474Z 2025-12-04T14:46:07.335Z
8638146 8638146 20251126172218_4ood1 AU001X 2025-11-29T14:33:09.657Z 2025-12-04T15:01:49.144Z
8631592 8631592 20251127192847_3ma27 AU001X 2025-11-29T14:15:47.707Z 2025-12-04T14:54:37.738Z
8631445 8631445 20251127190836_Jmbtf AU001X 2025-11-29T14:15:22.183Z 2025-12-04T14:54:33.773Z
8631398 8631398 20251127190138_nd6tL AU001X 2025-11-29T14:15:14.298Z 2025-12-04T14:54:32.764Z
8630936 8630936 20251127175401_4qwDv AU001X 2025-11-29T14:14:11.351Z 2025-12-04T14:54:22.672Z
8630783 8630783 20251127172242_dklS7 AU001X 2025-11-29T14:13:44.885Z 2025-12-04T14:54:19.011Z
8630711 8630711 20251127170856_2uCuT AU001X 2025-11-29T14:13:31.542Z 2025-12-04T14:54:16.993Z
8630377 8630377 20251127160257_TjkrJ AU001X 2025-11-29T14:12:24.591Z 2025-12-04T14:53:40.638Z
8630096 8630096 20251127141943_fhGIO AU001X 2025-11-29T14:11:34.103Z 2025-12-04T14:53:28.255Z
8630026 8630026 20251127122709_hTBSo AU001X 2025-11-29T14:10:59.324Z 2025-12-04T14:53:02.340Z
8622513 8622513 20251126194111_uGTZp AU001X 2025-11-28T14:19:01.827Z 2025-12-04T15:02:46.058Z
8622340 8622340 20251126185059_j2FSA AU001X 2025-11-28T14:18:27.317Z 2025-12-04T15:02:20.415Z
8622299 8622299 20251126183747_gLXCN AU001X 2025-11-28T14:18:20.417Z 2025-12-04T15:02:10.619Z
8622192 8622192 20251126181021_Uh8v2 AU001X 2025-11-28T14:18:05.753Z 2025-12-04T15:01:59.057Z
8621951 8621951 20251126171641_zez92 AU001X 2025-11-28T14:17:07.331Z 2025-12-04T15:01:48.671Z
8621848 8621848 20251126164502_xBb5N AU001X 2025-11-28T14:16:53.272Z 2025-12-04T15:01:44.679Z
8621632 8621632 20251126155324_ogbMh AU001X 2025-11-28T14:16:17.187Z 2025-12-04T15:01:41.005Z
8621624 8621624 20251126155047_D7Vcb AU001X 2025-11-28T14:16:16.518Z 2025-12-04T15:01:40.815Z
8606151 8606151 20251125180745_v5Y8t AU001X 2025-11-27T14:09:14.173Z 2025-12-04T15:06:27.876Z
8605759 8605759 20251125165046_iUPO5 AU001X 2025-11-27T14:07:47.117Z 2025-12-04T15:05:40.912Z
8605722 8605722 20251125162051_OYmu3 AU001X 2025-11-27T14:07:26.513Z 2025-12-04T15:05:37.697Z
8605704 8605704 20251125161412_D3Glu AU001X 2025-11-27T14:07:22.458Z 2025-12-04T15:05:37.317Z
8605669 8605669 20251125155241_J9sbx AU001X 2025-11-27T14:07:15.046Z 2025-12-04T15:05:36.603Z
8605606 8605606 20251125151123_Bd5WQ AU001X 2025-11-27T14:06:37.914Z 2025-12-04T15:05:33.169Z
8605599 8605599 20251125150856_UNnE8 AU001X 2025-11-27T14:06:36.315Z 2025-12-04T15:05:32.461Z
8605572 8605572 20251125144041_q93jR AU001X 2025-11-27T14:06:07.563Z 2025-12-04T15:05:30.005Z
8605556 8605556 20251125142112_a39D2 AU001X 2025-11-27T14:05:56.960Z 2025-12-04T15:05:28.763Z
8605518 8605518 20251125134325_sHKvH AU001X 2025-11-27T14:05:34.041Z 2025-12-04T15:05:27.364Z
8605494 8605494 20251125131626_gmU9a AU001X 2025-11-27T14:05:24.033Z 2025-12-04T15:05:26.388Z
8605476 8605476 20251125125532_GD73K AU001X 2025-11-27T14:05:10.600Z 2025-12-04T15:05:25.094Z

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