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

807 rows where station_code = "AU000L" 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
8662794 8662794 20251130193232_RaNwR AU000L 2025-12-02T14:16:44.285Z 2025-12-04T14:31:36.882Z
8662541 8662541 20251130190728_92n2Z AU000L 2025-12-02T14:15:51.731Z 2025-12-04T14:31:26.604Z
8662509 8662509 20251130190231_3vkgu AU000L 2025-12-02T14:15:46.440Z 2025-12-04T14:31:25.281Z
8662093 8662093 20251130175647_bvxKB AU000L 2025-12-02T14:14:17.662Z 2025-12-04T14:30:52.428Z
8660809 8660809 20251130135345_qftJn AU000L 2025-12-02T14:09:14.378Z 2025-12-04T14:29:12.299Z
8650289 8650289 20251129194903_nwKrC AU000L 2025-12-01T14:15:43.738Z 2025-12-04T14:38:47.985Z
8650179 8650179 20251129193516_QvLge AU000L 2025-12-01T14:15:19.817Z 2025-12-04T14:38:44.072Z
8650153 8650153 20251129193137_S5531 AU000L 2025-12-01T14:15:15.421Z 2025-12-04T14:38:43.036Z
8649983 8649983 20251129190004_2g7BO AU000L 2025-12-01T14:14:38.347Z 2025-12-04T14:38:36.716Z
8649945 8649945 20251129185629_93u2F AU000L 2025-12-01T14:14:31.956Z 2025-12-04T14:38:35.329Z
8649684 8649684 20251129180629_WUG2S AU000L 2025-12-01T14:13:30.130Z 2025-12-04T14:38:09.576Z
8649660 8649660 20251129180412_CnIdk AU000L 2025-12-01T14:13:26.676Z 2025-12-04T14:38:08.674Z
8649530 8649530 20251129174216_Efss9 AU000L 2025-12-01T14:12:58.132Z 2025-12-04T14:38:02.127Z
8649475 8649475 20251129173151_eyjX0 AU000L 2025-12-01T14:12:46.528Z 2025-12-04T14:37:59.568Z
8649315 8649315 20251129170406_d3Owm AU000L 2025-12-01T14:11:59.441Z 2025-12-04T14:37:52.346Z
8649221 8649221 20251129164302_jmxn7 AU000L 2025-12-01T14:11:29.975Z 2025-12-04T14:37:49.057Z
8649217 8649217 20251129164246_Yg191 AU000L 2025-12-01T14:11:28.614Z 2025-12-04T14:37:48.882Z
8649134 8649134 20251129162059_ZDlcM AU000L 2025-12-01T14:11:04.743Z 2025-12-04T14:37:44.832Z
8648917 8648917 20251129150744_VuPJY AU000L 2025-12-01T14:09:34.326Z 2025-12-04T14:37:14.751Z
8648875 8648875 20251129142105_xMePO AU000L 2025-12-01T14:08:44.287Z 2025-12-04T14:37:07.742Z
8648851 8648851 20251129135850_SoNkl AU000L 2025-12-01T14:08:22.717Z 2025-12-04T14:37:04.631Z
8648788 8648788 20251129123140_IEaFB AU000L 2025-12-01T14:06:25.940Z 2025-12-04T14:36:38.075Z
8648768 8648768 20251129122330_WO71c AU000L 2025-12-01T14:06:05.783Z 2025-12-04T14:36:35.145Z
8643446 8643446 20251128175750_41H3g AU000L 2025-11-30T14:20:02.057Z 2025-12-04T14:47:45.252Z
8643427 8643427 20251128175527_PlK3u AU000L 2025-11-30T14:20:01.145Z 2025-12-04T14:47:44.921Z
8643034 8643034 20251128171404_odUrg AU000L 2025-11-30T14:19:15.297Z 2025-12-04T14:47:37.837Z
8642509 8642509 20251128161421_vWbnW AU000L 2025-11-30T14:18:04.014Z 2025-12-04T14:47:02.171Z
8642079 8642079 20251128153013_7VR1R AU000L 2025-11-30T14:17:19.626Z 2025-12-04T14:46:54.533Z
8641057 8641057 20251128133329_JviH3 AU000L 2025-11-30T14:14:00.141Z 2025-12-04T14:46:05.671Z
8640711 8640711 20251129153407_E5Ue8 AU000L 2025-11-30T14:09:20.858Z 2025-12-04T14:37:20.470Z
8640415 8640415 20251129141115_JlB3W AU000L 2025-11-30T14:08:18.596Z 2025-12-04T14:37:05.939Z
8639965 8639965 20251129123140_XGthP AU000L 2025-11-30T14:06:46.362Z 2025-11-30T14:06:46.362Z
8622286 8622286 20251126183614_XnB3r AU000L 2025-11-28T14:18:19.411Z 2025-12-04T15:02:10.278Z
8621287 8621287 20251126145141_tF802 AU000L 2025-11-28T14:15:13.236Z 2025-12-04T15:01:35.519Z
8578053 8578053 20251122193438_Q8fLh AU000L 2025-11-24T14:10:38.044Z 2025-12-01T15:19:07.701Z
8577092 8577092 20251122171901_VVOhe AU000L 2025-11-24T14:07:32.106Z 2025-12-01T15:18:43.291Z
8577004 8577004 20251122170044_TTuWw AU000L 2025-11-24T14:07:19.013Z 2025-12-01T15:18:42.480Z
8576892 8576892 20251122163518_2106r AU000L 2025-11-24T14:06:55.771Z 2025-12-01T15:18:41.079Z
8576817 8576817 20251122161959_4yKJX AU000L 2025-11-24T14:06:48.278Z 2025-12-01T15:18:40.411Z
8576782 8576782 20251122161401_NOzvj AU000L 2025-11-24T14:06:44.601Z 2025-12-01T15:18:40.054Z
8575969 8575969 20251122135726_3oU0E AU000L 2025-11-24T14:04:35.420Z 2025-12-01T15:18:32.185Z
8563009 8563009 20251121150716_pW1aH AU000L 2025-11-23T14:07:04.339Z 2025-11-30T15:03:34.699Z
8562820 8562820 20251121144745_ywuD8 AU000L 2025-11-23T14:06:36.478Z 2025-11-30T15:03:33.200Z
8489654 8489654 20251116171639_2vPHM AU000L 2025-11-18T14:11:00.761Z 2025-11-25T15:07:34.976Z
8489574 8489574 20251116170224_FKeiB AU000L 2025-11-18T14:10:37.488Z 2025-11-25T15:07:32.351Z
8489295 8489295 20251116155245_R3WLh AU000L 2025-11-18T14:09:30.899Z 2025-11-25T15:07:23.630Z
8489231 8489231 20251116154121_v0Tpw AU000L 2025-11-18T14:09:14.206Z 2025-11-25T15:07:21.796Z
8488504 8488504 20251116143242_B22x7 AU000L 2025-11-18T14:06:42.240Z 2025-11-25T15:06:48.671Z
8487598 8487598 20251116130817_D7mQZ AU000L 2025-11-18T14:03:47.606Z 2025-11-25T15:06:18.030Z
8487279 8487279 20251116123659_VrryL AU000L 2025-11-18T14:02:46.878Z 2025-11-25T15:06:10.647Z
8479401 8479401 20251115191548_i2p2C AU000L 2025-11-17T14:15:47.789Z 2025-11-24T15:04:44.487Z
8479193 8479193 20251115184805_7gYgn AU000L 2025-11-17T14:15:10.543Z 2025-11-24T15:04:35.131Z
8479101 8479101 20251115183701_G7yXI AU000L 2025-11-17T14:14:57.918Z 2025-11-24T15:04:32.588Z
8479028 8479028 20251115182947_jYhb7 AU000L 2025-11-17T14:14:52.852Z 2025-11-24T15:04:31.496Z
8466575 8466575 20251114184031_Ba3rb AU000L 2025-11-16T14:12:29.638Z 2025-11-23T15:17:03.778Z
8466532 8466532 20251114183738_POUfS AU000L 2025-11-16T14:12:24.225Z 2025-11-23T15:17:03.462Z
8456626 8456626 20251113190518_Rzjd8 AU000L 2025-11-15T14:11:46.595Z 2025-11-22T15:20:45.263Z
8456367 8456367 20251113183153_Hsa2e AU000L 2025-11-15T14:11:08.176Z 2025-11-22T15:20:43.628Z
8444772 8444772 20251112134541_dHsBX AU000L 2025-11-14T14:05:23.274Z 2025-11-21T15:10:29.315Z
8444442 8444442 20251112122905_2awHp AU000L 2025-11-14T14:04:02.347Z 2025-11-21T15:10:17.721Z
8435595 8435595 20251111195043_TlZeP AU000L 2025-11-13T14:15:51.673Z 2025-11-20T15:22:24.264Z
8433373 8433373 20251111165404_Vo3OW AU000L 2025-11-13T14:10:06.934Z 2025-11-20T15:20:44.641Z
8433003 8433003 20251111162638_ct22U AU000L 2025-11-13T14:09:11.064Z 2025-11-20T15:20:30.458Z
8432550 8432550 20251111153930_usPgX AU000L 2025-11-13T14:07:55.890Z 2025-11-20T15:20:16.569Z
8432384 8432384 20251111152609_wBtU2 AU000L 2025-11-13T14:07:23.637Z 2025-11-20T15:20:12.996Z
8431985 8431985 20251111145545_poAol AU000L 2025-11-13T14:06:22.627Z 2025-11-20T15:20:06.703Z
8431243 8431243 20251111134741_3nHoa AU000L 2025-11-13T14:03:48.967Z 2025-11-20T15:19:53.472Z
8430858 8430858 20251111131403_Kx9zw AU000L 2025-11-13T14:02:39.157Z 2025-11-20T15:19:44.222Z
8419776 8419776 20251110173349_H9ov0 AU000L 2025-11-12T14:08:10.298Z 2025-11-19T15:13:25.888Z
8419743 8419743 20251110173018_LknlA AU000L 2025-11-12T14:08:02.142Z 2025-11-19T15:13:22.086Z
8419245 8419245 20251110155856_br682 AU000L 2025-11-12T14:06:04.104Z 2025-11-19T15:13:04.571Z
8419107 8419107 20251110153211_xJtyF AU000L 2025-11-12T14:05:27.305Z 2025-11-19T15:12:59.706Z
8418513 8418513 20251110135558_zGU2c AU000L 2025-11-12T14:02:27.500Z 2025-11-19T15:12:33.963Z
8411984 8411984 20251109193824_aiOj7 AU000L 2025-11-11T14:12:42.297Z 2025-11-18T15:19:55.548Z
8410550 8410550 20251109170021_Sa2HH AU000L 2025-11-11T14:07:53.110Z 2025-11-18T15:19:01.950Z
8410385 8410385 20251109163152_p15o3 AU000L 2025-11-11T14:07:20.350Z 2025-11-18T15:18:56.949Z
8410273 8410273 20251109160311_WNVFB AU000L 2025-11-11T14:06:50.213Z 2025-11-18T15:18:53.455Z
8410141 8410141 20251109153617_5nVGi AU000L 2025-11-11T14:06:13.999Z 2025-11-18T15:18:50.078Z
8409971 8409971 20251109150122_k4BoR AU000L 2025-11-11T14:05:26.635Z 2025-11-18T15:18:46.485Z
8409921 8409921 20251109145019_kkfSv AU000L 2025-11-11T14:05:15.744Z 2025-11-18T15:18:45.445Z
8409276 8409276 20251109122929_8tdV1 AU000L 2025-11-11T14:01:56.880Z 2025-11-18T15:18:23.738Z
8402409 8402409 20251108194528_Uy57i AU000L 2025-11-10T14:06:49.170Z 2025-11-17T14:58:17.100Z
8402403 8402403 20251108194204_FjSpt AU000L 2025-11-10T14:06:47.794Z 2025-11-17T14:58:16.971Z
8401798 8401798 20251108173346_DKedP AU000L 2025-11-10T14:04:25.585Z 2025-11-17T14:58:02.415Z
8401635 8401635 20251108155502_3ABZE AU000L 2025-11-10T14:03:32.133Z 2025-11-17T14:57:56.594Z
8401444 8401444 20251108145614_AzAM6 AU000L 2025-11-10T14:02:36.680Z 2025-11-17T14:57:48.984Z
8401423 8401423 20251108144846_utnKM AU000L 2025-11-10T14:02:33.445Z 2025-11-17T14:57:48.885Z
8401347 8401347 20251108143028_VD7HE AU000L 2025-11-10T14:02:20.601Z 2025-11-17T14:57:47.632Z
8401153 8401153 20251108130025_ShMQR AU000L 2025-11-10T14:00:59.992Z 2025-11-17T14:57:44.702Z
8400942 8400942 20251107121529_ve96i AU000L 2025-11-09T14:30:17.957Z 2025-11-15T15:01:09.848Z
8400647 8400647 20251108121159_GNFww AU000L 2025-11-09T14:21:24.487Z 2025-11-16T15:06:01.937Z
8396170 8396170 20251107194549_ucyLh AU000L 2025-11-09T14:07:36.882Z 2025-11-16T15:03:15.523Z
8396048 8396048 20251107191716_RTyd9 AU000L 2025-11-09T14:07:05.684Z 2025-11-16T15:03:05.376Z
8395979 8395979 20251107190126_cX1OY AU000L 2025-11-09T14:06:46.804Z 2025-11-16T15:03:01.622Z
8395931 8395931 20251107185031_9VAoX AU000L 2025-11-09T14:06:34.567Z 2025-11-16T15:02:59.594Z
8395922 8395922 20251107184746_L5d7p AU000L 2025-11-09T14:06:32.540Z 2025-11-16T15:02:59.284Z
8395907 8395907 20251107184220_vAmoj AU000L 2025-11-09T14:06:28.843Z 2025-11-16T15:02:58.963Z
8395765 8395765 20251107180845_NF78H AU000L 2025-11-09T14:05:51.758Z 2025-11-16T15:02:45.470Z
8395735 8395735 20251107175838_HBg96 AU000L 2025-11-09T14:05:39.082Z 2025-11-16T15:02:42.056Z
8395557 8395557 20251107171255_kT325 AU000L 2025-11-09T14:04:53.919Z 2025-11-16T15:02:32.269Z

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