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

9,311 rows where station_code = "AU000B" 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
8750071 8750071 20251209170403_zD2Ha AU000B 2025-12-13T15:37:21.744Z 2025-12-14T15:42:58.216Z
8749742 8749742 20251209153434_3sKMS AU000B 2025-12-13T15:36:56.242Z 2025-12-14T15:42:29.114Z
8749634 8749634 20251209151820_zS02m AU000B 2025-12-13T15:36:50.942Z 2025-12-14T15:42:25.594Z
8749345 8749345 20251209143744_tXycv AU000B 2025-12-13T15:36:14.383Z 2025-12-14T15:42:10.558Z
8748865 8748865 20251209133033_2309R AU000B 2025-12-13T15:35:27.451Z 2025-12-14T15:41:31.455Z
8748357 8748357 20251209122133_TFRiw AU000B 2025-12-13T15:34:20.405Z 2025-12-14T15:40:49.119Z
8739861 8739861 20251210173659_Po4DT AU000B 2025-12-13T15:17:26.776Z 2025-12-14T15:28:54.623Z
8739793 8739793 20251210172410_ASexD AU000B 2025-12-13T15:17:05.650Z 2025-12-14T15:28:35.461Z
8739699 8739699 20251210170338_9SKze AU000B 2025-12-13T15:16:55.964Z 2025-12-14T15:28:27.017Z
8739688 8739688 20251210165943_ocVlC AU000B 2025-12-13T15:16:55.200Z 2025-12-14T15:28:26.285Z
8739638 8739638 20251210164445_ugYei AU000B 2025-12-13T15:16:51.579Z 2025-12-14T15:28:21.450Z
8739607 8739607 20251210163048_VH8SN AU000B 2025-12-13T15:16:48.669Z 2025-12-14T15:28:19.903Z
8739552 8739552 20251210160314_aq623 AU000B 2025-12-13T15:16:38.702Z 2025-12-14T15:28:17.284Z
8739527 8739527 20251210155352_DK7xO AU000B 2025-12-13T15:16:36.424Z 2025-12-14T15:28:16.172Z
8739510 8739510 20251210155057_CVp8Y AU000B 2025-12-13T15:16:21.456Z 2025-12-14T15:28:15.619Z
8739177 8739177 20251210145057_gfiZf AU000B 2025-12-13T15:15:57.512Z 2025-12-14T15:27:55.847Z
8734084 8734084 20251211174201_939ub AU000B 2025-12-13T14:50:07.530Z 2025-12-14T15:16:15.888Z
8734014 8734014 20251211173444_90bi3 AU000B 2025-12-13T14:50:00.685Z 2025-12-14T15:16:15.862Z
8733950 8733950 20251211172750_IJ0cK AU000B 2025-12-13T14:49:53.327Z 2025-12-14T15:16:15.841Z
8733791 8733791 20251211171137_guuxv AU000B 2025-12-13T14:49:23.515Z 2025-12-14T15:16:15.789Z
8733689 8733689 20251211170116_vobpd AU000B 2025-12-13T14:49:01.379Z 2025-12-14T15:16:15.758Z
8733685 8733685 20251211170036_ziiLs AU000B 2025-12-13T14:49:01.016Z 2025-12-14T15:16:15.756Z
8733616 8733616 20251211165255_Tjd1G AU000B 2025-12-13T14:48:53.913Z 2025-12-14T15:16:15.734Z
8733399 8733399 20251211162516_cz6iv AU000B 2025-12-13T14:48:23.239Z 2025-12-14T15:16:15.652Z
8733382 8733382 20251211162407_28oft AU000B 2025-12-13T14:48:22.382Z 2025-12-14T15:16:15.645Z
8733236 8733236 20251211155949_OkUar AU000B 2025-12-13T14:48:07.620Z 2025-12-14T15:16:15.337Z
8733233 8733233 20251211155929_ThFAg AU000B 2025-12-13T14:48:07.253Z 2025-12-14T15:16:15.336Z
8733196 8733196 20251211154942_S3BRZ AU000B 2025-12-13T14:47:57.020Z 2025-12-14T15:16:15.323Z
8732948 8732948 20251211152505_E3vMi AU000B 2025-12-13T14:47:29.874Z 2025-12-14T15:16:15.176Z
8732221 8732221 20251211142337_z695g AU000B 2025-12-13T14:45:16.781Z 2025-12-14T15:16:14.938Z
8731762 8731762 20251211132317_aguob AU000B 2025-12-13T14:43:39.166Z 2025-12-14T15:16:14.772Z
8731557 8731557 20251211130936_L1VDo AU000B 2025-12-13T14:42:50.825Z 2025-12-14T15:16:14.686Z
8730890 8730890 20251211121201_pKhP9 AU000B 2025-12-13T14:40:01.305Z 2025-12-14T15:16:14.116Z
8730755 8730755 20251211110935_EOYkj AU000B 2025-12-13T14:36:19.910Z 2025-12-14T15:16:13.818Z
8719638 8719638 20251210144531_d3DAD AU000B 2025-12-11T14:20:36.210Z 2025-12-14T15:27:47.787Z
8719530 8719530 20251210142622_T2KZO AU000B 2025-12-11T14:20:27.863Z 2025-12-14T15:27:39.517Z
8719460 8719460 20251210141021_ZvjOc AU000B 2025-12-11T14:20:10.176Z 2025-12-14T15:27:34.702Z
8719264 8719264 20251210134046_2WGuT AU000B 2025-12-11T14:19:36.332Z 2025-12-14T15:27:26.245Z
8719231 8719231 20251210133543_fN083 AU000B 2025-12-11T14:19:32.368Z 2025-12-14T15:27:24.672Z
8718930 8718930 20251210130436_xylwF AU000B 2025-12-11T14:18:41.280Z 2025-12-14T15:27:02.236Z
8718924 8718924 20251210130429_PMg3Z AU000B 2025-12-11T14:18:40.320Z 2025-12-14T15:27:01.890Z
8718593 8718593 20251210123900_tNGHl AU000B 2025-12-11T14:17:37.532Z 2025-12-14T15:26:49.794Z
8718509 8718509 20251210123319_H0eXb AU000B 2025-12-11T14:17:15.980Z 2025-12-14T15:26:45.664Z
8718504 8718504 20251210123313_4r8Zm AU000B 2025-12-11T14:17:14.966Z 2025-12-14T15:26:45.059Z
8704424 8704424 20251208153507_0LFQ1 AU000B 2025-12-09T14:14:29.783Z 2025-12-14T15:52:12.033Z
8703301 8703301 20251208130736_zIKjf AU000B 2025-12-09T14:11:25.562Z 2025-12-14T15:51:13.637Z
8703097 8703097 20251208123555_uHpe2 AU000B 2025-12-09T14:10:42.204Z 2025-12-14T15:50:52.467Z
8702883 8702883 20251208121127_IG3kR AU000B 2025-12-09T14:09:59.980Z 2025-12-14T15:50:47.121Z
8702229 8702229 20251208110425_krFyg AU000B 2025-12-09T14:07:56.625Z 2025-12-14T15:50:12.061Z
8701979 8701979 20251208104100_WJwX3 AU000B 2025-12-09T14:07:01.980Z 2025-12-14T15:49:42.126Z
8696226 8696226 20251207112422_f1Kx6 AU000B 2025-12-08T14:06:41.784Z 2025-12-14T15:56:51.406Z
8696150 8696150 20251207111313_efqeC AU000B 2025-12-08T14:06:28.167Z 2025-12-14T15:56:49.862Z
8696036 8696036 20251207105925_gp1Z9 AU000B 2025-12-08T14:06:04.381Z 2025-12-14T15:56:47.664Z
8692873 8692873 20251206115850_7ZJoi AU000B 2025-12-07T14:05:01.056Z 2025-12-14T16:02:33.589Z
8692654 8692654 20251206110242_Nc2Gm AU000B 2025-12-07T14:04:06.360Z 2025-12-14T16:02:09.911Z
8678302 8678302 20251203171815_2fFhe AU000B 2025-12-04T14:04:15.695Z 2025-12-11T14:40:48.021Z
8673268 8673268 20251201175721_cLqny AU000B 2025-12-03T14:18:08.759Z 2025-12-10T14:38:17.039Z
8673200 8673200 20251201173012_xV2Vk AU000B 2025-12-03T14:17:57.080Z 2025-12-10T14:38:14.851Z
8673139 8673139 20251201170829_uk2fb AU000B 2025-12-03T14:17:39.057Z 2025-12-10T14:38:13.342Z
8673136 8673136 20251201170754_I8Kya AU000B 2025-12-03T14:17:38.828Z 2025-12-10T14:38:13.306Z
8673126 8673126 20251201170602_MgDxa AU000B 2025-12-03T14:17:37.645Z 2025-12-10T14:38:13.129Z
8673059 8673059 20251201163920_robAs AU000B 2025-12-03T14:17:16.064Z 2025-12-10T14:38:11.669Z
8673045 8673045 20251201163049_Hb2VV AU000B 2025-12-03T14:17:14.369Z 2025-12-10T14:38:11.435Z
8673033 8673033 20251201162638_qCqnq AU000B 2025-12-03T14:17:09.611Z 2025-12-10T14:38:11.245Z
8670357 8670357 20251202174053_Z3h92 AU000B 2025-12-03T14:08:09.868Z 2025-12-11T14:44:23.876Z
8670355 8670355 20251202173931_eQwCi AU000B 2025-12-03T14:08:09.438Z 2025-12-11T14:44:23.730Z
8670306 8670306 20251202162600_iDBz5 AU000B 2025-12-03T14:07:55.487Z 2025-12-11T14:43:52.910Z
8670284 8670284 20251202160228_sUe72 AU000B 2025-12-03T14:07:50.444Z 2025-12-11T14:43:51.786Z
8670230 8670230 20251202153530_yvrWq AU000B 2025-12-03T14:07:33.120Z 2025-12-11T14:43:49.615Z
8621873 8621873 20251126164848_V9Y5h AU000B 2025-11-28T14:16:56.339Z 2025-12-05T15:02:48.853Z
8621781 8621781 20251126162413_2eedL AU000B 2025-11-28T14:16:35.367Z 2025-12-05T15:02:47.797Z
8621643 8621643 20251126155627_TJN1b AU000B 2025-11-28T14:16:18.885Z 2025-12-05T15:02:46.316Z
8621008 8621008 20251126141451_eK0aZ AU000B 2025-11-28T14:14:32.200Z 2025-12-05T15:02:39.692Z
8619782 8619782 20251126110009_Kabij AU000B 2025-11-28T14:10:24.939Z 2025-12-05T15:01:09.108Z
8619040 8619040 20251127171916_TtjEe AU000B 2025-11-28T14:07:01.353Z 2025-12-06T14:59:26.131Z
8619018 8619018 20251127164508_B3DYY AU000B 2025-11-28T14:06:56.109Z 2025-12-06T14:59:12.463Z
8618998 8618998 20251127161643_wn88I AU000B 2025-11-28T14:06:44.701Z 2025-12-06T14:59:05.084Z
8618965 8618965 20251127151738_mMgDW AU000B 2025-11-28T14:06:35.476Z 2025-12-06T14:59:00.119Z
8618892 8618892 20251127143001_kAsTp AU000B 2025-11-28T14:06:13.400Z 2025-12-06T14:58:57.082Z
8617829 8617829 20251127103737_3t8fD AU000B 2025-11-28T14:02:31.406Z 2025-12-06T14:58:24.968Z
8606067 8606067 20251125174709_spodE AU000B 2025-11-27T14:08:50.121Z 2025-12-04T15:06:02.049Z
8606054 8606054 20251125174530_uCVoW AU000B 2025-11-27T14:08:44.297Z 2025-12-04T15:06:01.259Z
8605914 8605914 20251125173040_hLMgB AU000B 2025-11-27T14:08:23.494Z 2025-12-04T15:05:50.844Z
8605803 8605803 20251125171224_BhMOK AU000B 2025-11-27T14:07:57.825Z 2025-12-04T15:05:43.917Z
8605795 8605795 20251125171042_bm6hp AU000B 2025-11-27T14:07:55.697Z 2025-12-04T15:05:43.294Z
8605784 8605784 20251125170813_Zsgmw AU000B 2025-11-27T14:07:54.195Z 2025-12-04T15:05:42.641Z
8605765 8605765 20251125165401_VE9NV AU000B 2025-11-27T14:07:50.169Z 2025-12-04T15:05:41.207Z
8605750 8605750 20251125164637_WsI9q AU000B 2025-11-27T14:07:37.542Z 2025-12-04T15:05:38.372Z
8605618 8605618 20251125151925_2g2SH AU000B 2025-11-27T14:06:43.661Z 2025-12-04T15:05:34.261Z
8605602 8605602 20251125151016_3LPd2 AU000B 2025-11-27T14:06:37.351Z 2025-12-04T15:05:32.944Z
8605573 8605573 20251125144153_7tJrs AU000B 2025-11-27T14:06:09.237Z 2025-12-04T15:05:30.087Z
8605552 8605552 20251125141949_IjuPL AU000B 2025-11-27T14:05:51.641Z 2025-12-04T15:05:28.705Z
8605503 8605503 20251125132805_nW2BN AU000B 2025-11-27T14:05:27.217Z 2025-12-04T15:05:26.777Z
8605488 8605488 20251125131035_Cu28v AU000B 2025-11-27T14:05:21.749Z 2025-12-04T15:05:26.086Z
8605482 8605482 20251125130749_7tjcL AU000B 2025-11-27T14:05:17.028Z 2025-12-04T15:05:25.878Z
8605455 8605455 20251125123210_owbdY AU000B 2025-11-27T14:04:56.167Z 2025-12-04T15:05:23.010Z
8605422 8605422 20251125112201_fC81x AU000B 2025-11-27T14:04:18.306Z 2025-12-04T15:05:17.855Z
8595498 8595498 20251124162833_iIptk AU000B 2025-11-26T14:11:27.068Z 2025-12-02T15:05:59.715Z
8595472 8595472 20251124160857_vcMJ6 AU000B 2025-11-26T14:11:12.185Z 2025-12-02T15:05:58.013Z
8595465 8595465 20251124160529_qn2ab AU000B 2025-11-26T14:11:10.250Z 2025-12-02T15:05:57.816Z

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