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 = "AU0030" 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
9816844 9816844 20260427142115_tBCps AU0030 2026-04-29T12:34:14.181Z 2026-04-29T12:34:14.181Z
9812525 9812525 20260427214127_Df2up AU0030 2026-04-29T12:10:21.104Z 2026-04-29T12:24:07.030Z
9812523 9812523 20260427213701_0T7Mm AU0030 2026-04-29T12:10:20.479Z 2026-04-29T12:24:07.029Z
9812519 9812519 20260427213140_2CnyH AU0030 2026-04-29T12:10:19.127Z 2026-04-29T12:24:07.026Z
9812511 9812511 20260427213114_EMdub AU0030 2026-04-29T12:10:16.082Z 2026-04-29T12:24:07.022Z
9812492 9812492 20260427212231_X6gHd AU0030 2026-04-29T12:10:13.217Z 2026-04-29T12:24:07.014Z
9812463 9812463 20260427210840_2RA7E AU0030 2026-04-29T12:10:07.176Z 2026-04-29T12:24:06.997Z
9812461 9812461 20260427210318_Hf3Pg AU0030 2026-04-29T12:10:06.727Z 2026-04-29T12:24:06.995Z
9812459 9812459 20260427210202_mqJ38 AU0030 2026-04-29T12:10:06.317Z 2026-04-29T12:24:06.993Z
9812429 9812429 20260427203255_Kconb AU0030 2026-04-29T12:09:56.080Z 2026-04-29T12:24:06.974Z
9812424 9812424 20260427203045_242DY AU0030 2026-04-29T12:09:54.857Z 2026-04-29T12:24:06.970Z
9812421 9812421 20260427203042_pLdhH AU0030 2026-04-29T12:09:54.288Z 2026-04-29T12:24:06.969Z
9812419 9812419 20260427202616_z80vI AU0030 2026-04-29T12:09:53.653Z 2026-04-29T12:24:06.967Z
9812402 9812402 20260427201421_9Koqf AU0030 2026-04-29T12:09:46.250Z 2026-04-29T12:24:06.955Z
9812377 9812377 20260427195323_SoLjD AU0030 2026-04-29T12:09:38.920Z 2026-04-29T12:24:06.938Z
9812375 9812375 20260427195307_TH1me AU0030 2026-04-29T12:09:38.279Z 2026-04-29T12:24:06.937Z
9812373 9812373 20260427195048_84as8 AU0030 2026-04-29T12:09:37.521Z 2026-04-29T12:24:06.935Z
9812371 9812371 20260427194733_cJUbJ AU0030 2026-04-29T12:09:36.875Z 2026-04-29T12:24:06.934Z
9812369 9812369 20260427194633_vktRH AU0030 2026-04-29T12:09:36.219Z 2026-04-29T12:24:06.931Z
9812367 9812367 20260427194403_X2ihn AU0030 2026-04-29T12:09:35.541Z 2026-04-29T12:24:06.930Z
9812326 9812326 20260427191612_9O8cv AU0030 2026-04-29T12:09:15.055Z 2026-04-29T12:24:06.896Z
9812301 9812301 20260427182242_ecLyx AU0030 2026-04-29T12:09:08.980Z 2026-04-29T12:24:06.876Z
9811552 9811552 20260427164632_FQgFt AU0030 2026-04-29T12:06:54.926Z 2026-04-29T12:24:06.573Z
9804946 9804946 20260426145543_UqV3t AU0030 2026-04-28T12:00:58.194Z 2026-04-29T12:24:25.262Z
9797841 9797841 20260425214231_KL0xN AU0030 2026-04-27T12:21:03.120Z 2026-04-29T12:39:01.419Z
9797836 9797836 20260425214229_WBjis AU0030 2026-04-27T12:21:02.655Z 2026-04-29T12:39:01.300Z
9797828 9797828 20260425214000_Bk8py AU0030 2026-04-27T12:21:00.910Z 2026-04-29T12:39:00.740Z
9797679 9797679 20260425211751_LdE7G AU0030 2026-04-27T12:20:28.842Z 2026-04-29T12:38:45.026Z
9797575 9797575 20260425210745_MRYIl AU0030 2026-04-27T12:20:03.922Z 2026-04-29T12:38:38.409Z
9797557 9797557 20260425210433_FfQow AU0030 2026-04-27T12:19:58.988Z 2026-04-29T12:38:37.359Z
9797458 9797458 20260425204756_lnqz9 AU0030 2026-04-27T12:19:35.038Z 2026-04-29T12:38:32.613Z
9797385 9797385 20260425203652_CtXOu AU0030 2026-04-27T12:19:10.561Z 2026-04-29T12:38:29.601Z
9797305 9797305 20260425202418_6wDT7 AU0030 2026-04-27T12:18:57.872Z 2026-04-29T12:38:26.151Z
9797250 9797250 20260425201637_iaCea AU0030 2026-04-27T12:18:43.450Z 2026-04-29T12:38:23.652Z
9797191 9797191 20260425200635_mkd8N AU0030 2026-04-27T12:18:30.231Z 2026-04-29T12:38:13.444Z
9797053 9797053 20260425193529_zWmyU AU0030 2026-04-27T12:17:55.647Z 2026-04-29T12:38:04.603Z
9797008 9797008 20260425193148_ZXNMY AU0030 2026-04-27T12:17:40.244Z 2026-04-29T12:38:02.747Z
9796804 9796804 20260425190238_qUcXO AU0030 2026-04-27T12:16:50.845Z 2026-04-29T12:37:53.529Z
9796673 9796673 20260425183546_HlptW AU0030 2026-04-27T12:16:09.720Z 2026-04-29T12:37:37.718Z
9796628 9796628 20260425182720_5LLS8 AU0030 2026-04-27T12:16:00.499Z 2026-04-29T12:37:35.156Z
9796595 9796595 20260425182346_nNE37 AU0030 2026-04-27T12:15:49.234Z 2026-04-29T12:37:33.930Z
9796586 9796586 20260425182210_4U1vT AU0030 2026-04-27T12:15:47.355Z 2026-04-29T12:37:33.371Z
9795762 9795762 20260425172055_YyNpD AU0030 2026-04-27T12:13:28.888Z 2026-04-29T12:36:59.713Z
9795240 9795240 20260425164848_uEW0S AU0030 2026-04-27T12:12:00.314Z 2026-04-29T12:36:41.515Z
9795206 9795206 20260425164649_nWPDm AU0030 2026-04-27T12:11:52.549Z 2026-04-29T12:36:40.374Z
9794734 9794734 20260425161506_637mj AU0030 2026-04-27T12:10:28.851Z 2026-04-29T12:36:15.284Z
9794695 9794695 20260425161138_qbHxS AU0030 2026-04-27T12:10:21.063Z 2026-04-29T12:36:13.897Z
9794647 9794647 20260425160539_4uDKi AU0030 2026-04-27T12:10:09.146Z 2026-04-29T12:36:12.670Z
9794615 9794615 20260425160412_gEBoq AU0030 2026-04-27T12:10:05.835Z 2026-04-29T12:36:11.650Z
9791116 9791116 20260424124616_lYKmu AU0030 2026-04-26T12:34:55.407Z 2026-04-29T12:59:59.690Z
9783724 9783724 20260424214421_BFozf AU0030 2026-04-26T12:15:27.853Z 2026-04-29T12:47:40.543Z
9783454 9783454 20260424212244_v2dDC AU0030 2026-04-26T12:14:50.145Z 2026-04-29T12:47:22.344Z
9783434 9783434 20260424212101_RFcbc AU0030 2026-04-26T12:14:48.555Z 2026-04-29T12:47:21.784Z
9782310 9782310 20260424183918_wDs3W AU0030 2026-04-26T12:11:33.013Z 2026-04-29T12:46:25.247Z
9782189 9782189 20260424181800_RNoZQ AU0030 2026-04-26T12:11:22.813Z 2026-04-29T12:46:21.370Z
9781778 9781778 20260424174715_xL27E AU0030 2026-04-26T12:10:22.623Z 2026-04-29T12:45:58.976Z
9781464 9781464 20260424172857_LvZM4 AU0030 2026-04-26T12:09:43.736Z 2026-04-29T12:45:51.604Z
9781438 9781438 20260424172647_e5Mgt AU0030 2026-04-26T12:09:41.431Z 2026-04-29T12:45:50.690Z
9780631 9780631 20260424164302_D8tyY AU0030 2026-04-26T12:08:04.103Z 2026-04-29T12:45:17.571Z
9780405 9780405 20260424162725_3vA2O AU0030 2026-04-26T12:07:46.447Z 2026-04-29T12:45:12.455Z
9779872 9779872 20260424155940_jzSkv AU0030 2026-04-26T12:06:33.364Z 2026-04-29T12:44:51.676Z
9779780 9779780 20260424155452_2EPLo AU0030 2026-04-26T12:06:28.262Z 2026-04-29T12:44:49.837Z
9778479 9778479 20260424144520_6Si7g AU0030 2026-04-26T12:03:48.266Z 2026-04-29T12:44:08.206Z
9776584 9776584 20260423115946_BMRPc AU0030 2026-04-25T12:58:43.537Z 2026-04-29T13:10:30.916Z
9763546 9763546 20260423182253_Nq55k AU0030 2026-04-25T12:13:02.179Z 2026-04-29T12:54:17.197Z
9763380 9763380 20260423175607_G0S0s AU0030 2026-04-25T12:12:29.066Z 2026-04-29T12:54:13.822Z
9763263 9763263 20260423174208_hn2Lv AU0030 2026-04-25T12:12:04.931Z 2026-04-29T12:54:11.782Z
9763212 9763212 20260423173813_e4s94 AU0030 2026-04-25T12:11:53.186Z 2026-04-29T12:54:11.014Z
9762939 9762939 20260423171921_9Rp0C AU0030 2026-04-25T12:11:11.547Z 2026-04-29T12:53:48.174Z
9762894 9762894 20260423171729_SXjf4 AU0030 2026-04-25T12:11:01.012Z 2026-04-29T12:53:47.531Z
9760797 9760797 20260423144240_hrgKv AU0030 2026-04-25T12:04:47.682Z 2026-04-29T12:52:53.453Z
9759473 9759473 20260423124751_Ynj56 AU0030 2026-04-25T12:00:51.962Z 2026-04-29T12:52:15.857Z
9759370 9759370 20260423123438_8udoj AU0030 2026-04-25T12:00:24.869Z 2026-04-29T12:52:14.031Z
9745254 9745254 20260422155630_0iXbz AU0030 2026-04-24T12:01:52.139Z 2026-04-29T13:01:39.581Z
9745134 9745134 20260422155024_RLJ5u AU0030 2026-04-24T12:01:48.965Z 2026-04-29T13:01:38.473Z
9744932 9744932 20260422154043_nx302 AU0030 2026-04-24T12:01:44.027Z 2026-04-29T13:01:36.519Z
9744771 9744771 20260422153231_OPjHk AU0030 2026-04-24T12:01:40.765Z 2026-04-29T13:01:35.196Z
9744713 9744713 20260422153005_PIbnd AU0030 2026-04-24T12:01:39.759Z 2026-04-29T13:01:34.672Z
9744250 9744250 20260422150557_7CFGW AU0030 2026-04-24T12:01:26.469Z 2026-04-29T13:01:30.552Z
9743068 9743068 20260422134341_9aMig AU0030 2026-04-24T12:00:49.679Z 2026-04-29T13:00:49.223Z
9743055 9743055 20260422134311_2kk3y AU0030 2026-04-24T12:00:49.485Z 2026-04-29T13:00:49.095Z
9742969 9742969 20260422133606_zicOq AU0030 2026-04-24T12:00:46.906Z 2026-04-29T13:00:48.092Z
9742862 9742862 20260422133040_wyXXF AU0030 2026-04-24T12:00:43.310Z 2026-04-29T13:00:44.182Z
9741850 9741850 20260421111001_kiIJs AU0030 2026-04-23T12:38:37.644Z 2026-04-29T13:23:13.264Z
9741839 9741839 20260421110412_Igg0R AU0030 2026-04-23T12:38:24.726Z 2026-04-29T13:23:11.877Z
9731055 9731055 20260421153212_MeS7O AU0030 2026-04-23T12:03:41.965Z 2026-04-29T13:11:12.973Z
9731047 9731047 20260421152929_cGWfu AU0030 2026-04-23T12:03:40.642Z 2026-04-29T13:11:12.827Z
9730987 9730987 20260421150253_pWZQN AU0030 2026-04-23T12:03:18.978Z 2026-04-29T13:11:09.053Z
9730856 9730856 20260421140124_ini3c AU0030 2026-04-23T12:02:37.520Z 2026-04-29T13:11:06.368Z
9730816 9730816 20260421135110_Git94 AU0030 2026-04-23T12:02:19.460Z 2026-04-29T13:11:05.478Z
9730759 9730759 20260421132318_wpdYf AU0030 2026-04-23T12:01:54.239Z 2026-04-29T13:11:03.876Z
9730693 9730693 20260421125246_gGI3Z AU0030 2026-04-23T12:01:34.757Z 2026-04-29T13:11:02.326Z
9730579 9730579 20260421114252_hvoix AU0030 2026-04-23T12:00:56.814Z 2026-04-29T13:10:54.318Z
9730544 9730544 20260421112238_PBAmk AU0030 2026-04-23T12:00:40.339Z 2026-04-29T13:10:52.606Z
9730523 9730523 20260421111739_zUR2Z AU0030 2026-04-23T12:00:33.908Z 2026-04-29T13:10:51.810Z
9723770 9723770 20260420201829_RLC0Y AU0030 2026-04-22T12:12:09.200Z 2026-04-29T13:19:08.266Z
9723749 9723749 20260420201411_3WnoW AU0030 2026-04-22T12:11:58.173Z 2026-04-29T13:19:07.821Z
9723738 9723738 20260420201151_i0xjL AU0030 2026-04-22T12:11:53.029Z 2026-04-29T13:19:07.572Z
9723652 9723652 20260420194534_iPt3s AU0030 2026-04-22T12:11:30.154Z 2026-04-29T13:19:06.343Z
9723629 9723629 20260420194216_v4H35 AU0030 2026-04-22T12:11:21.996Z 2026-04-29T13:19:05.976Z

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