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

2,801 rows where station_code = "AU002F" 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
8667273 8667273 20251129193927_8j773 AU002F 2025-12-02T14:36:00.761Z 2025-12-06T14:45:50.544Z
8644561 8644561 20251128193244_55YuK AU002F 2025-11-30T14:22:06.293Z 2025-12-06T14:54:44.515Z
8644450 8644450 20251128192724_t5srG AU002F 2025-11-30T14:22:00.248Z 2025-12-06T14:54:42.271Z
8644422 8644422 20251128192601_Ce83M AU002F 2025-11-30T14:21:59.002Z 2025-12-06T14:54:42.094Z
8644144 8644144 20251128190223_ppEqP AU002F 2025-11-30T14:21:24.096Z 2025-12-06T14:54:38.695Z
8644100 8644100 20251128185701_s316j AU002F 2025-11-30T14:21:20.127Z 2025-12-06T14:54:38.040Z
8419497 8419497 20251110164650_VkJwy AU002F 2025-11-12T14:06:59.581Z 2025-11-19T15:13:13.780Z
8419271 8419271 20251110160537_9Q6OD AU002F 2025-11-12T14:06:06.930Z 2025-11-19T15:13:04.765Z
8418658 8418658 20251110141624_wgHS2 AU002F 2025-11-12T14:02:57.466Z 2025-11-19T15:12:41.360Z
8401655 8401655 20251108161004_oxcjL AU002F 2025-11-10T14:03:46.208Z 2025-11-17T14:57:56.696Z
8395529 8395529 20251107170650_Qm9cd AU002F 2025-11-09T14:04:47.475Z 2025-11-16T15:02:29.730Z
8395429 8395429 20251107162337_OYA6p AU002F 2025-11-09T14:04:14.677Z 2025-11-16T15:02:21.967Z
8289081 8289081 20251028181622_caYYX AU002F 2025-10-30T12:12:27.969Z 2025-11-06T15:11:43.216Z
8288322 8288322 20251028171730_CgXgs AU002F 2025-10-30T12:09:54.175Z 2025-11-06T15:11:14.918Z
8288201 8288201 20251028170537_F8go9 AU002F 2025-10-30T12:09:37.145Z 2025-11-06T15:11:04.997Z
8287807 8287807 20251028162404_S36hR AU002F 2025-10-30T12:08:24.826Z 2025-11-06T15:10:53.294Z
8249957 8249957 20251026183416_RkUEs AU002F 2025-10-28T12:07:30.132Z 2025-11-04T15:40:13.489Z
8249940 8249940 20251026183153_OLon6 AU002F 2025-10-28T12:07:26.948Z 2025-11-04T15:40:12.997Z
8249298 8249298 20251026172604_YmHbG AU002F 2025-10-28T12:05:26.833Z 2025-11-04T15:39:58.232Z
8249251 8249251 20251026171536_gY7D3 AU002F 2025-10-28T12:05:08.410Z 2025-11-04T15:39:56.585Z
8249011 8249011 20251026163158_4bm04 AU002F 2025-10-28T12:04:10.149Z 2025-11-04T15:39:29.778Z
8248891 8248891 20251026160531_uIHMS AU002F 2025-10-28T12:03:38.413Z 2025-11-04T15:39:24.856Z
8248792 8248792 20251026154455_hBUIU AU002F 2025-10-28T12:03:15.768Z 2025-11-04T15:39:21.789Z
8248745 8248745 20251026152650_uj46U AU002F 2025-10-28T12:03:03.061Z 2025-11-04T15:39:20.585Z
8231046 8231046 20251025164222_6zHhd AU002F 2025-10-27T12:06:19.429Z 2025-11-03T15:15:31.782Z
8208337 8208337 20251023125026_wpfjb AU002F 2025-10-26T12:12:12.831Z 2025-11-01T13:09:00.414Z
8174576 8174576 20251021123124_a8RUZ AU002F 2025-10-23T12:00:40.876Z 2025-10-30T13:12:32.052Z
8157006 8157006 20251018182705_m65z0 AU002F 2025-10-21T12:19:24.064Z 2025-10-27T13:09:39.592Z
8156998 8156998 20251018181048_9zUtR AU002F 2025-10-21T12:19:08.962Z 2025-10-27T13:09:38.987Z
8156969 8156969 20251018172014_n4GPx AU002F 2025-10-21T12:18:55.640Z 2025-10-27T13:09:36.898Z
8156957 8156957 20251018163944_Emx3b AU002F 2025-10-21T12:18:49.837Z 2025-10-27T13:09:35.623Z
8156883 8156883 20251018125647_9Tsnr AU002F 2025-10-21T12:17:46.964Z 2025-10-27T13:09:24.466Z
8109179 8109179 20251015161739_FHaxP AU002F 2025-10-17T12:04:15.844Z 2025-10-24T13:15:13.440Z
8109113 8109113 20251015155240_FEr93 AU002F 2025-10-17T12:03:59.205Z 2025-10-24T13:15:08.657Z
8097208 8097208 20251013181244_kiB4B AU002F 2025-10-15T12:11:49.338Z 2025-10-22T13:09:25.189Z
8097203 8097203 20251013180941_dPb6Y AU002F 2025-10-15T12:11:48.428Z 2025-10-22T13:09:24.777Z
8097084 8097084 20251013151033_XCjxZ AU002F 2025-10-15T12:10:43.961Z 2025-10-22T13:09:02.923Z
8097064 8097064 20251013135021_swQKE AU002F 2025-10-15T12:10:28.607Z 2025-10-22T13:08:49.765Z
7982184 7982184 20250926182222_wum0m AU002F 2025-09-28T12:19:15.187Z 2025-10-05T13:10:13.426Z
7956967 7956967 20250924200159_L3TVx AU002F 2025-09-26T12:18:16.945Z 2025-10-03T13:03:56.406Z
7956285 7956285 20250924182757_yVMoX AU002F 2025-09-26T12:16:39.235Z 2025-10-03T13:03:53.370Z
7956256 7956256 20250924182126_MKujy AU002F 2025-09-26T12:16:26.806Z 2025-10-03T13:03:53.117Z
7956215 7956215 20250924181348_tIMO7 AU002F 2025-09-26T12:16:20.781Z 2025-10-03T13:03:52.878Z
7942924 7942924 20250923190635_A9ncN AU002F 2025-09-25T12:21:32.774Z 2025-10-02T13:26:03.198Z
7942651 7942651 20250923183436_DU5dR AU002F 2025-09-25T12:20:35.467Z 2025-10-02T13:25:53.663Z
7942319 7942319 20250923172718_3nOYe AU002F 2025-09-25T12:19:26.389Z 2025-10-02T13:25:39.608Z
7941531 7941531 20250923143537_N38Ha AU002F 2025-09-25T12:16:40.376Z 2025-10-02T13:25:04.817Z
7941509 7941509 20250923143057_Q6a4U AU002F 2025-09-25T12:16:34.213Z 2025-10-02T13:25:03.576Z
7941487 7941487 20250923142313_wVCtX AU002F 2025-09-25T12:16:29.519Z 2025-10-02T13:25:02.346Z
7927037 7927037 20250921161941_oP3Ez AU002F 2025-09-24T12:44:01.674Z 2025-09-30T13:01:58.151Z
7926016 7926016 20250921122352_VbeA3 AU002F 2025-09-24T12:42:03.222Z 2025-09-30T13:01:50.770Z
7915719 7915719 20250922202220_75Y22 AU002F 2025-09-24T12:20:49.902Z 2025-10-01T13:23:28.182Z
7915110 7915110 20250922193945_9AWo2 AU002F 2025-09-24T12:19:32.566Z 2025-10-01T13:23:13.101Z
7914430 7914430 20250922175316_QDuZk AU002F 2025-09-24T12:17:33.015Z 2025-10-01T13:22:52.466Z
7914086 7914086 20250922161623_gfFa8 AU002F 2025-09-24T12:16:21.807Z 2025-10-01T13:22:43.402Z
7914051 7914051 20250922160531_iZolE AU002F 2025-09-24T12:16:09.208Z 2025-10-01T13:22:42.170Z
7843613 7843613 20250909150952_FqvzX AU002F 2025-09-16T12:50:24.140Z 2025-09-17T12:57:16.394Z
7843568 7843568 20250911175747_Hv4V2 AU002F 2025-09-16T12:46:06.319Z 2025-09-19T12:58:11.365Z
7843273 7843273 20250913124851_AM3iD AU002F 2025-09-16T12:38:32.401Z 2025-09-21T13:09:26.066Z
7828637 7828637 20250913142347_UpR34 AU002F 2025-09-15T12:15:23.925Z 2025-09-21T13:09:31.188Z
7828533 7828533 20250913125039_HNnwK AU002F 2025-09-15T12:14:38.126Z 2025-09-21T13:09:26.171Z
7828514 7828514 20250913121545_gsWhr AU002F 2025-09-15T12:14:30.182Z 2025-09-21T13:09:24.800Z
7817955 7817955 20250911173536_kWcfA AU002F 2025-09-13T12:31:41.360Z 2025-09-19T12:58:10.073Z
7817831 7817831 20250911155629_3rARN AU002F 2025-09-13T12:31:26.574Z 2025-09-19T12:58:06.408Z
7817810 7817810 20250911153414_eX6Mq AU002F 2025-09-13T12:31:23.536Z 2025-09-19T12:58:05.952Z
7776537 7776537 20250904124732_knaHP AU002F 2025-09-06T13:34:37.474Z 2025-09-12T12:52:37.228Z
7776501 7776501 20250904123635_fTpDx AU002F 2025-09-06T13:34:35.186Z 2025-09-12T12:52:36.745Z
7766006 7766006 20250829203334_tK3EX AU002F 2025-09-05T12:59:36.442Z 2025-09-07T12:57:45.099Z
7765988 7765988 20250829182230_BJ8b1 AU002F 2025-09-05T12:59:05.812Z 2025-09-07T12:57:35.560Z
7765972 7765972 20250829144842_wJiNX AU002F 2025-09-05T12:58:07.380Z 2025-09-07T12:57:17.268Z
7765969 7765969 20250829144841_GgzDe AU002F 2025-09-05T12:58:04.939Z 2025-09-07T12:57:17.253Z
7765926 7765926 20250831203652_3ft6a AU002F 2025-09-05T12:49:48.501Z 2025-09-09T12:46:43.884Z
7765912 7765912 20250831173820_ewLSE AU002F 2025-09-05T12:48:27.789Z 2025-09-09T12:46:16.000Z
7744150 7744150 20250831144207_er8g9 AU002F 2025-09-03T12:25:59.301Z 2025-09-09T12:46:07.537Z
7734450 7734450 20250831115354_9O1Xx AU002F 2025-09-02T12:39:28.643Z 2025-09-08T12:54:15.533Z
7725074 7725074 20250831203218_33ogI AU002F 2025-09-02T12:14:30.227Z 2025-09-04T12:36:16.743Z
7725048 7725048 20250831203024_U90wn AU002F 2025-09-02T12:14:23.631Z 2025-09-09T12:46:39.299Z
7724996 7724996 20250831202420_wQ9VU AU002F 2025-09-02T12:14:15.201Z 2025-09-09T12:46:37.295Z
7724782 7724782 20250831200032_f1Tv4 AU002F 2025-09-02T12:13:17.066Z 2025-09-09T12:46:29.492Z
7724746 7724746 20250831195515_urQJF AU002F 2025-09-02T12:13:09.982Z 2025-09-09T12:46:28.139Z
7724252 7724252 20250831190114_5FsxJ AU002F 2025-09-02T12:11:09.234Z 2025-09-09T12:46:22.654Z
7724180 7724180 20250831184727_YkZc4 AU002F 2025-09-02T12:10:47.707Z 2025-09-09T12:46:22.041Z
7723949 7723949 20250831181605_d73E0 AU002F 2025-09-02T12:09:43.060Z 2025-09-09T12:46:18.569Z
7723910 7723910 20250831180735_j43Ra AU002F 2025-09-02T12:09:36.599Z 2025-09-09T12:46:17.336Z
7723393 7723393 20250831170233_0tb9f AU002F 2025-09-02T12:07:49.252Z 2025-09-09T12:46:14.090Z
7723363 7723363 20250831165815_QUUm9 AU002F 2025-09-02T12:07:44.686Z 2025-09-09T12:46:13.899Z
7722032 7722032 20250831144207_p62OJ AU002F 2025-09-02T12:03:39.735Z 2025-09-09T12:46:07.592Z
7720960 7720960 20250831122457_uefGV AU002F 2025-09-02T12:00:21.990Z 2025-09-09T12:46:00.501Z
7710966 7710966 20250830203841_AfrhC AU002F 2025-09-01T12:09:45.861Z 2025-09-08T12:51:59.055Z
7709456 7709456 20250830162226_nfoYU AU002F 2025-09-01T12:04:33.534Z 2025-09-08T12:51:24.456Z
7709342 7709342 20250830155649_fH33d AU002F 2025-09-01T12:04:03.589Z 2025-09-08T12:51:21.431Z
7709096 7709096 20250830144435_Iwphg AU002F 2025-09-01T12:03:13.307Z 2025-09-08T12:51:16.932Z
7708894 7708894 20250830135308_d0SL8 AU002F 2025-09-01T12:02:18.311Z 2025-09-08T12:51:12.257Z
7708881 7708881 20250830134650_ppyyv AU002F 2025-09-01T12:02:15.475Z 2025-09-08T12:51:09.833Z
7708688 7708688 20250830124117_ga7Ix AU002F 2025-09-01T12:01:28.057Z 2025-09-08T12:51:03.253Z
7708531 7708531 20250830115419_WZhb0 AU002F 2025-09-01T12:00:50.508Z 2025-09-08T12:50:57.404Z
7700965 7700965 20250829193952_wyP7I AU002F 2025-08-31T12:16:14.044Z 2025-09-07T12:57:39.062Z
7700767 7700767 20250829190601_LaEkk AU002F 2025-08-31T12:15:31.246Z 2025-09-07T12:57:36.948Z
7700678 7700678 20250829185059_rAvoF AU002F 2025-08-31T12:14:59.954Z 2025-09-07T12:57:36.349Z
7700579 7700579 20250829183324_uKytB AU002F 2025-08-31T12:14:47.689Z 2025-09-07T12:57:35.919Z

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