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

1,599 rows where station_code = "AU0045" 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
6801100 6801100 20250524150036_sqeW9 AU0045 2025-05-26T12:14:42.647Z 2025-06-02T13:00:18.091Z
6800899 6800899 20250524144025_3TYm4 AU0045 2025-05-26T12:14:19.334Z 2025-06-02T13:00:10.684Z
6800793 6800793 20250524142715_2lTWu AU0045 2025-05-26T12:14:11.514Z 2025-06-02T13:00:07.002Z
6800650 6800650 20250524140801_E1kqT AU0045 2025-05-26T12:13:56.923Z 2025-06-02T12:59:57.800Z
6800403 6800403 20250524133626_qgCYb AU0045 2025-05-26T12:13:19.636Z 2025-06-02T12:59:36.823Z
6799488 6799488 20250524094417_ODBC4 AU0045 2025-05-26T12:09:27.766Z 2025-06-02T12:57:57.540Z
6799484 6799484 20250524093110_AwZQE AU0045 2025-05-26T12:09:17.083Z 2025-06-02T12:57:55.291Z
6799482 6799482 20250524092509_qjEjg AU0045 2025-05-26T12:09:12.642Z 2025-06-02T12:57:54.179Z
6779248 6779248 20250521195728_qqncu AU0045 2025-05-23T12:22:02.235Z 2025-05-30T13:08:04.090Z
6775591 6775591 20250521130207_zX7sk AU0045 2025-05-23T12:15:34.750Z 2025-05-30T13:04:53.520Z
6775272 6775272 20250521094133_JCee9 AU0045 2025-05-23T12:12:25.396Z 2025-05-30T13:03:21.802Z
6769840 6769840 20250520191659_5kBxg AU0045 2025-05-22T12:20:02.629Z 2025-05-29T13:08:01.563Z
6769783 6769783 20250520185934_I4Wj9 AU0045 2025-05-22T12:19:52.429Z 2025-05-29T13:07:59.484Z
6769775 6769775 20250520185258_Kv8vO AU0045 2025-05-22T12:19:50.554Z 2025-05-29T13:07:58.728Z
6769517 6769517 20250520175846_M0mb2 AU0045 2025-05-22T12:19:22.274Z 2025-05-29T13:07:44.914Z
6768862 6768862 20250520162906_I1Zen AU0045 2025-05-22T12:17:10.651Z 2025-05-29T13:06:26.017Z
6768466 6768466 20250520153545_qHkpU AU0045 2025-05-22T12:16:15.086Z 2025-05-29T13:05:42.978Z
6768358 6768358 20250520151920_w5IgL AU0045 2025-05-22T12:15:45.918Z 2025-05-29T13:05:36.473Z
6768320 6768320 20250520150857_E35FY AU0045 2025-05-22T12:15:39.838Z 2025-05-29T13:05:34.839Z
6768077 6768077 20250520142652_XuIKW AU0045 2025-05-22T12:15:07.872Z 2025-05-29T13:05:03.912Z
6768061 6768061 20250520142339_mnyK5 AU0045 2025-05-22T12:15:02.148Z 2025-05-29T13:05:03.343Z
6767923 6767923 20250520135105_xKS1S AU0045 2025-05-22T12:14:25.235Z 2025-05-29T13:04:48.104Z
6767791 6767791 20250520132110_TNsYz AU0045 2025-05-22T12:14:13.341Z 2025-05-29T13:04:23.897Z
6767671 6767671 20250520125129_6Raga AU0045 2025-05-22T12:13:46.151Z 2025-05-29T13:04:15.442Z
6767606 6767606 20250520123812_VIhkE AU0045 2025-05-22T12:13:33.684Z 2025-05-29T13:04:11.210Z
6767285 6767285 20250520103859_3HGc3 AU0045 2025-05-22T12:12:34.672Z 2025-05-29T13:03:16.363Z
6767147 6767147 20250520092207_B5aql AU0045 2025-05-22T12:11:51.717Z 2025-05-29T13:03:01.242Z
6767105 6767105 20250520085037_c55dx AU0045 2025-05-22T12:11:32.363Z 2025-05-29T13:02:40.103Z
6760158 6760158 20250519201921_ndsl3 AU0045 2025-05-21T12:19:05.434Z 2025-05-28T13:12:08.464Z
6760119 6760119 20250519200353_a4KIs AU0045 2025-05-21T12:19:01.233Z 2025-05-28T13:12:03.271Z
6760010 6760010 20250519193437_mx6KE AU0045 2025-05-21T12:18:46.220Z 2025-05-28T13:11:55.832Z
6759943 6759943 20250519185827_wz1Ni AU0045 2025-05-21T12:18:31.143Z 2025-05-28T13:11:53.616Z
6759927 6759927 20250519185322_n38DO AU0045 2025-05-21T12:18:26.235Z 2025-05-28T13:11:53.083Z
6759877 6759877 20250519183911_qIXFw AU0045 2025-05-21T12:18:14.684Z 2025-05-28T13:11:48.990Z
6759806 6759806 20250519181245_ongis AU0045 2025-05-21T12:17:54.537Z 2025-05-28T13:11:44.291Z
6759800 6759800 20250519181219_nuGPr AU0045 2025-05-21T12:17:53.993Z 2025-05-28T13:11:43.713Z
6759770 6759770 20250519180808_WtlTC AU0045 2025-05-21T12:17:51.046Z 2025-05-28T13:11:41.751Z
6759698 6759698 20250519175157_iWoZk AU0045 2025-05-21T12:17:43.108Z 2025-05-28T13:11:35.849Z
6759510 6759510 20250519165750_v1Oq0 AU0045 2025-05-21T12:17:07.876Z 2025-05-28T13:10:49.503Z
6759467 6759467 20250519164851_FtJDk AU0045 2025-05-21T12:16:58.768Z 2025-05-28T13:10:44.053Z
6759321 6759321 20250519160110_2Dq38 AU0045 2025-05-21T12:16:31.870Z 2025-05-28T13:10:13.262Z
6759097 6759097 20250519150101_NnivZ AU0045 2025-05-21T12:15:59.888Z 2025-05-28T13:09:43.753Z
6758918 6758918 20250519140425_nkkI1 AU0045 2025-05-21T12:15:23.450Z 2025-05-28T13:09:31.379Z
6758839 6758839 20250519133143_tP5FO AU0045 2025-05-21T12:15:04.147Z 2025-05-28T13:09:26.851Z
6758609 6758609 20250519115518_raZfU AU0045 2025-05-21T12:14:17.919Z 2025-05-28T13:08:41.870Z
6758544 6758544 20250519112715_Q5PCl AU0045 2025-05-21T12:13:54.445Z 2025-05-28T13:08:34.114Z
6758450 6758450 20250519103208_e6Cx6 AU0045 2025-05-21T12:13:31.487Z 2025-05-28T13:08:24.069Z
6752356 6752356 20250518192814_Qd2sf AU0045 2025-05-20T12:16:20.289Z 2025-05-27T13:19:54.733Z
6752246 6752246 20250518184007_mpFjg AU0045 2025-05-20T12:16:04.383Z 2025-05-27T13:19:15.445Z
6752139 6752139 20250518180338_267se AU0045 2025-05-20T12:15:27.825Z 2025-05-27T13:19:07.044Z
6752112 6752112 20250518175003_CFqVI AU0045 2025-05-20T12:15:21.046Z 2025-05-27T13:19:04.182Z
6752110 6752110 20250518174932_Uw1uN AU0045 2025-05-20T12:15:20.831Z 2025-05-27T13:19:04.069Z
6752079 6752079 20250518173521_HFvKA AU0045 2025-05-20T12:15:14.197Z 2025-05-27T13:19:01.199Z
6751952 6751952 20250518161114_XcB0O AU0045 2025-05-20T12:14:34.074Z 2025-05-27T13:18:18.716Z
6751784 6751784 20250518145720_gNFCF AU0045 2025-05-20T12:14:05.561Z 2025-05-27T13:17:43.971Z
6751662 6751662 20250518142245_fp5r5 AU0045 2025-05-20T12:13:32.042Z 2025-05-27T13:17:34.996Z
6751637 6751637 20250518140939_kJhZE AU0045 2025-05-20T12:13:26.652Z 2025-05-27T13:17:33.811Z
6751609 6751609 20250518135750_wG7aA AU0045 2025-05-20T12:13:22.773Z 2025-05-27T13:17:31.797Z
6751544 6751544 20250518131522_P0Ds4 AU0045 2025-05-20T12:13:11.606Z 2025-05-27T13:17:26.156Z
6751500 6751500 20250518130013_OtLdA AU0045 2025-05-20T12:13:01.326Z 2025-05-27T13:17:13.003Z
6751424 6751424 20250518122340_Jt3jh AU0045 2025-05-20T12:12:41.813Z 2025-05-27T13:17:08.100Z
6751394 6751394 20250518120700_L0Dvu AU0045 2025-05-20T12:12:37.135Z 2025-05-27T13:17:03.399Z
6751360 6751360 20250518114104_zyr3i AU0045 2025-05-20T12:12:31.619Z 2025-05-27T13:16:47.089Z
6751295 6751295 20250518084543_Z1KgW AU0045 2025-05-20T12:12:00.194Z 2025-05-27T13:16:28.785Z
6744657 6744657 20250518195623_QjGD3 AU0045 2025-05-19T12:08:17.748Z 2025-05-27T13:19:57.915Z
6744645 6744645 20250518192811_HBwGi AU0045 2025-05-19T12:08:15.989Z 2025-05-27T13:19:54.517Z
6744384 6744384 20250518180506_Z3eeT AU0045 2025-05-19T12:07:31.096Z 2025-05-27T13:19:07.441Z
6744359 6744359 20250518175938_QuY0I AU0045 2025-05-19T12:07:27.657Z 2025-05-27T13:19:06.023Z
6744332 6744332 20250518175213_PccCQ AU0045 2025-05-19T12:07:23.663Z 2025-05-27T13:19:04.567Z
6743266 6743266 20250518104924_cxHGR AU0045 2025-05-19T12:03:55.884Z 2025-05-27T13:16:38.067Z
6739875 6739875 20250517183841_3c4Pp AU0045 2025-05-18T12:07:05.831Z 2025-05-25T12:38:15.280Z
6739857 6739857 20250517180820_KwsZs AU0045 2025-05-18T12:06:57.064Z 2025-05-25T12:38:14.508Z
6739853 6739853 20250517180329_p0wmq AU0045 2025-05-18T12:06:55.783Z 2025-05-18T12:20:22.714Z
6739805 6739805 20250517170552_t3qs5 AU0045 2025-05-18T12:06:45.125Z 2025-05-18T12:20:22.700Z
6739789 6739789 20250517163641_Goglb AU0045 2025-05-18T12:06:41.029Z 2025-05-25T12:38:12.499Z
6739785 6739785 20250517162157_Qo1cq AU0045 2025-05-18T12:06:40.146Z 2025-05-25T12:38:11.963Z
6739771 6739771 20250517152325_4F4IE AU0045 2025-05-18T12:06:37.444Z 2025-05-25T12:38:11.590Z
6739735 6739735 20250517141818_kzreQ AU0045 2025-05-18T12:06:30.166Z 2025-05-25T12:38:10.786Z
6739697 6739697 20250517131634_gOsmz AU0045 2025-05-18T12:06:23.339Z 2025-05-25T12:38:09.882Z
6739657 6739657 20250517123756_7AEdL AU0045 2025-05-18T12:06:06.105Z 2025-05-18T12:20:22.647Z
6739620 6739620 20250517112829_HTH92 AU0045 2025-05-18T12:05:57.700Z 2025-05-18T12:20:22.632Z
6739589 6739589 20250517111104_2f2c7 AU0045 2025-05-18T12:05:51.542Z 2025-05-25T12:38:06.670Z
6739365 6739365 20250517094217_kqmZ2 AU0045 2025-05-18T12:05:11.398Z 2025-05-25T12:38:02.589Z
6736614 6736614 20250516195534_0e3YJ AU0045 2025-05-17T12:15:44.343Z 2025-05-24T12:40:48.253Z
6734273 6734273 20250516112325_2bxJC AU0045 2025-05-17T12:10:44.859Z 2025-05-24T12:40:28.674Z
6733773 6733773 20250516103247_d9eOH AU0045 2025-05-17T12:09:37.228Z 2025-05-17T12:23:15.312Z
6733601 6733601 20250516100402_eSFsH AU0045 2025-05-17T12:09:07.307Z 2025-05-17T12:23:15.270Z
6733587 6733587 20250516100219_81Ecw AU0045 2025-05-17T12:09:05.441Z 2025-05-24T12:40:23.617Z
6729923 6729923 20250514190235_vPjSy AU0045 2025-05-16T12:19:31.816Z 2025-05-22T12:36:46.382Z
6729370 6729370 20250514160402_83fjk AU0045 2025-05-16T12:18:24.018Z 2025-05-22T12:36:43.315Z
6729308 6729308 20250514154313_ldJBa AU0045 2025-05-16T12:18:19.362Z 2025-05-22T12:36:43.076Z
6729150 6729150 20250514144050_oiUHN AU0045 2025-05-16T12:17:48.252Z 2025-05-22T12:36:42.174Z
6729122 6729122 20250514142821_Z1xdY AU0045 2025-05-16T12:17:42.035Z 2025-05-22T12:36:42.043Z
6729065 6729065 20250514140553_fFDJY AU0045 2025-05-16T12:17:33.587Z 2025-05-22T12:36:40.929Z
6728661 6728661 20250514104611_0rUCT AU0045 2025-05-16T12:16:37.953Z 2025-05-22T12:36:38.116Z
6728147 6728147 20250515200434_YcQUL AU0045 2025-05-16T12:13:32.247Z 2025-05-16T12:21:02.872Z
6728126 6728126 20250515191019_6E2hv AU0045 2025-05-16T12:13:26.170Z 2025-05-23T12:36:54.076Z
6728112 6728112 20250515185052_F8MrU AU0045 2025-05-16T12:13:24.294Z 2025-05-23T12:36:53.196Z
6728098 6728098 20250515183015_qtmUF AU0045 2025-05-16T12:13:21.099Z 2025-05-16T12:21:02.858Z
6728058 6728058 20250515181139_mqnm5 AU0045 2025-05-16T12:13:15.765Z 2025-05-23T12:36:52.691Z

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