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

9,804 rows where station_code = "AU0010" 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
8667131 8667131 20251129173407_blldb AU0010 2025-12-02T14:35:08.997Z 2025-12-04T14:38:00.368Z
8650260 8650260 20251129194652_z91Z8 AU0010 2025-12-01T14:15:39.640Z 2025-12-04T14:38:47.329Z
8650208 8650208 20251129193927_5zrB2 AU0010 2025-12-01T14:15:25.946Z 2025-12-04T14:38:45.295Z
8650094 8650094 20251129192048_1pG63 AU0010 2025-12-01T14:15:03.735Z 2025-12-04T14:38:41.190Z
8649783 8649783 20251129182508_ahSfq AU0010 2025-12-01T14:13:56.089Z 2025-12-04T14:38:23.119Z
8649778 8649778 20251129182338_S3yWZ AU0010 2025-12-01T14:13:55.061Z 2025-12-04T14:38:21.854Z
8649770 8649770 20251129182132_7WENf AU0010 2025-12-01T14:13:53.554Z 2025-12-04T14:38:15.294Z
8649562 8649562 20251129174811_PfrEh AU0010 2025-12-01T14:13:04.279Z 2025-12-04T14:38:03.529Z
8649516 8649516 20251129173834_l7dVO AU0010 2025-12-01T14:12:54.283Z 2025-12-04T14:38:01.242Z
8649411 8649411 20251129172225_sQaw5 AU0010 2025-12-01T14:12:27.813Z 2025-12-04T14:37:56.775Z
8649364 8649364 20251129171533_wtc5W AU0010 2025-12-01T14:12:13.230Z 2025-12-04T14:37:54.662Z
8649359 8649359 20251129171455_WVeW1 AU0010 2025-12-01T14:12:12.144Z 2025-12-04T14:37:54.496Z
8649354 8649354 20251129171408_Jl3Jb AU0010 2025-12-01T14:12:11.081Z 2025-12-04T14:37:54.197Z
8649168 8649168 20251129162952_WeHg7 AU0010 2025-12-01T14:11:17.106Z 2025-12-04T14:37:46.941Z
8649146 8649146 20251129162422_g9lIf AU0010 2025-12-01T14:11:12.235Z 2025-12-04T14:37:45.818Z
8648846 8648846 20251129135517_6BBHT AU0010 2025-12-01T14:08:13.391Z 2025-12-04T14:37:04.072Z
8648809 8648809 20251129131805_8Bcxr AU0010 2025-12-01T14:07:34.465Z 2025-12-04T14:36:48.966Z
8648566 8648566 20251127171053_z9ABD AU0010 2025-11-30T14:33:54.650Z 2025-12-04T14:54:17.480Z
8644846 8644846 20251128200446_yfBZ5 AU0010 2025-11-30T14:22:47.202Z 2025-12-04T14:48:36.615Z
8644803 8644803 20251128195932_2w3lb AU0010 2025-11-30T14:22:40.229Z 2025-12-04T14:48:35.700Z
8644754 8644754 20251128195206_w7YFM AU0010 2025-11-30T14:22:22.877Z 2025-12-04T14:48:35.007Z
8644364 8644364 20251128192347_lFNrt AU0010 2025-11-30T14:21:53.287Z 2025-12-04T14:48:25.563Z
8644358 8644358 20251128192331_ejhDW AU0010 2025-11-30T14:21:51.012Z 2025-12-04T14:48:25.417Z
8644285 8644285 20251128191538_O3VHO AU0010 2025-11-30T14:21:33.922Z 2025-12-04T14:48:23.814Z
8643243 8643243 20251128173732_MAhhg AU0010 2025-11-30T14:19:47.233Z 2025-12-04T14:47:41.268Z
8642907 8642907 20251128170147_SpE2Q AU0010 2025-11-30T14:18:57.884Z 2025-12-04T14:47:35.052Z
8642636 8642636 20251128163223_e2x5I AU0010 2025-11-30T14:18:23.491Z 2025-12-04T14:47:24.591Z
8642435 8642435 20251128160406_IuBfx AU0010 2025-11-30T14:17:54.369Z 2025-12-04T14:47:00.922Z
8642157 8642157 20251128153536_XfGTl AU0010 2025-11-30T14:17:37.680Z 2025-12-04T14:46:56.068Z
8641006 8641006 20251128131959_wCv6C AU0010 2025-11-30T14:13:38.394Z 2025-12-04T14:46:02.959Z
8640693 8640693 20251129153032_2n8vx AU0010 2025-11-30T14:09:17.080Z 2025-12-04T14:37:19.259Z
8640262 8640262 20251129131805_63jcV AU0010 2025-11-30T14:07:39.331Z 2025-11-30T14:07:39.331Z
8631631 8631631 20251127193649_s9AXh AU0010 2025-11-29T14:15:53.235Z 2025-11-29T14:28:36.088Z
8631478 8631478 20251127191304_42kD3 AU0010 2025-11-29T14:15:28.326Z 2025-12-04T14:54:34.272Z
8631411 8631411 20251127190320_U7ydd AU0010 2025-11-29T14:15:18.064Z 2025-12-04T14:54:33.041Z
8631392 8631392 20251127185944_J8Sth AU0010 2025-11-29T14:15:13.605Z 2025-12-04T14:54:32.567Z
8631371 8631371 20251127185536_Er6AE AU0010 2025-11-29T14:15:11.168Z 2025-12-04T14:54:32.119Z
8631232 8631232 20251127183818_juBWE AU0010 2025-11-29T14:14:58.506Z 2025-11-29T14:28:35.564Z
8631179 8631179 20251127182909_vdP1S AU0010 2025-11-29T14:14:45.553Z 2025-12-04T14:54:28.200Z
8631160 8631160 20251127182525_wDyam AU0010 2025-11-29T14:14:43.450Z 2025-12-04T14:54:27.609Z
8631118 8631118 20251127182119_Jqm2d AU0010 2025-11-29T14:14:35.722Z 2025-12-04T14:54:26.524Z
8631114 8631114 20251127182103_fa1Sj AU0010 2025-11-29T14:14:35.474Z 2025-12-04T14:54:26.473Z
8631103 8631103 20251127181927_Y0dIg AU0010 2025-11-29T14:14:33.906Z 2025-11-29T14:28:35.495Z
8631087 8631087 20251127181517_JWblh AU0010 2025-11-29T14:14:32.609Z 2025-12-04T14:54:25.868Z
8630874 8630874 20251127174028_cpEk3 AU0010 2025-11-29T14:13:54.832Z 2025-12-04T14:54:21.271Z
8630763 8630763 20251127171714_EMkoc AU0010 2025-11-29T14:13:41.316Z 2025-12-04T14:54:18.344Z
8630731 8630731 20251127171053_XQPgm AU0010 2025-11-29T14:13:37.571Z 2025-12-04T14:54:17.533Z
8630634 8630634 20251127165353_Cpja7 AU0010 2025-11-29T14:13:21.305Z 2025-12-04T14:54:09.370Z
8630575 8630575 20251127164547_Uvzk8 AU0010 2025-11-29T14:13:02.079Z 2025-12-04T14:53:55.802Z
8630471 8630471 20251127162339_kFLRc AU0010 2025-11-29T14:12:45.214Z 2025-12-04T14:53:43.018Z
8630443 8630443 20251127161800_iHsOu AU0010 2025-11-29T14:12:41.915Z 2025-12-04T14:53:42.405Z
8630376 8630376 20251127160257_TjkrJ AU0010 2025-11-29T14:12:24.591Z 2025-12-04T14:53:40.638Z
8630252 8630252 20251127152858_NkUcd AU0010 2025-11-29T14:12:10.713Z 2025-12-04T14:53:35.543Z
8628732 8628732 20251128130617_2xj1e AU0010 2025-11-29T14:07:01.223Z 2025-12-04T14:45:59.847Z
8622416 8622416 20251126190755_lYPnm AU0010 2025-11-28T14:18:49.436Z 2025-12-04T15:02:38.931Z
8622324 8622324 20251126184745_4zYed AU0010 2025-11-28T14:18:23.808Z 2025-12-04T15:02:16.642Z
8622319 8622319 20251126184621_YnkoG AU0010 2025-11-28T14:18:23.280Z 2025-11-28T14:26:46.768Z
8622292 8622292 20251126183615_UJdv3 AU0010 2025-11-28T14:18:19.686Z 2025-12-04T15:02:10.313Z
8622119 8622119 20251126175339_0OdDL AU0010 2025-11-28T14:17:45.079Z 2025-12-04T15:01:52.551Z
8621847 8621847 20251126164502_xBb5N AU0010 2025-11-28T14:16:53.272Z 2025-12-04T15:01:44.679Z
8621679 8621679 20251126160122_4RVi3 AU0010 2025-11-28T14:16:22.485Z 2025-12-04T15:01:41.794Z
8621520 8621520 20251126152715_K5sP1 AU0010 2025-11-28T14:15:51.680Z 2025-12-04T15:01:39.530Z
8621410 8621410 20251126150803_MYl3q AU0010 2025-11-28T14:15:40.079Z 2025-12-04T15:01:37.818Z
8621172 8621172 20251126143809_BFNFO AU0010 2025-11-28T14:15:01.380Z 2025-12-04T15:01:33.740Z
8620825 8620825 20251126133741_BygeL AU0010 2025-11-28T14:14:01.439Z 2025-12-04T15:01:27.587Z
8620730 8620730 20251126132516_Pw3AA AU0010 2025-11-28T14:13:49.132Z 2025-12-04T15:01:26.101Z
8606568 8606568 20251125191310_uvSLR AU0010 2025-11-27T14:10:38.861Z 2025-12-04T15:06:46.979Z
8606395 8606395 20251125184745_IeyOw AU0010 2025-11-27T14:10:08.776Z 2025-12-04T15:06:44.870Z
8605473 8605473 20251125125527_n9Go5 AU0010 2025-11-27T14:05:09.952Z 2025-12-04T15:05:25.041Z
8594629 8594629 20251124121205_lVDCE AU0010 2025-11-26T14:07:53.046Z 2025-12-02T15:05:34.423Z
8585705 8585705 20251123173324_HG8SY AU0010 2025-11-25T14:10:37.267Z 2025-12-02T15:10:11.244Z
8585568 8585568 20251123170953_RAjNV AU0010 2025-11-25T14:10:08.003Z 2025-12-02T15:10:04.810Z
8585563 8585563 20251123170902_EnrXX AU0010 2025-11-25T14:10:06.920Z 2025-12-02T15:10:04.730Z
8585466 8585466 20251123155631_RFU2z AU0010 2025-11-25T14:09:37.382Z 2025-12-02T15:09:58.247Z
8578216 8578216 20251122200301_NryQ8 AU0010 2025-11-24T14:11:07.395Z 2025-12-01T15:19:23.241Z
8577355 8577355 20251122175848_rh654 AU0010 2025-11-24T14:08:27.760Z 2025-12-01T15:18:48.111Z
8576773 8576773 20251122161050_fqjxs AU0010 2025-11-24T14:06:43.366Z 2025-12-01T15:18:39.928Z
8576079 8576079 20251122140908_Gtr7l AU0010 2025-11-24T14:04:48.322Z 2025-12-01T15:18:32.949Z
8562380 8562380 20251121141232_5ctQ9 AU0010 2025-11-23T14:05:30.512Z 2025-11-30T15:03:28.682Z
8561907 8561907 20251121131228_YXPnL AU0010 2025-11-23T14:04:05.461Z 2025-11-30T15:03:14.144Z
8547634 8547634 20251120200428_W72zA AU0010 2025-11-22T14:15:24.354Z 2025-11-29T14:54:20.641Z
8546216 8546216 20251120180622_3QeLS AU0010 2025-11-22T14:12:10.727Z 2025-11-29T14:54:10.043Z
8546199 8546199 20251120180444_cVTvS AU0010 2025-11-22T14:12:09.092Z 2025-11-29T14:54:09.914Z
8546166 8546166 20251120180230_03G0q AU0010 2025-11-22T14:12:05.976Z 2025-11-29T14:54:09.351Z
8546006 8546006 20251120174728_slxXg AU0010 2025-11-22T14:11:45.026Z 2025-11-29T14:54:07.800Z
8545624 8545624 20251120171745_Ak3NK AU0010 2025-11-22T14:10:57.481Z 2025-11-29T14:54:05.357Z
8545368 8545368 20251120164711_5BVtj AU0010 2025-11-22T14:10:25.530Z 2025-11-29T14:54:02.570Z
8544841 8544841 20251120153841_LzlHG AU0010 2025-11-22T14:08:59.588Z 2025-11-29T14:53:55.211Z
8533653 8533653 20251119194440_RndiU AU0010 2025-11-21T14:11:32.264Z 2025-11-28T14:54:55.569Z
8533646 8533646 20251119194149_uQ2wT AU0010 2025-11-21T14:11:28.923Z 2025-11-28T14:54:55.354Z
8533605 8533605 20251119193228_qDxH9 AU0010 2025-11-21T14:11:21.661Z 2025-11-28T14:54:53.451Z
8532758 8532758 20251119164738_TwDll AU0010 2025-11-21T14:08:52.084Z 2025-11-28T14:54:00.506Z
8531907 8531907 20251119151312_HG2eV AU0010 2025-11-21T14:06:40.097Z 2025-11-28T14:53:46.912Z
8531900 8531900 20251119151249_iNg6I AU0010 2025-11-21T14:06:37.972Z 2025-11-28T14:53:46.744Z
8531888 8531888 20251119151232_tjJqx AU0010 2025-11-21T14:06:36.839Z 2025-11-28T14:53:46.263Z
8531669 8531669 20251119145007_J7Qfx AU0010 2025-11-21T14:05:55.074Z 2025-11-28T14:53:42.967Z
8531479 8531479 20251119143336_BKLGI AU0010 2025-11-21T14:05:20.678Z 2025-11-28T14:53:35.570Z
8531221 8531221 20251119140244_m7nIk AU0010 2025-11-21T14:04:25.335Z 2025-11-28T14:53:31.330Z
8520018 8520018 20251118183635_IQxTq AU0010 2025-11-20T14:08:40.145Z 2025-11-27T15:11:30.582Z
8519486 8519486 20251118172109_lLbBY AU0010 2025-11-20T14:06:52.383Z 2025-11-27T15:11:27.429Z

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