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

>10,000 rows count all where station_code = "AU001B" 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
9919219 9919219 20260512212644_ZipVS AU001B 2026-05-14T12:35:44.397Z 2026-05-14T12:41:30.268Z
9919036 9919036 20260512205638_iBeYb AU001B 2026-05-14T12:35:09.405Z 2026-05-14T12:41:30.207Z
9919013 9919013 20260512205117_knjd1 AU001B 2026-05-14T12:35:06.194Z 2026-05-14T12:41:30.199Z
9919010 9919010 20260512205059_XHXgz AU001B 2026-05-14T12:35:05.743Z 2026-05-14T12:41:30.199Z
9918993 9918993 20260512204656_5KiHi AU001B 2026-05-14T12:35:03.143Z 2026-05-14T12:41:30.193Z
9918892 9918892 20260512203327_vFcka AU001B 2026-05-14T12:34:39.528Z 2026-05-14T12:41:30.156Z
9918878 9918878 20260512203309_43gnV AU001B 2026-05-14T12:34:38.402Z 2026-05-14T12:41:30.153Z
9918836 9918836 20260512202557_pE8D2 AU001B 2026-05-14T12:34:34.010Z 2026-05-14T12:41:30.141Z
9918826 9918826 20260512202415_DPMPM AU001B 2026-05-14T12:34:32.371Z 2026-05-14T12:41:30.137Z
9918810 9918810 20260512202044_IbyWA AU001B 2026-05-14T12:34:30.419Z 2026-05-14T12:41:30.131Z
9918790 9918790 20260512201620_GZ8EA AU001B 2026-05-14T12:34:27.430Z 2026-05-14T12:41:30.124Z
9918698 9918698 20260512195806_RZN6f AU001B 2026-05-14T12:34:02.945Z 2026-05-14T12:41:30.095Z
9918696 9918696 20260512195756_Zgzl6 AU001B 2026-05-14T12:34:02.588Z 2026-05-14T12:41:30.094Z
9918690 9918690 20260512195433_4iU2l AU001B 2026-05-14T12:34:01.905Z 2026-05-14T12:41:30.092Z
9918680 9918680 20260512195110_93SnC AU001B 2026-05-14T12:34:00.345Z 2026-05-14T12:41:30.088Z
9918677 9918677 20260512195021_itE93 AU001B 2026-05-14T12:33:59.958Z 2026-05-14T12:41:30.087Z
9918648 9918648 20260512194050_bXTwZ AU001B 2026-05-14T12:33:55.428Z 2026-05-14T12:41:30.076Z
9918635 9918635 20260512193926_XPMlu AU001B 2026-05-14T12:33:46.199Z 2026-05-14T12:41:30.067Z
9918628 9918628 20260512193902_BOFHu AU001B 2026-05-14T12:33:45.576Z 2026-05-14T12:41:30.064Z
9918581 9918581 20260512192810_REY9O AU001B 2026-05-14T12:33:35.423Z 2026-05-14T12:41:30.047Z
9918578 9918578 20260512192733_AqwfK AU001B 2026-05-14T12:33:35.019Z 2026-05-14T12:41:30.046Z
9918518 9918518 20260512191417_Ud2Gi AU001B 2026-05-14T12:33:08.211Z 2026-05-14T12:41:30.021Z
9918514 9918514 20260512191249_TUYvU AU001B 2026-05-14T12:33:05.657Z 2026-05-14T12:41:30.019Z
9918505 9918505 20260512191037_59zZQ AU001B 2026-05-14T12:33:03.204Z 2026-05-14T12:41:30.015Z
9918492 9918492 20260512190650_6becZ AU001B 2026-05-14T12:33:00.833Z 2026-05-14T12:41:30.008Z
9918447 9918447 20260512184959_SZxz3 AU001B 2026-05-14T12:32:36.186Z 2026-05-14T12:41:29.966Z
9918433 9918433 20260512184555_QX0zc AU001B 2026-05-14T12:32:30.235Z 2026-05-14T12:41:29.958Z
9918427 9918427 20260512184127_8eWgP AU001B 2026-05-14T12:32:26.924Z 2026-05-14T12:41:29.953Z
9918425 9918425 20260512184033_c6zN6 AU001B 2026-05-14T12:32:26.633Z 2026-05-14T12:41:29.952Z
9918406 9918406 20260512183537_oJZMm AU001B 2026-05-14T12:32:23.009Z 2026-05-14T12:41:29.944Z
9918374 9918374 20260512182548_iTJBM AU001B 2026-05-14T12:32:17.050Z 2026-05-14T12:41:29.929Z
9918352 9918352 20260512181937_aMwmi AU001B 2026-05-14T12:32:02.650Z 2026-05-14T12:41:29.916Z
9918338 9918338 20260512181525_otQEu AU001B 2026-05-14T12:31:54.662Z 2026-05-14T12:41:29.906Z
9918331 9918331 20260512181102_K5bkS AU001B 2026-05-14T12:31:50.185Z 2026-05-14T12:41:29.896Z
9918326 9918326 20260512181029_KCM3S AU001B 2026-05-14T12:31:49.641Z 2026-05-14T12:41:29.894Z
9918306 9918306 20260512180414_2dFHQ AU001B 2026-05-14T12:31:30.290Z 2026-05-14T12:41:29.874Z
9918299 9918299 20260512180206_vkROI AU001B 2026-05-14T12:31:25.096Z 2026-05-14T12:41:29.867Z
9918287 9918287 20260512175849_EXVmb AU001B 2026-05-14T12:31:21.495Z 2026-05-14T12:41:29.861Z
9918284 9918284 20260512175748_JbdBc AU001B 2026-05-14T12:31:20.769Z 2026-05-14T12:41:29.859Z
9918237 9918237 20260512174306_efNZC AU001B 2026-05-14T12:30:44.921Z 2026-05-14T12:41:29.743Z
9918235 9918235 20260512174208_OSjJC AU001B 2026-05-14T12:30:44.275Z 2026-05-14T12:41:29.742Z
9918228 9918228 20260512174051_Jvo2M AU001B 2026-05-14T12:30:43.100Z 2026-05-14T12:41:29.739Z
9918220 9918220 20260512173920_Kn4dO AU001B 2026-05-14T12:30:41.888Z 2026-05-14T12:41:29.737Z
9918193 9918193 20260512172252_CN2ro AU001B 2026-05-14T12:30:15.423Z 2026-05-14T12:41:29.686Z
9918179 9918179 20260512171829_6SkKO AU001B 2026-05-14T12:30:09.059Z 2026-05-14T12:41:29.672Z
9918174 9918174 20260512171733_3YPtU AU001B 2026-05-14T12:30:01.482Z 2026-05-14T12:41:29.657Z
9918156 9918156 20260512170843_px0V8 AU001B 2026-05-14T12:29:47.201Z 2026-05-14T12:41:29.601Z
9918147 9918147 20260512170318_pyOcz AU001B 2026-05-14T12:29:28.086Z 2026-05-14T12:41:29.584Z
9918140 9918140 20260512165656_hWDvb AU001B 2026-05-14T12:29:21.145Z 2026-05-14T12:41:29.570Z
9918125 9918125 20260512165017_kPZYn AU001B 2026-05-14T12:29:05.467Z 2026-05-14T12:41:29.554Z
9918098 9918098 20260512163912_DKDaT AU001B 2026-05-14T12:28:48.592Z 2026-05-14T12:41:29.521Z
9918078 9918078 20260512163325_JRDzU AU001B 2026-05-14T12:28:31.006Z 2026-05-14T12:41:29.497Z
9918043 9918043 20260512162104_acwJK AU001B 2026-05-14T12:28:15.642Z 2026-05-14T12:41:29.463Z
9918037 9918037 20260512162008_QGQfR AU001B 2026-05-14T12:28:13.693Z 2026-05-14T12:41:29.459Z
9918009 9918009 20260512160931_pQXCR AU001B 2026-05-14T12:27:50.495Z 2026-05-14T12:41:29.401Z
9918005 9918005 20260512160740_7RytH AU001B 2026-05-14T12:27:47.164Z 2026-05-14T12:41:28.518Z
9917944 9917944 20260512154046_M70tu AU001B 2026-05-14T12:27:18.163Z 2026-05-14T12:41:28.448Z
9917927 9917927 20260512153005_WOd3j AU001B 2026-05-14T12:27:13.134Z 2026-05-14T12:41:28.399Z
9917919 9917919 20260512152816_qsNxU AU001B 2026-05-14T12:27:11.559Z 2026-05-14T12:41:28.395Z
9917888 9917888 20260512151452_bV6zF AU001B 2026-05-14T12:26:54.068Z 2026-05-14T12:41:28.364Z
9917867 9917867 20260512150234_cLFzy AU001B 2026-05-14T12:26:48.461Z 2026-05-14T12:41:28.341Z
9917865 9917865 20260512150013_9wPm5 AU001B 2026-05-14T12:26:47.824Z 2026-05-14T12:41:28.338Z
9917845 9917845 20260512145602_kURGH AU001B 2026-05-14T12:26:43.964Z 2026-05-14T12:41:28.323Z
9917841 9917841 20260512145446_XE8Jf AU001B 2026-05-14T12:26:43.053Z 2026-05-14T12:41:28.320Z
9917800 9917800 20260512143906_lqlgU AU001B 2026-05-14T12:26:22.743Z 2026-05-14T12:41:28.262Z
9917763 9917763 20260512142046_y28Fj AU001B 2026-05-14T12:26:11.603Z 2026-05-14T12:41:28.202Z
9917755 9917755 20260512141911_gyxEW AU001B 2026-05-14T12:26:10.102Z 2026-05-14T12:41:28.196Z
9917718 9917718 20260512140050_XJhyi AU001B 2026-05-14T12:25:50.263Z 2026-05-14T12:41:28.154Z
9917712 9917712 20260512135552_XuWTA AU001B 2026-05-14T12:25:47.899Z 2026-05-14T12:41:28.146Z
9917694 9917694 20260512133844_yCK2w AU001B 2026-05-14T12:25:39.842Z 2026-05-14T12:41:28.069Z
9917650 9917650 20260512132235_OdPXf AU001B 2026-05-14T12:25:20.087Z 2026-05-14T12:41:28.033Z
9917646 9917646 20260512132155_814ZU AU001B 2026-05-14T12:25:19.392Z 2026-05-14T12:41:28.031Z
9917598 9917598 20260512130451_zPVMU AU001B 2026-05-14T12:25:10.509Z 2026-05-14T12:41:28.003Z
9917563 9917563 20260512123619_FoyPS AU001B 2026-05-14T12:24:50.227Z 2026-05-14T12:41:27.965Z
9917542 9917542 20260512122019_3lIpZ AU001B 2026-05-14T12:24:43.908Z 2026-05-14T12:41:27.941Z
9917527 9917527 20260512121038_Ny9aX AU001B 2026-05-14T12:24:40.383Z 2026-05-14T12:41:27.928Z
9917471 9917471 20260512105856_qV9fJ AU001B 2026-05-14T12:23:54.255Z 2026-05-14T12:41:27.705Z
9917467 9917467 20260512105250_bavi1 AU001B 2026-05-14T12:23:50.579Z 2026-05-14T12:41:27.679Z
9917441 9917441 20260512102604_Teiap AU001B 2026-05-14T12:23:27.554Z 2026-05-14T12:41:27.538Z
9909745 9909745 20260511215432_Xw348 AU001B 2026-05-13T12:35:37.950Z 2026-05-14T12:52:02.729Z
9909731 9909731 20260511215316_rAYyE AU001B 2026-05-13T12:35:37.250Z 2026-05-14T12:52:02.460Z
9909680 9909680 20260511215035_A1uSZ AU001B 2026-05-13T12:35:34.006Z 2026-05-14T12:52:01.253Z
9909544 9909544 20260511213502_PFUq5 AU001B 2026-05-13T12:35:07.677Z 2026-05-14T12:51:55.950Z
9909527 9909527 20260511213311_0j1vY AU001B 2026-05-13T12:35:06.575Z 2026-05-14T12:51:55.536Z
9909503 9909503 20260511212948_7Gn3H AU001B 2026-05-13T12:35:01.664Z 2026-05-14T12:51:53.625Z
9909429 9909429 20260511211845_DvSmg AU001B 2026-05-13T12:34:53.172Z 2026-05-14T12:51:36.632Z
9909412 9909412 20260511211646_KH2OH AU001B 2026-05-13T12:34:51.369Z 2026-05-14T12:51:35.874Z
9909287 9909287 20260511210134_JElcN AU001B 2026-05-13T12:34:22.995Z 2026-05-14T12:51:29.875Z
9909261 9909261 20260511205702_IHOlC AU001B 2026-05-13T12:34:19.668Z 2026-05-14T12:51:28.678Z
9909203 9909203 20260511204746_lkxOJ AU001B 2026-05-13T12:34:14.229Z 2026-05-14T12:51:26.478Z
9909192 9909192 20260511204700_5PNlc AU001B 2026-05-13T12:34:13.360Z 2026-05-14T12:51:26.186Z
9909139 9909139 20260511203703_W63lr AU001B 2026-05-13T12:34:08.562Z 2026-05-14T12:51:24.307Z
9909137 9909137 20260511203636_Hrtdf AU001B 2026-05-13T12:34:08.294Z 2026-05-14T12:51:24.233Z
9909113 9909113 20260511203204_08qgR AU001B 2026-05-13T12:33:52.457Z 2026-05-14T12:51:22.832Z
9909104 9909104 20260511203104_9plfu AU001B 2026-05-13T12:33:51.561Z 2026-05-14T12:51:22.487Z
9909085 9909085 20260511202733_2WUSp AU001B 2026-05-13T12:33:46.590Z 2026-05-14T12:51:21.362Z
9909039 9909039 20260511202103_N23lG AU001B 2026-05-13T12:33:42.961Z 2026-05-14T12:51:19.551Z
9909023 9909023 20260511201849_UbVns AU001B 2026-05-13T12:33:41.981Z 2026-05-14T12:51:19.124Z
9909018 9909018 20260511201811_2u4ri AU001B 2026-05-13T12:33:41.735Z 2026-05-14T12:51:19.020Z
9908992 9908992 20260511201259_zzNJF AU001B 2026-05-13T12:33:39.368Z 2026-05-14T12:51:17.402Z

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