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

220 rows where station_code = "AU0031" 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
9108286 9108286 20251229182919_BYALr AU0031 2025-12-31T14:43:17.688Z 2026-01-06T15:21:29.903Z
9023157 9023157 20251220192403_E69eR AU0031 2025-12-27T15:08:46.971Z 2025-12-27T15:08:46.971Z
7928291 7928291 20250921194454_L3o8P AU0031 2025-09-24T12:45:36.498Z 2025-09-30T13:02:10.543Z
7570543 7570543 20250818192538_vTt3I AU0031 2025-08-20T12:21:05.274Z 2025-08-20T12:38:26.874Z
7187286 7187286 20250724210348_1KZ2N AU0031 2025-07-26T12:31:17.049Z 2025-08-01T12:16:17.861Z
7108091 7108091 20250717181653_njCZF AU0031 2025-07-20T12:12:14.027Z 2025-07-26T12:45:32.261Z
6865116 6865116 20250605191612_sayf9 AU0031 2025-06-07T12:00:41.005Z 2025-06-14T12:27:56.714Z
6514462 6514462 20250415212325_ZbISe AU0031 2025-04-16T12:05:13.989Z 2025-04-24T12:36:35.304Z
6494613 6494613 20250408203103_7Oo9t AU0031 2025-04-10T12:18:12.625Z 2025-04-16T12:27:15.911Z
6429861 6429861 20250330201209_HQZAa AU0031 2025-04-02T12:22:33.072Z 2025-04-08T13:00:20.159Z
6418077 6418077 20250328121844_DGIry AU0031 2025-03-30T12:24:40.314Z 2025-04-05T13:05:41.516Z
6396719 6396719 20250326190727_7nUu9 AU0031 2025-03-28T12:00:57.963Z 2025-04-04T12:46:16.961Z
6320365 6320365 20250315201425_WZ2S7 AU0031 2025-03-16T12:00:35.615Z 2025-03-24T12:55:04.591Z
6320363 6320363 20250315200556_28Xls AU0031 2025-03-16T12:00:34.877Z 2025-03-18T12:12:25.772Z
6311473 6311473 20250310205820_hRPnl AU0031 2025-03-13T12:14:31.337Z 2025-03-19T12:37:31.183Z
6311383 6311383 20250310203309_CD3kG AU0031 2025-03-13T12:14:15.819Z 2025-03-19T12:37:23.631Z
6310974 6310974 20250310184617_fiuAh AU0031 2025-03-13T12:13:08.326Z 2025-03-19T12:37:02.597Z
6301825 6301825 20250309180721_Xjo9H AU0031 2025-03-11T12:04:00.716Z 2025-03-18T12:38:19.514Z
6292177 6292177 20250308190507_DmUOD AU0031 2025-03-10T12:03:33.515Z 2025-03-17T12:36:40.214Z
6291935 6291935 20250308175419_z90wq AU0031 2025-03-10T12:02:46.032Z 2025-03-17T12:36:11.522Z
6291802 6291802 20250308170755_LLLlS AU0031 2025-03-10T12:02:14.076Z 2025-03-17T12:35:55.203Z
6276216 6276216 20250307163721_G11rt AU0031 2025-03-08T14:00:34.127Z 2025-03-15T12:29:11.929Z
6253179 6253179 20250304190041_SVh30 AU0031 2025-03-07T14:35:48.705Z 2025-03-13T12:41:17.820Z
6239148 6239148 20250305174313_u2K1e AU0031 2025-03-07T14:06:16.556Z 2025-03-14T12:32:57.189Z
6237761 6237761 20250306175040_Bgp2Z AU0031 2025-03-07T14:02:02.596Z 2025-03-15T12:33:13.983Z
6232090 6232090 20250303190946_fQ9Gn AU0031 2025-03-05T14:00:58.692Z 2025-03-11T13:19:08.738Z
6164747 6164747 20250224210529_oR2d3 AU0031 2025-02-26T14:04:57.853Z 2025-03-04T15:17:18.674Z
6164731 6164731 20250224210147_FrmZQ AU0031 2025-02-26T14:04:55.547Z 2025-03-05T15:16:03.308Z
6164653 6164653 20250224204506_dUbW4 AU0031 2025-02-26T14:04:36.497Z 2025-03-05T15:15:54.958Z
6163957 6163957 20250224184247_rBm8Y AU0031 2025-02-26T14:02:13.973Z 2025-03-05T15:14:26.160Z
6145254 6145254 20250223201212_0JZe4 AU0031 2025-02-24T14:02:36.726Z 2025-03-04T15:22:44.639Z
6144964 6144964 20250223190502_npJsY AU0031 2025-02-24T14:01:41.869Z 2025-03-04T15:22:27.596Z
6144700 6144700 20250223180140_hOlXJ AU0031 2025-02-24T14:00:53.469Z 2025-03-04T15:22:07.149Z
6144174 6144174 20250221171545_qHmBn AU0031 2025-02-23T14:40:35.521Z 2025-03-01T15:32:09.337Z
6136073 6136073 20250221194316_0OLp9 AU0031 2025-02-23T14:04:17.696Z 2025-03-02T15:31:03.476Z
6136020 6136020 20250221193223_ReIeP AU0031 2025-02-23T14:04:01.002Z 2025-03-02T15:31:00.574Z
6114276 6114276 20250218180730_dHqIu AU0031 2025-02-19T14:14:57.729Z 2025-02-26T15:17:52.608Z
6107185 6107185 20250217203454_rwnXM AU0031 2025-02-18T14:00:42.545Z 2025-02-26T15:13:54.760Z
6102987 6102987 20250215210146_LcYHb AU0031 2025-02-16T14:01:02.820Z 2025-02-24T15:22:01.018Z
6102901 6102901 20250215195501_zIEGM AU0031 2025-02-16T14:00:37.023Z 2025-02-24T15:21:53.939Z
6076626 6076626 20250205154121_DqfuS AU0031 2025-02-07T14:31:11.878Z 2025-02-13T14:38:04.830Z
6023746 6023746 20250130183942_cftpJ AU0031 2025-01-31T14:13:39.276Z 2025-02-08T15:12:02.232Z
5997401 5997401 20250126195015_csuiD AU0031 2025-01-27T14:11:09.682Z 2025-02-04T14:33:41.260Z
5997043 5997043 20250126153755_AfJYl AU0031 2025-01-27T14:09:50.829Z 2025-02-04T14:33:36.634Z
5989920 5989920 20250124194905_kPtGQ AU0031 2025-01-25T14:13:25.995Z 2025-02-02T14:37:20.776Z
5975981 5975981 20250122185914_A4l2J AU0031 2025-01-23T14:13:02.442Z 2025-01-31T14:35:29.626Z
5914330 5914330 20250103174604_x9r34 AU0031 2025-01-06T14:11:54.764Z 2025-01-12T14:25:29.577Z
5860347 5860347 20241226184334_mQCmp AU0031 2024-12-28T14:04:49.149Z 2025-01-04T14:40:39.034Z
5537056 5537056 20241112201603_G3xO2 AU0031 2024-11-14T14:10:55.950Z 2024-11-21T14:26:08.608Z
5521786 5521786 20241110181516_TEzzG AU0031 2024-11-12T14:11:58.603Z 2024-11-19T14:21:54.916Z
5508441 5508441 20241109175508_292WT AU0031 2024-11-10T14:07:58.126Z 2024-11-18T14:26:22.733Z
5501128 5501128 20241108202713_IYZxi AU0031 2024-11-09T14:07:43.964Z 2024-11-17T14:23:36.130Z
5487367 5487367 20241106154615_vG43R AU0031 2024-11-07T14:05:38.057Z 2024-11-15T14:24:39.914Z
5480911 5480911 20241105195325_at3FS AU0031 2024-11-06T14:06:59.410Z 2024-11-14T14:23:15.430Z
5480880 5480880 20241105171134_r0gcz AU0031 2024-11-06T14:06:54.677Z 2024-11-14T14:23:08.413Z
5429170 5429170 20241028185603_BxlZX AU0031 2024-10-31T12:16:08.366Z 2024-11-06T14:27:15.491Z
5418306 5418306 20241027201949_4zY5z AU0031 2024-10-30T12:15:23.965Z 2024-11-05T14:27:09.585Z
5417622 5417622 20241027185400_ewgzv AU0031 2024-10-30T12:14:00.641Z 2024-11-05T14:27:07.828Z
5392805 5392805 20241026202336_NbcoH AU0031 2024-10-28T12:08:47.062Z 2024-11-04T14:28:46.482Z
5392393 5392393 20241026163303_gczhI AU0031 2024-10-28T12:07:51.261Z 2024-11-04T14:28:38.440Z
5360567 5360567 20241023163814_DxDLi AU0031 2024-10-25T12:11:13.392Z 2024-11-01T12:26:47.532Z
5310731 5310731 20241014200536_mvL0z AU0031 2024-10-16T12:07:32.262Z 2024-10-23T12:24:37.632Z
5203937 5203937 20240930180803_w5uUH AU0031 2024-10-02T12:10:55.413Z 2024-10-09T12:29:11.112Z
5135283 5135283 20240916173700_7QNCt AU0031 2024-09-19T12:18:17.930Z 2024-09-24T12:16:01.553Z
5131782 5131782 20240915210950_rv7mb AU0031 2024-09-19T12:15:20.539Z 2024-09-24T12:15:36.835Z
5127067 5127067 20240916201943_vQTNR AU0031 2024-09-19T12:08:00.310Z 2024-09-25T12:22:05.868Z
5126809 5126809 20240916193512_O1q65 AU0031 2024-09-19T12:07:18.423Z 2024-09-25T12:22:02.586Z
5072646 5072646 20240911203433_Oe2Aq AU0031 2024-09-15T12:05:57.114Z 2024-09-20T12:21:29.611Z
5072513 5072513 20240911201719_YU3JZ AU0031 2024-09-15T12:05:32.609Z 2024-09-20T12:21:28.772Z
5072436 5072436 20240911200945_CKMIW AU0031 2024-09-15T12:05:22.942Z 2024-09-20T12:21:27.673Z
5072363 5072363 20240911200031_BC5o3 AU0031 2024-09-15T12:05:15.663Z 2024-09-20T12:21:26.967Z
5071447 5071447 20240911165630_Aa1Hw AU0031 2024-09-15T12:02:34.445Z 2024-09-20T12:21:21.168Z
5063336 5063336 20240909204812_M1Cnn AU0031 2024-09-14T12:13:53.906Z 2024-09-18T12:15:13.638Z
5058963 5058963 20240910170447_vNP9m AU0031 2024-09-14T12:05:02.186Z 2024-09-19T12:21:30.266Z
5052314 5052314 20240907201549_5s96Y AU0031 2024-09-13T12:15:03.888Z 2024-09-16T12:21:05.106Z
5052214 5052214 20240907195931_FSqvR AU0031 2024-09-13T12:15:00.459Z 2024-09-16T12:21:04.633Z
5037981 5037981 20240905170945_NOo9s AU0031 2024-09-12T12:14:18.419Z 2024-09-14T12:22:54.864Z
5031258 5031258 20240906210415_hX2as AU0031 2024-09-12T12:04:23.730Z 2024-09-15T12:21:21.862Z
5030657 5030657 20240906172814_s7Y59 AU0031 2024-09-12T12:02:34.799Z 2024-09-15T12:21:19.409Z
5023826 5023826 20240905170945_8N52H AU0031 2024-09-10T12:16:50.568Z 2024-09-11T12:16:31.801Z
5006776 5006776 20240903185641_n9ZFR AU0031 2024-09-09T12:05:03.497Z 2024-09-12T12:19:09.469Z
5005957 5005957 20240903163814_4fAIu AU0031 2024-09-09T12:04:14.508Z 2024-09-12T12:19:07.141Z
4996858 4996858 20240902211845_4wOpg AU0031 2024-09-08T12:05:21.588Z 2024-09-11T12:20:58.515Z
4996472 4996472 20240902194344_9Xqbm AU0031 2024-09-08T12:04:50.953Z 2024-09-11T12:20:54.722Z
4994906 4994906 20240902153400_SuAh8 AU0031 2024-09-08T12:03:05.604Z 2024-09-11T12:20:40.221Z
4988615 4988615 20240901211301_E8Ubj AU0031 2024-09-07T12:07:45.188Z 2024-09-10T12:19:14.792Z
4987547 4987547 20240901175424_p1xkg AU0031 2024-09-07T12:05:55.002Z 2024-09-10T12:19:10.945Z
4987250 4987250 20240901170557_EPyRg AU0031 2024-09-07T12:05:30.550Z 2024-09-10T12:19:10.336Z
4935357 4935357 20240810201147_Q7B8J AU0031 2024-09-01T12:06:24.769Z 2024-09-06T12:20:35.475Z
4935116 4935116 20240810194130_w9Ctf AU0031 2024-09-01T12:06:05.872Z 2024-09-06T12:20:27.681Z
4934726 4934726 20240810185250_rYajD AU0031 2024-09-01T12:05:43.951Z 2024-09-06T12:20:19.260Z
4933743 4933743 20240810172437_YPGnB AU0031 2024-09-01T12:04:36.399Z 2024-09-06T12:19:32.697Z
4912093 4912093 20240809205748_Gm4yy AU0031 2024-08-29T12:08:08.720Z 2024-09-02T12:22:08.169Z
4911898 4911898 20240809204329_3OUTA AU0031 2024-08-29T12:07:58.085Z 2024-09-02T12:22:00.843Z
4911725 4911725 20240809202856_iRScc AU0031 2024-08-29T12:07:43.842Z 2024-09-02T12:21:55.625Z
4911574 4911574 20240809201728_enJHh AU0031 2024-08-29T12:07:34.571Z 2024-09-02T12:21:50.896Z
4910220 4910220 20240809175024_t3uIE AU0031 2024-08-29T12:05:56.340Z 2024-09-02T12:20:34.767Z
4898094 4898094 20240807205128_cqZHo AU0031 2024-08-28T12:16:13.700Z 2024-08-28T12:16:13.700Z
4898082 4898082 20240807204747_0u4lk AU0031 2024-08-28T12:16:12.983Z 2024-08-28T12:16:12.983Z
4897942 4897942 20240807201059_iqODU AU0031 2024-08-28T12:16:06.844Z 2024-08-28T12:16:06.844Z

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