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

981 rows where station_code = "AU0001" 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
9187426 9187426 20260111170638_MccOu AU0001 2026-01-13T14:07:14.514Z 2026-01-20T15:20:27.831Z
9187398 9187398 20260111164820_4FnA6 AU0001 2026-01-13T14:07:05.672Z 2026-01-20T15:20:26.676Z
9186945 9186945 20260111142808_GH920 AU0001 2026-01-13T14:04:24.983Z 2026-01-20T15:19:36.300Z
9178385 9178385 20260110130000_8ADS6 AU0001 2026-01-11T14:14:43.525Z 2026-01-18T15:10:47.522Z
9161393 9161393 20260106125309_yHqvM AU0001 2026-01-07T14:16:25.820Z 2026-01-13T15:10:44.357Z
9097649 9097649 20251227171346_uR5Xo AU0001 2025-12-30T15:09:10.484Z 2026-01-04T15:34:16.647Z
9097543 9097543 20251227165232_t3MEI AU0001 2025-12-30T15:09:01.497Z 2026-01-04T15:34:00.843Z
9096958 9096958 20251227152151_C8x1J AU0001 2025-12-30T15:08:05.697Z 2026-01-04T15:33:28.834Z
9096357 9096357 20251227144454_rrYzZ AU0001 2025-12-30T15:07:24.273Z 2026-01-04T15:33:12.023Z
9095537 9095537 20251227135502_qmqcb AU0001 2025-12-30T15:06:36.024Z 2026-01-04T15:32:36.626Z
9090880 9090880 20251228171248_kVCfa AU0001 2025-12-30T14:51:22.672Z 2026-01-05T15:13:43.192Z
9090855 9090855 20251228170512_cq2jW AU0001 2025-12-30T14:51:19.696Z 2026-01-05T15:13:40.313Z
9090762 9090762 20251228165017_d2x6A AU0001 2025-12-30T14:51:01.510Z 2026-01-05T15:13:37.786Z
9090666 9090666 20251228161458_pxQnI AU0001 2025-12-30T14:50:50.807Z 2025-12-31T14:56:11.822Z
9090595 9090595 20251228154645_PDKKu AU0001 2025-12-30T14:50:34.471Z 2026-01-05T15:13:30.896Z
9090546 9090546 20251228153326_nhxWk AU0001 2025-12-30T14:50:28.445Z 2026-01-05T15:13:29.383Z
9089961 9089961 20251228141502_5UbcH AU0001 2025-12-30T14:49:22.311Z 2026-01-05T15:12:57.989Z
9047130 9047130 20251223165202_a6DIs AU0001 2025-12-28T14:55:55.940Z 2025-12-31T15:43:36.348Z
9004251 9004251 20251222161322_Uyfx3 AU0001 2025-12-27T14:30:34.167Z 2025-12-30T15:48:59.800Z
9004204 9004204 20251222155233_F7WBH AU0001 2025-12-27T14:30:27.996Z 2025-12-30T15:48:59.076Z
9004181 9004181 20251222154330_9tJGq AU0001 2025-12-27T14:30:24.254Z 2025-12-30T15:48:58.838Z
9004128 9004128 20251222152433_KacmT AU0001 2025-12-27T14:30:05.915Z 2025-12-30T15:48:58.184Z
8968674 8968674 20251216163026_pZuiz AU0001 2025-12-25T14:49:25.941Z 2025-12-25T14:49:25.941Z
8968649 8968649 20251216161837_qW12H AU0001 2025-12-25T14:49:23.510Z 2025-12-25T14:49:23.510Z
8968625 8968625 20251216160141_hq0rJ AU0001 2025-12-25T14:49:20.758Z 2025-12-25T14:49:20.758Z
8967717 8967717 20251216140439_BEIwA AU0001 2025-12-25T14:48:12.043Z 2025-12-25T14:48:12.043Z
8959838 8959838 20251217164952_0m9XP AU0001 2025-12-25T14:28:02.310Z 2025-12-26T15:03:11.161Z
8959793 8959793 20251217164357_E5LAb AU0001 2025-12-25T14:27:56.184Z 2025-12-26T15:03:02.897Z
8958566 8958566 20251217144350_D3TCd AU0001 2025-12-25T14:24:33.564Z 2025-12-26T15:02:14.466Z
8957089 8957089 20251217123832_Fc6Q2 AU0001 2025-12-25T14:20:40.695Z 2025-12-26T15:01:01.661Z
8670354 8670354 20251202173931_eQwCi AU0001 2025-12-03T14:08:09.438Z 2025-12-11T14:44:23.730Z
8670345 8670345 20251202172633_4vrYW AU0001 2025-12-03T14:08:07.485Z 2025-12-11T14:44:02.760Z
8670333 8670333 20251202170812_YiGQe AU0001 2025-12-03T14:08:01.436Z 2025-12-11T14:43:57.677Z
8670305 8670305 20251202162600_iDBz5 AU0001 2025-12-03T14:07:55.487Z 2025-12-11T14:43:52.910Z
8670297 8670297 20251202162053_o12Ji AU0001 2025-12-03T14:07:53.844Z 2025-12-11T14:43:52.722Z
8544999 8544999 20251120155707_QTEP3 AU0001 2025-11-22T14:09:27.841Z 2025-11-29T14:53:57.496Z
8544665 8544665 20251120152542_fnK2i AU0001 2025-11-22T14:08:34.786Z 2025-11-29T14:53:49.390Z
8544521 8544521 20251120151701_7IVIu AU0001 2025-11-22T14:08:09.099Z 2025-11-29T14:53:46.994Z
8544134 8544134 20251120145158_Sx9pi AU0001 2025-11-22T14:07:01.692Z 2025-11-29T14:53:41.463Z
8303689 8303689 20251029175207_enODX AU0001 2025-10-31T12:07:04.555Z 2025-11-07T15:09:44.519Z
8303582 8303582 20251029173737_k8e2u AU0001 2025-10-31T12:06:45.538Z 2025-11-07T15:09:39.356Z
8303575 8303575 20251029173653_LzZZr AU0001 2025-10-31T12:06:44.734Z 2025-11-07T15:09:39.271Z
8303400 8303400 20251029171114_TwxO4 AU0001 2025-10-31T12:06:25.475Z 2025-11-07T15:09:36.102Z
8303158 8303158 20251029163229_dxHoi AU0001 2025-10-31T12:05:47.617Z 2025-11-07T15:09:25.504Z
8289000 8289000 20251028180926_30X4W AU0001 2025-10-30T12:12:07.379Z 2025-11-06T15:11:36.735Z
8287876 8287876 20251028163116_oLnLO AU0001 2025-10-30T12:08:33.644Z 2025-11-06T15:10:54.256Z
8287694 8287694 20251028161537_6foVL AU0001 2025-10-30T12:08:04.014Z 2025-11-06T15:10:46.910Z
8287675 8287675 20251028161017_OyF8v AU0001 2025-10-30T12:07:53.988Z 2025-11-06T15:10:46.819Z
8287343 8287343 20251028154929_WFdro AU0001 2025-10-30T12:06:44.282Z 2025-11-06T15:10:36.555Z
8286676 8286676 20251028150200_g5O47 AU0001 2025-10-30T12:04:27.864Z 2025-11-06T15:10:26.350Z
8285049 8285049 20251027120012_mdxlo AU0001 2025-10-29T12:47:02.362Z 2025-11-04T15:48:31.104Z
8278342 8278342 20251027120012_b5lQ2 AU0001 2025-10-29T12:33:27.673Z 2025-11-04T15:48:31.088Z
8277791 8277791 20251027110517_gJS6E AU0001 2025-10-29T12:32:21.695Z 2025-11-04T15:47:54.196Z
8270782 8270782 20251027180908_O7Qf2 AU0001 2025-10-29T12:06:29.140Z 2025-11-05T15:19:26.274Z
8270744 8270744 20251027180535_lOSAR AU0001 2025-10-29T12:06:25.550Z 2025-11-05T15:19:26.048Z
8270712 8270712 20251027180442_pBnLc AU0001 2025-10-29T12:06:23.122Z 2025-11-05T15:19:24.672Z
8270619 8270619 20251027175749_MCKnp AU0001 2025-10-29T12:06:15.749Z 2025-11-05T15:19:23.518Z
8270523 8270523 20251027175032_ypDF2 AU0001 2025-10-29T12:05:59.377Z 2025-11-05T15:19:18.604Z
8268974 8268974 20251027153012_sOcpv AU0001 2025-10-29T12:02:33.006Z 2025-11-05T15:18:37.786Z
8268574 8268574 20251027143144_8F6iW AU0001 2025-10-29T12:01:31.202Z 2025-11-05T15:18:30.909Z
8268311 8268311 20251027134208_ftRRY AU0001 2025-10-29T12:00:52.418Z 2025-11-05T15:18:29.429Z
8228542 8228542 20251024120702_0Hdhy AU0001 2025-10-26T12:48:01.274Z 2025-11-01T13:11:33.561Z
8208113 8208113 20251024175043_CejBc AU0001 2025-10-26T12:11:01.376Z 2025-11-02T15:05:04.411Z
8207818 8207818 20251024164306_x0Bh2 AU0001 2025-10-26T12:09:48.269Z 2025-11-02T15:05:02.744Z
8207545 8207545 20251024160745_seZmW AU0001 2025-10-26T12:08:55.050Z 2025-11-02T15:05:01.921Z
8205677 8205677 20251024131840_tqWgn AU0001 2025-10-26T12:01:39.060Z 2025-11-02T15:04:50.339Z
8199658 8199658 20251023162639_CQaaR AU0001 2025-10-25T12:05:48.341Z 2025-11-01T13:09:33.376Z
8151138 8151138 20251018100228_MT41N AU0001 2025-10-20T12:42:26.189Z 2025-10-26T13:16:24.904Z
8140979 8140979 20251018160131_hKHPR AU0001 2025-10-20T12:04:59.322Z 2025-10-27T13:09:33.523Z
8140756 8140756 20251018144510_RJ4Ng AU0001 2025-10-20T12:04:13.847Z 2025-10-27T13:09:30.858Z
8140667 8140667 20251018140757_aDU2r AU0001 2025-10-20T12:03:52.610Z 2025-10-27T13:09:28.181Z
8130780 8130780 20251017181048_pkhiB AU0001 2025-10-19T12:05:36.263Z 2025-10-26T13:14:55.702Z
8130742 8130742 20251017174853_iG6Xz AU0001 2025-10-19T12:05:30.079Z 2025-10-26T13:14:55.046Z
8130713 8130713 20251017170923_Ck5fL AU0001 2025-10-19T12:05:15.321Z 2025-10-26T13:14:54.733Z
8130711 8130711 20251017170530_ljU7d AU0001 2025-10-19T12:05:13.689Z 2025-10-26T13:14:54.730Z
8130686 8130686 20251017164706_5cWoe AU0001 2025-10-19T12:05:07.814Z 2025-10-26T13:14:54.617Z
8130649 8130649 20251017163408_2lVFB AU0001 2025-10-19T12:05:02.063Z 2025-10-26T13:14:54.422Z
8130283 8130283 20251017154102_GzXl3 AU0001 2025-10-19T12:04:16.382Z 2025-10-26T13:14:49.688Z
8130250 8130250 20251017153548_Lo5cv AU0001 2025-10-19T12:04:14.088Z 2025-10-26T13:14:49.332Z
8109607 8109607 20251015182626_qUv0I AU0001 2025-10-17T12:05:38.497Z 2025-10-24T13:15:27.648Z
8109598 8109598 20251015182402_Q03kI AU0001 2025-10-17T12:05:31.815Z 2025-10-24T13:15:27.534Z
8109505 8109505 20251015175628_s9zYu AU0001 2025-10-17T12:05:23.775Z 2025-10-24T13:15:24.647Z
8109502 8109502 20251015175602_dbU0D AU0001 2025-10-17T12:05:23.436Z 2025-10-24T13:15:24.643Z
8109380 8109380 20251015173229_og0b2 AU0001 2025-10-17T12:04:50.912Z 2025-10-24T13:15:22.115Z
8109288 8109288 20251015170014_96T55 AU0001 2025-10-17T12:04:41.471Z 2025-10-24T13:15:18.555Z
8109278 8109278 20251015165142_vyRTr AU0001 2025-10-17T12:04:40.708Z 2025-10-24T13:15:18.348Z
8109189 8109189 20251015162202_YVcM5 AU0001 2025-10-17T12:04:23.946Z 2025-10-24T13:15:14.185Z
8108819 8108819 20251015124418_d7yGF AU0001 2025-10-17T12:02:33.909Z 2025-10-24T13:14:40.937Z
8108760 8108760 20251015120202_qHtSb AU0001 2025-10-17T12:02:19.500Z 2025-10-24T13:14:32.566Z
8096766 8096766 20251014174351_pVKFp AU0001 2025-10-15T12:08:59.159Z 2025-10-23T13:07:57.942Z
8090230 8090230 20251013163811_wUSFA AU0001 2025-10-14T12:02:52.280Z 2025-10-22T13:09:16.109Z
8090124 8090124 20251013161351_4LOOf AU0001 2025-10-14T12:02:36.737Z 2025-10-22T13:09:10.952Z
8090074 8090074 20251013160553_RBY3o AU0001 2025-10-14T12:02:31.655Z 2025-10-22T13:09:10.356Z
8089961 8089961 20251013154622_rjFP3 AU0001 2025-10-14T12:02:16.353Z 2025-10-22T13:09:07.684Z
8089929 8089929 20251013153707_fGKfT AU0001 2025-10-14T12:02:06.081Z 2025-10-22T13:09:06.922Z
8089800 8089800 20251013151027_6u5bJ AU0001 2025-10-14T12:01:49.178Z 2025-10-22T13:09:02.894Z
8089798 8089798 20251013151025_7Zj8f AU0001 2025-10-14T12:01:48.829Z 2025-10-22T13:09:02.828Z
8089676 8089676 20251013143903_13KhA AU0001 2025-10-14T12:01:27.932Z 2025-10-22T13:08:57.126Z
8089591 8089591 20251013141454_WLO2X AU0001 2025-10-14T12:01:15.578Z 2025-10-22T13:08:51.084Z
8089367 8089367 20251013131858_xnGQ4 AU0001 2025-10-14T12:00:51.204Z 2025-10-22T13:08:47.275Z

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