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

279 rows where station_code = "AU0044" 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
8316900 8316900 20251030182126_0ZPgu AU0044 2025-11-01T12:07:44.850Z 2025-11-08T15:11:26.603Z
7944125 7944125 20250923203149_BxZJX AU0044 2025-09-25T12:24:33.428Z 2025-10-02T13:26:23.064Z
7241907 7241907 20250728155232_vGsmu AU0044 2025-07-30T12:02:31.850Z 2025-08-06T12:34:47.597Z
6690569 6690569 20250508215110_ZFCBv AU0044 2025-05-10T12:06:45.548Z 2025-05-17T12:35:22.622Z
6590287 6590287 20250427161727_cNTxf AU0044 2025-04-29T12:12:14.130Z 2025-05-06T12:36:17.411Z
6568138 6568138 20250424201451_3bQip AU0044 2025-04-26T12:20:34.044Z 2025-05-03T12:32:30.177Z
6567726 6567726 20250424184826_ifO7n AU0044 2025-04-26T12:19:24.024Z 2025-05-03T12:32:28.055Z
6523774 6523774 20250419172024_OrtP2 AU0044 2025-04-20T12:03:05.123Z 2025-04-28T12:40:50.640Z
6396098 6396098 20250325172035_vDuvu AU0044 2025-03-27T12:27:37.097Z 2025-04-02T13:40:49.031Z
6390280 6390280 20250325205429_hFnA2 AU0044 2025-03-27T12:03:55.255Z 2025-04-03T12:44:34.816Z
6059078 6059078 20250203190923_FTxbu AU0044 2025-02-05T14:19:08.073Z 2025-02-11T14:42:25.532Z
5063444 5063444 20240909211455_0IcQn AU0044 2024-09-14T12:14:00.059Z 2024-09-18T12:15:13.924Z
5063275 5063275 20240909203527_AJOG5 AU0044 2024-09-14T12:13:48.467Z 2024-09-18T12:15:13.499Z
4420446 4420446 20240605192134_s18UD AU0044 2024-06-07T12:04:03.343Z 2024-06-14T12:08:16.133Z
4418834 4418834 20240531204152_gZYL0 AU0044 2024-06-06T12:13:08.137Z 2024-06-09T12:06:00.337Z
4418830 4418830 20240531202447_wHROx AU0044 2024-06-06T12:13:07.763Z 2024-06-09T12:06:00.298Z
4418826 4418826 20240531200045_iWhsW AU0044 2024-06-06T12:13:07.465Z 2024-06-09T12:06:00.264Z
4418819 4418819 20240531194440_IxWSB AU0044 2024-06-06T12:13:07.203Z 2024-06-09T12:06:00.207Z
4418743 4418743 20240602202529_SmbzJ AU0044 2024-06-06T12:11:13.859Z 2024-06-11T12:13:32.497Z
4418711 4418711 20240602160835_SbZan AU0044 2024-06-06T12:11:04.625Z 2024-06-11T12:13:30.107Z
4415850 4415850 20240604215450_p9G22 AU0044 2024-06-06T12:05:26.863Z 2024-06-13T12:08:30.803Z
4401689 4401689 20240531180910_3nLo4 AU0044 2024-06-03T12:09:06.782Z 2024-06-09T12:05:59.988Z
4394517 4394517 20240528170206_R8Bt3 AU0044 2024-05-31T12:11:32.731Z 2024-06-06T12:14:25.771Z
4393717 4393717 20240529214836_nRwEO AU0044 2024-05-31T12:08:45.666Z 2024-06-07T12:16:00.780Z
4393354 4393354 20240529174816_Ew6qm AU0044 2024-05-31T12:08:04.721Z 2024-06-07T12:15:59.434Z
4367859 4367859 20240517215124_dGEqw AU0044 2024-05-26T12:05:21.924Z 2024-05-26T12:09:52.802Z
4367485 4367485 20240517203811_0j0ni AU0044 2024-05-26T12:04:37.803Z 2024-05-26T12:09:52.702Z
4365493 4365493 20240518210555_martF AU0044 2024-05-26T12:00:52.498Z 2024-05-27T12:10:20.031Z
4365439 4365439 20240518204731_eH0I7 AU0044 2024-05-26T12:00:45.967Z 2024-05-27T12:10:17.924Z
4365227 4365227 20240518193457_hrZqS AU0044 2024-05-26T12:00:12.190Z 2024-05-27T12:10:10.283Z
4365214 4365214 20240518193122_tqG2n AU0044 2024-05-26T12:00:09.193Z 2024-05-27T12:10:10.005Z
4362351 4362351 20240516112929_6ZLWu AU0044 2024-05-25T12:05:39.749Z 2024-05-25T12:05:39.749Z
4360649 4360649 20240516203851_pDmgg AU0044 2024-05-25T12:02:25.303Z 2024-05-25T12:09:10.481Z
4360631 4360631 20240516202953_5hGk1 AU0044 2024-05-25T12:02:21.926Z 2024-05-25T12:09:10.477Z
4360591 4360591 20240516201542_36s3B AU0044 2024-05-25T12:02:18.333Z 2024-05-25T12:09:10.466Z
4360528 4360528 20240516195015_2UKNB AU0044 2024-05-25T12:02:09.788Z 2024-05-25T12:09:10.450Z
4360479 4360479 20240516192509_lWQoW AU0044 2024-05-25T12:02:03.318Z 2024-05-25T12:09:10.435Z
4359790 4359790 20240516174929_L1E5G AU0044 2024-05-25T12:00:37.167Z 2024-05-25T12:09:10.288Z
4359194 4359194 20240511114825_vg220 AU0044 2024-05-22T12:13:30.206Z 2024-05-22T12:13:30.206Z
4358977 4358977 20240511110854_KTvlM AU0044 2024-05-22T12:13:14.947Z 2024-05-22T12:13:14.947Z
4321504 4321504 20240507214510_5Eg9u AU0044 2024-05-16T12:08:37.180Z 2024-05-17T12:11:58.692Z
4321353 4321353 20240507213304_RCy0j AU0044 2024-05-16T12:08:25.622Z 2024-05-17T12:11:55.049Z
4321197 4321197 20240507211843_xj7dO AU0044 2024-05-16T12:08:16.521Z 2024-05-17T12:11:52.755Z
4321194 4321194 20240507211832_HFJq2 AU0044 2024-05-16T12:08:16.437Z 2024-05-17T12:11:52.751Z
4321067 4321067 20240507210621_lZ9Jq AU0044 2024-05-16T12:08:12.216Z 2024-05-17T12:11:51.414Z
4321031 4321031 20240507210025_KsOGn AU0044 2024-05-16T12:08:10.977Z 2024-05-17T12:11:51.141Z
4320985 4320985 20240507205713_HqKRw AU0044 2024-05-16T12:08:09.406Z 2024-05-17T12:11:50.411Z
4320556 4320556 20240507200340_Tm6pV AU0044 2024-05-16T12:07:40.828Z 2024-05-17T12:11:42.149Z
4320513 4320513 20240507200028_QnYUt AU0044 2024-05-16T12:07:37.475Z 2024-05-17T12:11:41.170Z
4320352 4320352 20240507193826_YMGX4 AU0044 2024-05-16T12:07:28.007Z 2024-05-17T12:11:39.031Z
4319893 4319893 20240507184506_ZDN1L AU0044 2024-05-16T12:06:51.647Z 2024-05-17T12:11:31.463Z
4319773 4319773 20240507183205_pQIIt AU0044 2024-05-16T12:06:42.095Z 2024-05-17T12:11:28.871Z
4316942 4316942 20240507165147_3alXC AU0044 2024-05-16T12:03:13.226Z 2024-05-17T12:10:55.433Z
4309359 4309359 20240506214730_yGfxR AU0044 2024-05-14T12:08:56.442Z 2024-05-16T12:13:16.045Z
4308921 4308921 20240506210839_2RphD AU0044 2024-05-14T12:08:27.981Z 2024-05-16T12:13:11.875Z
4308763 4308763 20240506205157_lW6SR AU0044 2024-05-14T12:08:20.077Z 2024-05-16T12:13:10.309Z
4308720 4308720 20240506204757_BQ18f AU0044 2024-05-14T12:08:16.404Z 2024-05-16T12:13:09.775Z
4308622 4308622 20240506203425_FiAz7 AU0044 2024-05-14T12:08:12.265Z 2024-05-16T12:13:08.992Z
4308428 4308428 20240506200913_ctG63 AU0044 2024-05-14T12:08:02.143Z 2024-05-16T12:13:07.422Z
4308218 4308218 20240506195038_PutEt AU0044 2024-05-14T12:07:56.160Z 2024-05-16T12:13:06.272Z
4308088 4308088 20240506193322_XSeDG AU0044 2024-05-14T12:07:48.058Z 2024-05-16T12:13:05.665Z
4307981 4307981 20240506192312_2x1DY AU0044 2024-05-14T12:07:43.420Z 2024-05-16T12:13:05.212Z
4307976 4307976 20240506192224_TXjaE AU0044 2024-05-14T12:07:43.015Z 2024-05-16T12:13:05.178Z
4307641 4307641 20240506183434_bnN82 AU0044 2024-05-14T12:07:15.381Z 2024-05-16T12:13:02.454Z
4306511 4306511 20240506170749_KIJ6J AU0044 2024-05-14T12:05:46.643Z 2024-05-16T12:12:52.383Z
4305568 4305568 20240506154346_z2hDi AU0044 2024-05-14T12:04:06.105Z 2024-05-16T12:12:44.189Z
4305222 4305222 20240506150704_5tgwW AU0044 2024-05-14T12:03:26.604Z 2024-05-16T12:12:38.879Z
4294463 4294463 20240504214302_qQPAa AU0044 2024-05-08T12:08:55.161Z 2024-05-13T12:11:13.155Z
4294409 4294409 20240504213721_yBMhz AU0044 2024-05-08T12:08:51.001Z 2024-05-13T12:11:09.097Z
4294329 4294329 20240504213052_f4okh AU0044 2024-05-08T12:08:47.537Z 2024-05-13T12:11:07.313Z
4293847 4293847 20240504204954_IByBh AU0044 2024-05-08T12:07:59.898Z 2024-05-13T12:10:49.723Z
4293674 4293674 20240504203051_otA3O AU0044 2024-05-08T12:07:45.889Z 2024-05-13T12:10:46.110Z
4293651 4293651 20240504202741_Y1aQx AU0044 2024-05-08T12:07:44.374Z 2024-05-13T12:10:45.385Z
4293649 4293649 20240504202734_2tpUI AU0044 2024-05-08T12:07:44.265Z 2024-05-13T12:10:45.357Z
4293590 4293590 20240504201946_2jom3 AU0044 2024-05-08T12:07:39.627Z 2024-05-13T12:10:43.512Z
4293588 4293588 20240504201946_jgJrc AU0044 2024-05-08T12:07:39.514Z 2024-05-13T12:10:43.460Z
4293495 4293495 20240504200803_IebIn AU0044 2024-05-08T12:07:33.691Z 2024-05-13T12:10:41.928Z
4293486 4293486 20240504200621_bWpw2 AU0044 2024-05-08T12:07:33.282Z 2024-05-13T12:10:41.843Z
4293371 4293371 20240504195443_jdPJA AU0044 2024-05-08T12:07:26.190Z 2024-05-13T12:10:39.562Z
4293186 4293186 20240504192633_3zgzT AU0044 2024-05-08T12:07:04.018Z 2024-05-13T12:10:35.998Z
4292970 4292970 20240504184556_Gmg9J AU0044 2024-05-08T12:06:38.066Z 2024-05-13T12:10:31.857Z
4292968 4292968 20240504184545_eU8cH AU0044 2024-05-08T12:06:37.868Z 2024-05-13T12:10:31.819Z
4292879 4292879 20240504182441_T8bwN AU0044 2024-05-08T12:06:30.351Z 2024-05-13T12:10:30.120Z
4292681 4292681 20240504175908_uJj84 AU0044 2024-05-08T12:06:12.525Z 2024-05-13T12:10:26.368Z
4292416 4292416 20240504174048_ZfEfo AU0044 2024-05-08T12:05:41.196Z 2024-05-13T12:10:21.471Z
4290397 4290397 20240503214441_N3WyV AU0044 2024-05-07T12:12:16.936Z 2024-05-12T12:19:37.205Z
4290395 4290395 20240503213813_BSgTe AU0044 2024-05-07T12:12:16.230Z 2024-05-12T12:19:36.848Z
4290383 4290383 20240503205928_6fePo AU0044 2024-05-07T12:12:09.423Z 2024-05-12T12:19:27.243Z
4290366 4290366 20240503195129_OtDZP AU0044 2024-05-07T12:11:59.252Z 2024-05-12T12:19:07.932Z
4290364 4290364 20240503195004_1flF1 AU0044 2024-05-07T12:11:59.071Z 2024-05-12T12:19:07.707Z
4290360 4290360 20240503192011_0V1an AU0044 2024-05-07T12:11:54.598Z 2024-05-12T12:19:00.619Z
4289415 4289415 20240504163221_GApGY AU0044 2024-05-07T12:07:38.705Z 2024-05-13T12:09:37.904Z
4288513 4288513 20240504152748_2COZd AU0044 2024-05-07T12:06:42.384Z 2024-05-13T12:09:12.862Z
4287945 4287945 20240504141905_3epuR AU0044 2024-05-07T12:05:47.727Z 2024-05-13T12:08:59.853Z
4287754 4287754 20240504134926_Uh3d4 AU0044 2024-05-07T12:05:27.536Z 2024-05-13T12:08:55.276Z
4287221 4287221 20240504120504_2cVPh AU0044 2024-05-07T12:04:36.066Z 2024-05-13T12:08:28.709Z
4284238 4284238 20240503211637_ZP02I AU0044 2024-05-06T12:12:22.624Z 2024-05-12T12:19:30.910Z
4284055 4284055 20240503204758_kgaEy AU0044 2024-05-06T12:12:09.670Z 2024-05-12T12:19:23.515Z
4283627 4283627 20240503194728_AODgQ AU0044 2024-05-06T12:11:44.575Z 2024-05-12T12:19:07.196Z
4283356 4283356 20240503191319_PBa2y AU0044 2024-05-06T12:11:34.757Z 2024-05-12T12:18:59.853Z

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