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 = "AU000U" 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
9841477 9841477 20260501163854_9Fkxm AU000U 2026-05-04T12:22:17.470Z 2026-05-04T12:22:17.470Z
9841458 9841458 20260501162109_5KKtC AU000U 2026-05-04T12:22:14.117Z 2026-05-04T12:22:14.117Z
9841454 9841454 20260501160920_TbWC1 AU000U 2026-05-04T12:22:11.129Z 2026-05-04T12:22:11.129Z
9841267 9841267 20260502180029_dRHtB AU000U 2026-05-04T12:17:28.914Z 2026-05-04T12:17:28.914Z
9841244 9841244 20260502172900_QdkFQ AU000U 2026-05-04T12:17:04.187Z 2026-05-04T12:17:04.187Z
9841213 9841213 20260502164102_mDWbl AU000U 2026-05-04T12:16:29.999Z 2026-05-04T12:16:29.999Z
9841207 9841207 20260502163325_gLr1G AU000U 2026-05-04T12:16:25.535Z 2026-05-04T12:16:25.535Z
9841205 9841205 20260502163311_SUFep AU000U 2026-05-04T12:16:24.395Z 2026-05-04T12:16:24.395Z
9841196 9841196 20260502160554_5nOsQ AU000U 2026-05-04T12:16:04.589Z 2026-05-04T12:16:04.589Z
9838682 9838682 20260502214203_8NZzQ AU000U 2026-05-04T12:01:56.722Z 2026-05-04T12:09:56.182Z
9838658 9838658 20260502213149_Z3GET AU000U 2026-05-04T12:01:51.795Z 2026-05-04T12:09:56.176Z
9838544 9838544 20260502204752_38AOP AU000U 2026-05-04T12:01:25.472Z 2026-05-04T12:09:56.143Z
9838542 9838542 20260502204659_WPrQm AU000U 2026-05-04T12:01:25.150Z 2026-05-04T12:09:56.142Z
9838504 9838504 20260502203602_DzB3A AU000U 2026-05-04T12:01:15.696Z 2026-05-04T12:09:56.131Z
9838480 9838480 20260502202948_YskXv AU000U 2026-05-04T12:01:11.083Z 2026-05-04T12:09:56.124Z
9838446 9838446 20260502202000_vDEmy AU000U 2026-05-04T12:01:03.262Z 2026-05-04T12:09:56.109Z
9838444 9838444 20260502201956_GNChh AU000U 2026-05-04T12:01:02.864Z 2026-05-04T12:09:56.107Z
9838390 9838390 20260502200350_GlDnm AU000U 2026-05-04T12:00:52.131Z 2026-05-04T12:09:56.082Z
9838326 9838326 20260502193620_VXr0X AU000U 2026-05-04T12:00:37.429Z 2026-05-04T12:09:56.049Z
9834503 9834503 20260501213800_2UwAS AU000U 2026-05-03T12:02:27.902Z 2026-05-04T12:11:43.278Z
9834450 9834450 20260501212514_KZXyU AU000U 2026-05-03T12:02:13.626Z 2026-05-04T12:11:39.985Z
9834390 9834390 20260501211300_AKSkb AU000U 2026-05-03T12:01:52.949Z 2026-05-04T12:11:36.324Z
9834339 9834339 20260501205758_0XAWb AU000U 2026-05-03T12:01:41.038Z 2026-05-04T12:11:33.305Z
9834329 9834329 20260501205557_rrcku AU000U 2026-05-03T12:01:38.467Z 2026-05-04T12:11:31.645Z
9834314 9834314 20260501205422_yesPB AU000U 2026-05-03T12:01:36.582Z 2026-05-04T12:11:19.492Z
9834188 9834188 20260501195548_bwqJZ AU000U 2026-05-03T12:01:06.362Z 2026-05-04T12:11:08.689Z
9834177 9834177 20260501194420_bJyqw AU000U 2026-05-03T12:01:02.729Z 2026-05-04T12:11:07.875Z
9834110 9834110 20260501191243_66zMX AU000U 2026-05-03T12:00:40.377Z 2026-05-04T12:11:02.792Z
9834083 9834083 20260501182410_vsGlf AU000U 2026-05-03T12:00:32.391Z 2026-05-04T12:10:54.556Z
9834073 9834073 20260501181816_fy7AP AU000U 2026-05-03T12:00:28.549Z 2026-05-04T12:10:48.867Z
9834070 9834070 20260501181802_WxjXR AU000U 2026-05-03T12:00:27.750Z 2026-05-04T12:10:47.435Z
9833916 9833916 20260430160304_vhLmc AU000U 2026-05-02T12:23:12.403Z 2026-05-04T12:27:16.416Z
9803727 9803727 20260425113639_WmRHk AU000U 2026-04-27T12:50:34.251Z 2026-05-02T13:04:05.393Z
9797576 9797576 20260425210746_Popn0 AU000U 2026-04-27T12:20:04.317Z 2026-05-04T12:43:37.049Z
9797474 9797474 20260425205131_yrAzy AU000U 2026-04-27T12:19:39.474Z 2026-05-04T12:43:34.333Z
9797067 9797067 20260425193747_KAdhV AU000U 2026-04-27T12:17:57.814Z 2026-05-04T12:43:23.232Z
9797017 9797017 20260425193303_r3ujF AU000U 2026-04-27T12:17:44.844Z 2026-05-04T12:43:22.241Z
9796986 9796986 20260425192642_mbLsl AU000U 2026-04-27T12:17:36.612Z 2026-05-04T12:43:17.741Z
9796801 9796801 20260425190203_yzsD8 AU000U 2026-04-27T12:16:50.248Z 2026-05-04T12:43:01.069Z
9796767 9796767 20260425185417_MyVQR AU000U 2026-04-27T12:16:38.844Z 2026-05-04T12:42:57.794Z
9796765 9796765 20260425185405_jPmLp AU000U 2026-04-27T12:16:38.130Z 2026-05-04T12:42:57.676Z
9796732 9796732 20260425184554_spc3G AU000U 2026-04-27T12:16:32.136Z 2026-05-04T12:42:56.879Z
9796692 9796692 20260425183805_GgAaW AU000U 2026-04-27T12:16:16.213Z 2026-05-04T12:42:55.650Z
9796631 9796631 20260425182734_487gY AU000U 2026-04-27T12:16:01.512Z 2026-05-04T12:42:53.617Z
9796312 9796312 20260425175030_ZD1To AU000U 2026-04-27T12:15:00.332Z 2026-05-04T12:42:47.577Z
9796239 9796239 20260425174652_cGwc3 AU000U 2026-04-27T12:14:49.642Z 2026-05-04T12:42:46.765Z
9796193 9796193 20260425174325_92l9E AU000U 2026-04-27T12:14:37.512Z 2026-05-04T12:42:45.908Z
9795864 9795864 20260425172414_cw6nG AU000U 2026-04-27T12:13:38.991Z 2026-05-04T12:42:23.678Z
9795767 9795767 20260425172115_8nkvZ AU000U 2026-04-27T12:13:30.105Z 2026-05-04T12:42:22.563Z
9795360 9795360 20260425165743_Fkyyz AU000U 2026-04-27T12:12:19.551Z 2026-05-04T12:42:13.600Z
9783752 9783752 20260424214721_2Sw3l AU000U 2026-04-26T12:15:29.786Z 2026-05-02T12:59:28.879Z
9783692 9783692 20260424214253_74LSG AU000U 2026-04-26T12:15:26.190Z 2026-05-02T12:59:27.816Z
9783642 9783642 20260424213857_b8TCx AU000U 2026-04-26T12:15:08.940Z 2026-05-02T12:59:25.857Z
9783619 9783619 20260424213717_SuqkV AU000U 2026-04-26T12:15:06.952Z 2026-05-02T12:59:25.258Z
9783526 9783526 20260424212915_60sa3 AU000U 2026-04-26T12:14:56.788Z 2026-05-02T12:59:22.988Z
9783326 9783326 20260424211102_8tnq2 AU000U 2026-04-26T12:14:32.214Z 2026-05-02T12:59:16.136Z
9783190 9783190 20260424205307_Ts3zr AU000U 2026-04-26T12:14:01.845Z 2026-05-02T12:58:58.104Z
9783089 9783089 20260424204243_Jq2cI AU000U 2026-04-26T12:13:53.539Z 2026-05-02T12:58:55.894Z
9783045 9783045 20260424203353_QZMNi AU000U 2026-04-26T12:13:32.888Z 2026-05-02T12:58:54.467Z
9782910 9782910 20260424201156_2aRhS AU000U 2026-04-26T12:13:16.759Z 2026-05-02T12:58:45.269Z
9782795 9782795 20260424195413_VkpA9 AU000U 2026-04-26T12:12:50.065Z 2026-05-02T12:58:41.708Z
9782789 9782789 20260424195351_Qt0m8 AU000U 2026-04-26T12:12:47.864Z 2026-05-02T12:58:41.543Z
9782766 9782766 20260424194928_roEph AU000U 2026-04-26T12:12:45.605Z 2026-05-02T12:58:40.814Z
9782764 9782764 20260424194814_lbXg3 AU000U 2026-04-26T12:12:45.384Z 2026-05-02T12:58:40.748Z
9782754 9782754 20260424194713_UjAOG AU000U 2026-04-26T12:12:44.439Z 2026-05-02T12:58:40.483Z
9782749 9782749 20260424194709_iz9kO AU000U 2026-04-26T12:12:43.808Z 2026-05-02T12:58:40.154Z
9782666 9782666 20260424193642_81q33 AU000U 2026-04-26T12:12:37.532Z 2026-05-02T12:58:36.998Z
9782502 9782502 20260424191058_2srRm AU000U 2026-04-26T12:12:04.272Z 2026-05-02T12:58:15.297Z
9782211 9782211 20260424182038_lz8s4 AU000U 2026-04-26T12:11:24.644Z 2026-05-02T12:58:04.497Z
9782209 9782209 20260424182026_AaMuv AU000U 2026-04-26T12:11:24.397Z 2026-05-02T12:58:04.439Z
9782104 9782104 20260424181012_coXmM AU000U 2026-04-26T12:11:06.791Z 2026-05-02T12:58:01.278Z
9781541 9781541 20260424173227_wntSL AU000U 2026-04-26T12:09:51.201Z 2026-05-02T12:57:31.558Z
9780856 9780856 20260424165637_6FpIx AU000U 2026-04-26T12:08:30.718Z 2026-05-02T12:57:11.843Z
9780807 9780807 20260424165507_B8azH AU000U 2026-04-26T12:08:27.411Z 2026-05-02T12:57:10.992Z
9780741 9780741 20260424165133_A8Llo AU000U 2026-04-26T12:08:22.363Z 2026-05-02T12:57:09.738Z
9780612 9780612 20260424164144_SM34H AU000U 2026-04-26T12:08:02.906Z 2026-05-02T12:57:07.385Z
9780508 9780508 20260424163534_UxA3h AU000U 2026-04-26T12:07:55.360Z 2026-05-02T12:56:50.659Z
9780188 9780188 20260424161640_RlSZv AU000U 2026-04-26T12:07:14.159Z 2026-05-02T12:56:42.801Z
9779712 9779712 20260424155133_JAc7t AU000U 2026-04-26T12:06:24.173Z 2026-05-02T12:56:33.209Z
9778460 9778460 20260424144426_nv5PR AU000U 2026-04-26T12:03:46.472Z 2026-05-02T12:55:37.116Z
9764897 9764897 20260423215056_e3avg AU000U 2026-04-25T12:17:45.087Z 2026-05-02T13:08:33.023Z
9764537 9764537 20260423211344_SeICB AU000U 2026-04-25T12:16:33.963Z 2026-05-02T13:08:23.801Z
9764503 9764503 20260423211045_V3Wv0 AU000U 2026-04-25T12:16:26.379Z 2026-05-02T13:08:22.764Z
9764476 9764476 20260423210846_0xh37 AU000U 2026-04-25T12:16:22.648Z 2026-05-02T13:08:22.187Z
9764455 9764455 20260423210638_mWymj AU000U 2026-04-25T12:16:17.758Z 2026-05-02T13:08:21.690Z
9764360 9764360 20260423205855_ztuju AU000U 2026-04-25T12:15:54.822Z 2026-05-02T13:08:20.061Z
9764284 9764284 20260423205213_3Gmhk AU000U 2026-04-25T12:15:43.372Z 2026-05-02T13:08:05.270Z
9764263 9764263 20260423205008_7uVTZ AU000U 2026-04-25T12:15:33.947Z 2026-05-02T13:07:55.622Z
9764210 9764210 20260423204138_PM1mZ AU000U 2026-04-25T12:15:24.382Z 2026-05-02T13:07:54.337Z
9763808 9763808 20260423190920_JNZmS AU000U 2026-04-25T12:13:45.093Z 2026-05-02T13:07:40.973Z
9762265 9762265 20260423162918_L5Yiv AU000U 2026-04-25T12:09:08.538Z 2026-05-02T13:06:48.272Z
9762227 9762227 20260423162640_Qzk11 AU000U 2026-04-25T12:09:03.536Z 2026-05-02T13:06:47.720Z
9762094 9762094 20260423161327_sFL29 AU000U 2026-04-25T12:08:34.772Z 2026-05-02T13:06:18.501Z
9762070 9762070 20260423160817_NCLYM AU000U 2026-04-25T12:08:31.397Z 2026-05-02T13:06:18.030Z
9761755 9761755 20260423154935_qFx9Q AU000U 2026-04-25T12:07:39.342Z 2026-05-02T13:06:10.944Z
9760626 9760626 20260423143024_bAF2G AU000U 2026-04-25T12:04:19.738Z 2026-05-02T13:05:28.558Z
9744872 9744872 20260422153815_DbP6s AU000U 2026-04-24T12:01:42.836Z 2026-04-30T13:05:30.715Z
9742364 9742364 20260422124416_ZBNMO AU000U 2026-04-24T12:00:28.428Z 2026-04-30T13:04:59.460Z
9741984 9741984 20260422115940_1cqCI AU000U 2026-04-24T12:00:16.320Z 2026-04-30T13:04:34.941Z
9732347 9732347 20260421210637_E8OzS AU000U 2026-04-23T12:09:16.169Z 2026-04-30T13:16:58.721Z

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