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 = "AU000V" 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
8400752 8400752 20251106201214_NVHh3 AU000V 2025-11-09T14:24:45.507Z 2025-11-15T14:59:33.658Z
8394692 8394692 20251104191827_rloPz AU000V 2025-11-08T14:32:06.552Z 2025-11-13T15:13:41.356Z
8394688 8394688 20251104173531_pGwCt AU000V 2025-11-08T14:31:49.557Z 2025-11-13T15:13:29.390Z
8394674 8394674 20251106123955_hvHKo AU000V 2025-11-08T14:31:03.188Z 2025-11-14T15:08:57.969Z
8394647 8394647 20251106121503_UNlDQ AU000V 2025-11-08T14:30:55.972Z 2025-11-14T15:08:56.630Z
8388714 8388714 20251106164216_oXbPT AU000V 2025-11-08T14:03:14.995Z 2025-11-15T14:59:13.050Z
8384845 8384845 20251105183731_ox8Xt AU000V 2025-11-07T14:04:05.704Z 2025-11-14T15:07:45.653Z
8384837 8384837 20251105182738_ZxeKu AU000V 2025-11-07T14:04:02.607Z 2025-11-14T15:07:45.223Z
8383006 8383006 20251103172819_cO5sW AU000V 2025-11-06T14:22:17.468Z 2025-11-12T15:08:45.618Z
8378948 8378948 20251104201221_e4UJ6 AU000V 2025-11-06T14:06:07.008Z 2025-11-13T15:13:53.398Z
8378929 8378929 20251104200405_rlfX8 AU000V 2025-11-06T14:06:01.244Z 2025-11-07T14:19:57.897Z
8378894 8378894 20251104195408_ggK2I AU000V 2025-11-06T14:05:51.444Z 2025-11-13T15:13:51.986Z
8378856 8378856 20251104194703_qBWGD AU000V 2025-11-06T14:05:42.288Z 2025-11-13T15:13:49.937Z
8378811 8378811 20251104193355_3L4p1 AU000V 2025-11-06T14:05:34.192Z 2025-11-13T15:13:45.310Z
8378798 8378798 20251104193042_2mPV8 AU000V 2025-11-06T14:05:31.589Z 2025-11-13T15:13:45.073Z
8378790 8378790 20251104192708_mYrv3 AU000V 2025-11-06T14:05:21.196Z 2025-11-13T15:13:44.889Z
8378788 8378788 20251104192650_jxLxs AU000V 2025-11-06T14:05:20.323Z 2025-11-13T15:13:44.857Z
8378685 8378685 20251104185610_81Owd AU000V 2025-11-06T14:04:59.556Z 2025-11-13T15:13:38.847Z
8378629 8378629 20251104182721_QWAC2 AU000V 2025-11-06T14:04:39.834Z 2025-11-13T15:13:36.803Z
8378583 8378583 20251104174810_OEYXL AU000V 2025-11-06T14:04:27.230Z 2025-11-13T15:13:31.032Z
8378562 8378562 20251104173951_nki2k AU000V 2025-11-06T14:04:22.618Z 2025-11-13T15:13:29.503Z
8377244 8377244 20251101202003_0amoa AU000V 2025-11-05T14:40:38.213Z 2025-11-10T15:05:38.484Z
8377242 8377242 20251101201112_2cnZJ AU000V 2025-11-05T14:40:36.425Z 2025-11-10T15:05:37.747Z
8377236 8377236 20251101181149_YadB8 AU000V 2025-11-05T14:39:26.775Z 2025-11-10T15:04:37.712Z
8377234 8377234 20251101172915_PMaBK AU000V 2025-11-05T14:39:16.734Z 2025-11-10T15:04:10.103Z
8377232 8377232 20251101165640_Nwu8v AU000V 2025-11-05T14:39:10.704Z 2025-11-10T15:03:48.574Z
8377229 8377229 20251101155102_GO2Mx AU000V 2025-11-05T14:39:02.585Z 2025-11-10T15:03:33.016Z
8377225 8377225 20251101154307_h01bW AU000V 2025-11-05T14:38:50.479Z 2025-11-10T15:03:26.231Z
8377221 8377221 20251101144527_nhySh AU000V 2025-11-05T14:38:29.827Z 2025-11-10T15:02:58.260Z
8377219 8377219 20251101144457_EW5tz AU000V 2025-11-05T14:38:29.464Z 2025-11-10T15:02:58.053Z
8377215 8377215 20251101135256_tVaJJ AU000V 2025-11-05T14:38:22.792Z 2025-11-10T15:02:26.405Z
8377213 8377213 20251101135151_qoVcz AU000V 2025-11-05T14:38:22.655Z 2025-11-10T15:02:26.379Z
8377211 8377211 20251101132905_1Cp9a AU000V 2025-11-05T14:38:19.534Z 2025-11-10T15:02:13.636Z
8377209 8377209 20251101130122_Q2JLO AU000V 2025-11-05T14:38:16.603Z 2025-11-10T15:02:08.093Z
8373464 8373464 20251102201002_d3VxW AU000V 2025-11-05T14:26:57.395Z 2025-11-11T15:05:02.871Z
8373412 8373412 20251102193317_2xcmP AU000V 2025-11-05T14:26:20.735Z 2025-11-11T15:04:04.138Z
8373392 8373392 20251102192052_IxP6Z AU000V 2025-11-05T14:26:07.256Z 2025-11-11T15:03:55.394Z
8373388 8373388 20251102191736_Pc2ak AU000V 2025-11-05T14:26:05.057Z 2025-11-11T15:03:51.931Z
8373372 8373372 20251102190854_AI3J2 AU000V 2025-11-05T14:25:49.388Z 2025-11-11T15:03:45.870Z
8373324 8373324 20251102181415_jUK5U AU000V 2025-11-05T14:25:03.181Z 2025-11-11T15:03:11.134Z
8373317 8373317 20251102180745_mkDHj AU000V 2025-11-05T14:25:00.563Z 2025-11-11T15:03:09.905Z
8373303 8373303 20251102174953_TsaHg AU000V 2025-11-05T14:24:53.135Z 2025-11-11T15:03:05.503Z
8373299 8373299 20251102174650_CrnRn AU000V 2025-11-05T14:24:51.352Z 2025-11-11T15:03:04.777Z
8373284 8373284 20251102164758_MIGNU AU000V 2025-11-05T14:24:26.391Z 2025-11-11T15:02:45.562Z
8373280 8373280 20251102162310_4XC3E AU000V 2025-11-05T14:24:13.202Z 2025-11-11T15:02:43.903Z
8373270 8373270 20251102144901_vXGXC AU000V 2025-11-05T14:22:55.022Z 2025-11-11T15:02:27.427Z
8373261 8373261 20251102141828_Ex4lm AU000V 2025-11-05T14:22:07.090Z 2025-11-11T15:02:23.989Z
8369084 8369084 20251103185834_Hcq4Q AU000V 2025-11-05T14:05:30.691Z 2025-11-12T15:08:52.035Z
8368907 8368907 20251103172455_2SIaE AU000V 2025-11-05T14:04:27.637Z 2025-11-12T15:08:45.427Z
8368770 8368770 20251103161442_1FQ7U AU000V 2025-11-05T14:03:46.262Z 2025-11-12T15:08:40.527Z
8368714 8368714 20251103155632_6IVdJ AU000V 2025-11-05T14:03:38.556Z 2025-11-12T15:08:39.720Z
8368633 8368633 20251103154213_xfRbh AU000V 2025-11-05T14:03:13.637Z 2025-11-12T15:08:38.450Z
8368537 8368537 20251103152433_idA9C AU000V 2025-11-05T14:02:55.740Z 2025-11-12T15:08:36.981Z
8367726 8367726 20251029113303_N8v2s AU000V 2025-11-04T15:24:17.123Z 2025-11-06T15:16:23.611Z
8367717 8367717 20251028183322_aL3ta AU000V 2025-11-04T15:14:43.925Z 2025-11-06T15:11:50.676Z
8367709 8367709 20251029172513_RoOsB AU000V 2025-11-04T15:01:45.836Z 2025-11-07T15:09:37.725Z
8367707 8367707 20251029172056_BBPa8 AU000V 2025-11-04T15:01:44.734Z 2025-11-07T15:09:37.203Z
8367705 8367705 20251029171055_A2TJP AU000V 2025-11-04T15:01:42.620Z 2025-11-07T15:09:35.835Z
8367701 8367701 20251029160050_qviNF AU000V 2025-11-04T15:01:15.298Z 2025-11-07T15:09:21.922Z
8367697 8367697 20251031122514_IsECc AU000V 2025-11-04T14:59:31.775Z 2025-11-08T15:18:22.116Z
8367690 8367690 20251030194408_9OSjS AU000V 2025-11-04T14:52:10.080Z 2025-11-08T15:11:36.291Z
8367686 8367686 20251030190020_yRz5E AU000V 2025-11-04T14:52:00.052Z 2025-11-08T15:11:30.662Z
8367678 8367678 20251030180749_1QoFp AU000V 2025-11-04T14:51:30.967Z 2025-11-08T15:11:15.134Z
8367676 8367676 20251030174712_ntkFe AU000V 2025-11-04T14:51:26.194Z 2025-11-08T15:10:51.328Z
8367674 8367674 20251030170228_jaRMg AU000V 2025-11-04T14:51:15.765Z 2025-11-08T15:10:32.241Z
8367670 8367670 20251030164332_PqZCy AU000V 2025-11-04T14:51:00.134Z 2025-11-08T15:10:29.837Z
8367666 8367666 20251030155545_tmulS AU000V 2025-11-04T14:50:46.438Z 2025-11-08T15:10:21.755Z
8367662 8367662 20251030145636_vetYn AU000V 2025-11-04T14:50:31.896Z 2025-11-08T15:09:53.000Z
8367659 8367659 20251030143544_qwnDK AU000V 2025-11-04T14:50:23.533Z 2025-11-08T15:09:43.737Z
8367657 8367657 20251030143328_32DZn AU000V 2025-11-04T14:50:15.484Z 2025-11-08T15:09:42.946Z
8367655 8367655 20251030133820_mcm5Q AU000V 2025-11-04T14:50:01.171Z 2025-11-08T15:09:11.727Z
8367647 8367647 20251031192050_dTpf3 AU000V 2025-11-04T14:41:24.231Z 2025-11-09T14:59:11.191Z
8365838 8365838 20251101190741_jIB8V AU000V 2025-11-04T14:23:56.896Z 2025-11-10T15:05:05.453Z
8363082 8363082 20251102195055_ksHCn AU000V 2025-11-04T14:13:09.516Z 2025-11-11T15:04:33.562Z
8362830 8362830 20251102193227_5Pj4G AU000V 2025-11-04T14:12:28.339Z 2025-11-11T15:04:04.008Z
8362730 8362730 20251102192408_gGHZP AU000V 2025-11-04T14:12:14.617Z 2025-11-11T15:03:56.972Z
8362728 8362728 20251102192319_e6QDC AU000V 2025-11-04T14:12:14.068Z 2025-11-11T15:03:56.946Z
8362635 8362635 20251102191743_5aj1J AU000V 2025-11-04T14:11:55.337Z 2025-11-11T15:03:52.889Z
8362518 8362518 20251102191226_9jynR AU000V 2025-11-04T14:11:40.880Z 2025-11-11T15:03:47.980Z
8362476 8362476 20251102190957_MJwd2 AU000V 2025-11-04T14:11:35.677Z 2025-11-11T15:03:45.970Z
8362468 8362468 20251102190803_lXA0R AU000V 2025-11-04T14:11:34.543Z 2025-11-11T15:03:45.769Z
8362344 8362344 20251102185855_T33nH AU000V 2025-11-04T14:11:09.186Z 2025-11-11T15:03:35.797Z
8362241 8362241 20251102185331_A0vxC AU000V 2025-11-04T14:10:49.394Z 2025-11-11T15:03:30.081Z
8362205 8362205 20251102184932_BV9ID AU000V 2025-11-04T14:10:41.763Z 2025-11-11T15:03:28.377Z
8361903 8361903 20251102182933_0jUK2 AU000V 2025-11-04T14:09:56.209Z 2025-11-11T15:03:15.519Z
8361847 8361847 20251102182639_OgsYY AU000V 2025-11-04T14:09:41.553Z 2025-11-11T15:03:12.921Z
8361752 8361752 20251102181657_xxBjV AU000V 2025-11-04T14:09:26.186Z 2025-11-11T15:03:11.670Z
8361675 8361675 20251102180912_EvkHH AU000V 2025-11-04T14:09:07.506Z 2025-11-11T15:03:10.096Z
8361669 8361669 20251102180719_BFx2l AU000V 2025-11-04T14:09:04.107Z 2025-11-11T15:03:09.828Z
8361378 8361378 20251102172835_xY3uZ AU000V 2025-11-04T14:08:09.846Z 2025-11-11T15:02:52.575Z
8361162 8361162 20251102164507_h0K1g AU000V 2025-11-04T14:07:13.338Z 2025-11-11T15:02:45.533Z
8361087 8361087 20251102163413_PRDD1 AU000V 2025-11-04T14:06:56.207Z 2025-11-11T15:02:44.865Z
8361042 8361042 20251102162848_REApK AU000V 2025-11-04T14:06:47.546Z 2025-11-11T15:02:44.431Z
8360963 8360963 20251102161332_i55fP AU000V 2025-11-04T14:06:34.076Z 2025-11-11T15:02:43.066Z
8360613 8360613 20251102153725_27qo5 AU000V 2025-11-04T14:05:17.282Z 2025-11-11T15:02:34.669Z
8360534 8360534 20251102153311_bKfVl AU000V 2025-11-04T14:05:00.495Z 2025-11-11T15:02:33.641Z
8360022 8360022 20251102144308_8HtaG AU000V 2025-11-04T14:03:09.102Z 2025-11-11T15:02:26.662Z
8359796 8359796 20251102141104_5KsKX AU000V 2025-11-04T14:02:09.567Z 2025-11-11T15:02:22.962Z
8359523 8359523 20251102132315_zbCbZ AU000V 2025-11-04T14:01:05.966Z 2025-11-11T15:02:19.372Z
8359274 8359274 20251030191638_tC3VZ AU000V 2025-11-03T14:50:33.414Z 2025-11-08T15:11:32.247Z

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