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

170 rows where station_code = "AU0034" 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
9846585 9846585 20260503183932_E2rxY AU0034 2026-05-05T12:16:58.143Z 2026-05-05T12:17:16.486Z
9842053 9842053 20260503213113_LsZ1o AU0034 2026-05-05T12:01:47.536Z 2026-05-05T12:17:13.140Z
9841893 9841893 20260503204807_bhEjo AU0034 2026-05-05T12:01:03.330Z 2026-05-05T12:17:13.083Z
9671447 9671447 20260413185647_wsk0x AU0034 2026-04-15T12:24:48.372Z 2026-04-22T13:14:12.081Z
9671413 9671413 20260413184428_DIjOy AU0034 2026-04-15T12:24:42.921Z 2026-04-22T13:14:11.318Z
9671346 9671346 20260413181037_R9z3g AU0034 2026-04-15T12:24:13.776Z 2026-04-22T13:14:09.633Z
9655723 9655723 20260411182702_5EpYC AU0034 2026-04-13T12:19:35.680Z 2026-04-20T13:06:31.333Z
9579279 9579279 20260324151012_nmisg AU0034 2026-03-26T12:12:26.334Z 2026-04-02T12:36:37.308Z
9506420 9506420 20260317212226_gfScn AU0034 2026-03-18T12:12:21.764Z 2026-03-25T12:43:04.825Z
9491982 9491982 20260314163207_48L3Q AU0034 2026-03-16T12:27:27.839Z 2026-03-22T12:42:46.823Z
9491878 9491878 20260315205201_XrbwJ AU0034 2026-03-16T12:22:05.672Z 2026-03-23T12:22:42.935Z
9491826 9491826 20260315202213_8lyDr AU0034 2026-03-16T12:21:54.789Z 2026-03-23T12:22:42.519Z
9491486 9491486 20260315165729_l26Iy AU0034 2026-03-16T12:21:07.061Z 2026-03-23T12:22:39.640Z
9461994 9461994 20260311194100_ObTks AU0034 2026-03-12T12:18:17.795Z 2026-03-19T12:45:47.197Z
9455152 9455152 20260310185859_KhSVV AU0034 2026-03-11T12:10:32.137Z 2026-03-18T12:39:56.220Z
9415148 9415148 20260228202106_OBnKH AU0034 2026-03-02T14:07:28.271Z 2026-03-08T12:43:03.337Z
9381132 9381132 20260222210427_wcuoP AU0034 2026-02-24T14:24:17.725Z 2026-02-24T14:24:17.725Z
9380757 9380757 20260222201751_icKkU AU0034 2026-02-24T14:23:40.377Z 2026-02-24T14:23:40.377Z
9380241 9380241 20260222191646_G4ehT AU0034 2026-02-24T14:22:50.992Z 2026-02-24T14:22:50.992Z
9380139 9380139 20260222185814_aXVZb AU0034 2026-02-24T14:22:42.128Z 2026-02-24T14:22:42.128Z
9380036 9380036 20260222184551_vaDEk AU0034 2026-02-24T14:22:33.894Z 2026-02-24T14:22:33.894Z
9378910 9378910 20260222153334_DzWat AU0034 2026-02-24T14:20:11.073Z 2026-02-24T14:20:11.073Z
9378441 9378441 20260222135440_1lYah AU0034 2026-02-24T14:18:39.067Z 2026-02-24T14:18:39.067Z
9371438 9371438 20260221181158_cBaFB AU0034 2026-02-23T14:24:15.280Z 2026-03-02T14:22:10.294Z
9370547 9370547 20260221132950_tNPqI AU0034 2026-02-23T14:19:54.641Z 2026-03-02T14:21:52.655Z
9325608 9325608 20260214190032_69Ds3 AU0034 2026-02-15T14:15:42.935Z 2026-02-23T14:47:32.844Z
9325593 9325593 20260214182716_yv5Vi AU0034 2026-02-15T14:15:38.399Z 2026-02-23T14:47:31.039Z
9321239 9321239 20260213191534_TobVG AU0034 2026-02-14T14:11:14.674Z 2026-02-22T14:42:38.899Z
9301720 9301720 20260207204600_24EI1 AU0034 2026-02-08T14:14:22.362Z 2026-02-16T14:59:52.773Z
9301609 9301609 20260207192233_SSd8T AU0034 2026-02-08T14:13:53.328Z 2026-02-16T14:59:37.338Z
9301538 9301538 20260207184528_KyLuH AU0034 2026-02-08T14:13:35.287Z 2026-02-08T14:13:35.287Z
9300706 9300706 20260207140027_bvLr0 AU0034 2026-02-08T14:10:13.290Z 2026-02-16T14:58:09.097Z
9180263 9180263 20260110194649_IfS2K AU0034 2026-01-12T14:06:29.231Z 2026-01-19T15:15:53.946Z
9108287 9108287 20251229182919_BYALr AU0034 2025-12-31T14:43:17.688Z 2026-01-06T15:21:29.903Z
9098621 9098621 20251227194233_jl1WA AU0034 2025-12-30T15:10:40.781Z 2026-01-04T15:35:20.961Z
9097781 9097781 20251227173357_jrB7o AU0034 2025-12-30T15:09:17.627Z 2026-01-04T15:34:21.236Z
9097617 9097617 20251227170445_GGmqA AU0034 2025-12-30T15:09:07.985Z 2026-01-04T15:34:15.144Z
9023158 9023158 20251220192403_E69eR AU0034 2025-12-27T15:08:46.971Z 2025-12-27T15:08:46.971Z
8968641 8968641 20251216161052_KgqUQ AU0034 2025-12-25T14:49:22.301Z 2025-12-25T14:49:22.301Z
8673425 8673425 20251201190236_oawjo AU0034 2025-12-03T14:18:49.096Z 2025-12-10T14:38:22.116Z
8662379 8662379 20251130184108_o4bK2 AU0034 2025-12-02T14:15:18.085Z 2025-12-09T14:56:38.726Z
8586042 8586042 20251123183357_3URaJ AU0034 2025-11-25T14:11:41.278Z 2025-12-02T15:10:39.853Z
8419797 8419797 20251110173830_4OxxK AU0034 2025-11-12T14:08:23.181Z 2025-11-19T15:13:27.112Z
8419486 8419486 20251110164607_sW0Ql AU0034 2025-11-12T14:06:54.977Z 2025-11-19T15:13:13.640Z
8412165 8412165 20251109195349_SXNtg AU0034 2025-11-11T14:13:14.424Z 2025-11-18T15:20:08.322Z
8396173 8396173 20251107194732_CNAOS AU0034 2025-11-09T14:07:37.677Z 2025-11-16T15:03:15.525Z
8159929 8159929 20251020143507_dXFdA AU0034 2025-10-22T12:03:53.723Z 2025-10-29T13:06:39.723Z
8119357 8119357 20251016174718_Pkowy AU0034 2025-10-18T12:12:52.712Z 2025-10-25T13:25:40.549Z
8047626 8047626 20251002184801_s3pNU AU0034 2025-10-04T12:14:24.389Z 2025-10-11T12:39:25.249Z
7928292 7928292 20250921194454_L3o8P AU0034 2025-09-24T12:45:36.498Z 2025-09-30T13:02:10.543Z
7711185 7711185 20250830211439_BJD33 AU0034 2025-09-01T12:10:44.745Z 2025-09-08T12:52:01.193Z
7693353 7693353 20250828203842_nK1MJ AU0034 2025-08-30T12:20:11.186Z 2025-09-06T14:12:34.593Z
7691796 7691796 20250828164703_0KGOL AU0034 2025-08-30T12:15:00.193Z 2025-09-06T14:12:07.410Z
7621506 7621506 20250822175544_V6a0z AU0034 2025-08-24T12:17:15.946Z 2025-08-31T12:53:44.091Z
7570544 7570544 20250818192538_vTt3I AU0034 2025-08-20T12:21:05.274Z 2025-08-20T12:38:26.874Z
7559168 7559168 20250816121929_P48E4 AU0034 2025-08-19T12:51:30.641Z 2025-08-24T12:48:16.289Z
7393081 7393081 20250806214720_58jGR AU0034 2025-08-08T12:08:15.540Z 2025-08-15T13:36:04.564Z
7299055 7299055 20250731212451_hfjPg AU0034 2025-08-02T12:24:43.020Z 2025-08-09T13:05:27.067Z
7297805 7297805 20250731193948_X8ECO AU0034 2025-08-02T12:24:27.725Z 2025-08-09T13:05:03.831Z
7297063 7297063 20250731184832_nueQg AU0034 2025-08-02T12:24:11.700Z 2025-08-09T13:04:49.834Z
7245408 7245408 20250728184258_SgZCn AU0034 2025-07-30T12:03:03.494Z 2025-08-06T12:34:54.563Z
7245018 7245018 20250728182025_A6Kju AU0034 2025-07-30T12:02:59.938Z 2025-08-06T12:34:54.121Z
7219018 7219018 20250726190754_WZrsl AU0034 2025-07-28T12:27:22.285Z 2025-08-04T12:48:46.778Z
7218842 7218842 20250726170936_PxIyp AU0034 2025-07-28T12:27:09.033Z 2025-08-04T12:48:42.449Z
7200231 7200231 20250725202642_xjTYb AU0034 2025-07-27T12:24:10.146Z 2025-08-03T13:05:41.556Z
7199877 7199877 20250725193214_x7mTg AU0034 2025-07-27T12:23:15.058Z 2025-08-03T13:05:33.736Z
7199739 7199739 20250725191957_s0Zhl AU0034 2025-07-27T12:23:07.504Z 2025-07-27T12:23:07.504Z
7199587 7199587 20250725190651_k3EQB AU0034 2025-07-27T12:23:00.806Z 2025-08-03T13:05:28.480Z
7187287 7187287 20250724210348_1KZ2N AU0034 2025-07-26T12:31:17.049Z 2025-08-01T12:16:17.861Z
7187026 7187026 20250724202850_QEq3F AU0034 2025-07-26T12:30:51.641Z 2025-08-01T12:16:15.231Z
7156620 7156620 20250722125553_EMqJ2 AU0034 2025-07-24T12:00:21.092Z 2025-07-30T12:09:09.003Z
7108092 7108092 20250717181653_njCZF AU0034 2025-07-20T12:12:14.027Z 2025-07-26T12:45:32.261Z
7101470 7101470 20250716151456_yUhIl AU0034 2025-07-18T12:21:58.970Z 2025-07-24T12:01:23.333Z
7100714 7100714 20250716201129_m3Lr9 AU0034 2025-07-18T12:14:12.021Z 2025-07-25T12:02:57.878Z
7066323 7066323 20250709211522_ITpda AU0034 2025-07-11T12:09:13.991Z 2025-07-18T12:37:47.750Z
7057518 7057518 20250707215849_52qUe AU0034 2025-07-09T12:19:05.673Z 2025-07-16T12:45:12.391Z
7039708 7039708 20250704173505_tX4n2 AU0034 2025-07-06T12:12:03.505Z 2025-07-13T12:47:46.389Z
6961591 6961591 20250623185729_kUX2S AU0034 2025-06-25T12:07:34.996Z 2025-07-02T12:48:09.961Z
6878650 6878650 20250609212900_1obea AU0034 2025-06-10T12:08:23.046Z 2025-06-17T12:29:09.235Z
6865117 6865117 20250605191612_sayf9 AU0034 2025-06-07T12:00:41.006Z 2025-06-14T12:27:56.714Z
6813256 6813256 20250526201652_D0olr AU0034 2025-05-28T12:12:21.202Z 2025-06-04T13:01:42.146Z
6752566 6752566 20250518203544_MsKH1 AU0034 2025-05-20T12:17:04.428Z 2025-05-27T13:20:05.612Z
6751454 6751454 20250518123930_udIId AU0034 2025-05-20T12:12:47.614Z 2025-05-27T13:17:09.958Z
6737102 6737102 20250515190008_QQmqI AU0034 2025-05-17T12:21:09.813Z 2025-05-23T12:36:53.400Z
6695963 6695963 20250507195941_kcnvE AU0034 2025-05-10T12:20:41.561Z 2025-05-16T12:34:52.466Z
6695901 6695901 20250507192643_OMEss AU0034 2025-05-10T12:20:21.175Z 2025-05-16T12:34:50.458Z
6534968 6534968 20250420194341_Ahwa2 AU0034 2025-04-22T12:16:10.430Z 2025-04-29T12:36:19.382Z
6528047 6528047 20250419173734_LCeed AU0034 2025-04-21T12:09:05.892Z 2025-04-28T12:40:50.730Z
6424209 6424209 20250331201107_sMTvm AU0034 2025-04-02T12:01:13.850Z 2025-04-09T12:26:21.413Z
6389640 6389640 20250325185548_XOO3o AU0034 2025-03-27T12:01:09.069Z 2025-04-03T12:44:17.926Z
6389633 6389633 20250325184914_eHZLE AU0034 2025-03-27T12:01:06.901Z 2025-04-03T12:44:17.748Z
6388323 6388323 20250324144834_U20Ix AU0034 2025-03-26T12:21:02.966Z 2025-04-01T13:02:53.959Z
6365461 6365461 20250321181016_xjzPl AU0034 2025-03-23T12:01:11.560Z 2025-03-30T13:05:17.776Z
6240075 6240075 20250305195023_2gTqu AU0034 2025-03-07T14:09:29.519Z 2025-03-14T12:33:38.286Z
6200177 6200177 20250227141507_QZ378 AU0034 2025-03-01T14:43:04.505Z 2025-03-07T17:01:24.510Z
6106408 6106408 20250216143710_LOalU AU0034 2025-02-17T14:08:28.836Z 2025-02-24T15:24:09.591Z
6052735 6052735 20250202180100_JcIso AU0034 2025-02-04T14:22:28.015Z 2025-02-10T14:58:14.319Z
5942161 5942161 20250108170704_tmwgu AU0034 2025-01-10T14:14:27.195Z 2025-01-17T14:17:50.825Z
5878639 5878639 20250101125523_JRpFC AU0034 2025-01-03T14:00:34.423Z 2025-01-10T14:39:27.943Z
5131526 5131526 20240915200925_vt7KH AU0034 2024-09-19T12:15:07.574Z 2024-09-24T12:15:34.715Z

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