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

2,977 rows where station_code = "AU0042" 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
8673327 8673327 20251201182610_dRz3K AU0042 2025-12-03T14:18:17.471Z 2025-12-06T14:32:58.761Z
8673296 8673296 20251201181251_SSut1 AU0042 2025-12-03T14:18:13.071Z 2025-12-06T14:32:57.380Z
8673263 8673263 20251201175541_vL1zl AU0042 2025-12-03T14:18:07.835Z 2025-12-06T14:32:54.298Z
8673214 8673214 20251201173103_8mzBU AU0042 2025-12-03T14:17:59.671Z 2025-12-06T14:32:49.429Z
8663062 8663062 20251130200143_utd2k AU0042 2025-12-02T14:17:22.073Z 2025-12-06T14:39:46.381Z
8662696 8662696 20251130192048_28cwy AU0042 2025-12-02T14:16:18.926Z 2025-12-06T14:39:26.178Z
8662685 8662685 20251130192022_7GsFx AU0042 2025-12-02T14:16:17.964Z 2025-12-06T14:39:26.049Z
8662562 8662562 20251130191054_Id3TB AU0042 2025-12-02T14:15:53.783Z 2025-12-02T14:15:53.783Z
8662488 8662488 20251130185822_b8WxC AU0042 2025-12-02T14:15:42.973Z 2025-12-06T14:39:20.174Z
8662417 8662417 20251130184805_L2vk2 AU0042 2025-12-02T14:15:25.801Z 2025-12-06T14:39:17.878Z
8662326 8662326 20251130183226_iZvtg AU0042 2025-12-02T14:15:08.691Z 2025-12-06T14:38:59.065Z
8662234 8662234 20251130182135_m4sRB AU0042 2025-12-02T14:14:45.818Z 2025-12-06T14:38:56.680Z
8662092 8662092 20251130175606_Tfe35 AU0042 2025-12-02T14:14:17.085Z 2025-12-06T14:38:49.857Z
8661943 8661943 20251130173459_k0ZIy AU0042 2025-12-02T14:13:40.190Z 2025-12-06T14:38:43.009Z
8661894 8661894 20251130173012_n731r AU0042 2025-12-02T14:13:33.617Z 2025-12-06T14:38:41.240Z
8661851 8661851 20251130172416_UbbgW AU0042 2025-12-02T14:13:14.992Z 2025-12-06T14:38:39.341Z
8661770 8661770 20251130171035_X3QlT AU0042 2025-12-02T14:12:59.635Z 2025-12-06T14:38:29.928Z
8661628 8661628 20251130163511_ZTTIx AU0042 2025-12-02T14:12:23.497Z 2025-12-06T14:38:17.870Z
8661571 8661571 20251130160055_KAE54 AU0042 2025-12-02T14:12:03.871Z 2025-12-06T14:38:13.024Z
8661569 8661569 20251130160050_hgoyo AU0042 2025-12-02T14:12:03.496Z 2025-12-06T14:38:12.890Z
8661480 8661480 20251130153007_LYN2e AU0042 2025-12-02T14:11:37.041Z 2025-12-06T14:38:07.164Z
8661455 8661455 20251130152501_iLIyx AU0042 2025-12-02T14:11:32.509Z 2025-12-06T14:38:05.904Z
8661354 8661354 20251130151059_V353H AU0042 2025-12-02T14:11:10.101Z 2025-12-06T14:38:02.909Z
8661136 8661136 20251130144744_xsx3D AU0042 2025-12-02T14:10:30.760Z 2025-12-06T14:37:38.281Z
8660643 8660643 20251130132150_3zoMc AU0042 2025-12-02T14:08:38.569Z 2025-12-06T14:37:21.395Z
8660345 8660345 20251130123557_XqhvU AU0042 2025-12-02T14:07:28.365Z 2025-12-06T14:37:01.096Z
8644471 8644471 20251128192822_eBOZh AU0042 2025-11-30T14:22:01.385Z 2025-12-06T14:54:42.697Z
8644293 8644293 20251128191756_G5y7C AU0042 2025-11-30T14:21:34.613Z 2025-12-06T14:54:40.444Z
8644276 8644276 20251128191523_CVtS9 AU0042 2025-11-30T14:21:33.293Z 2025-12-06T14:54:40.232Z
8644274 8644274 20251128191521_Qh2Ji AU0042 2025-11-30T14:21:33.165Z 2025-12-06T14:54:40.227Z
8644125 8644125 20251128190008_Ut26a AU0042 2025-11-30T14:21:22.426Z 2025-12-06T14:54:38.467Z
8644010 8644010 20251128184911_EoXCH AU0042 2025-11-30T14:21:07.370Z 2025-12-06T14:54:36.800Z
8643879 8643879 20251128183451_4MX0W AU0042 2025-11-30T14:20:46.398Z 2025-12-06T14:54:29.400Z
8643777 8643777 20251128182611_cVMzh AU0042 2025-11-30T14:20:40.399Z 2025-12-06T14:54:13.437Z
8643769 8643769 20251128182524_WPefK AU0042 2025-11-30T14:20:39.600Z 2025-12-06T14:54:13.002Z
8643438 8643438 20251128175546_Hot5e AU0042 2025-11-30T14:20:01.616Z 2025-12-06T14:53:49.571Z
8643426 8643426 20251128175512_Z8LlS AU0042 2025-11-30T14:20:00.911Z 2025-12-06T14:53:49.448Z
8643256 8643256 20251128173910_bo2b4 AU0042 2025-11-30T14:19:48.446Z 2025-12-06T14:53:44.641Z
8642778 8642778 20251128164717_LmOpk AU0042 2025-11-30T14:18:36.380Z 2025-12-06T14:53:36.285Z
8642729 8642729 20251128164156_JmhfU AU0042 2025-11-30T14:18:32.892Z 2025-12-06T14:53:35.750Z
8641307 8641307 20251128142405_X90p2 AU0042 2025-11-30T14:15:27.500Z 2025-12-06T14:52:30.418Z
8641225 8641225 20251128141002_yO3s8 AU0042 2025-11-30T14:15:05.050Z 2025-12-06T14:52:28.156Z
8640942 8640942 20251128125328_2zvg2 AU0042 2025-11-30T14:12:27.258Z 2025-12-06T14:51:53.432Z
8640865 8640865 20251128121924_Z7JHE AU0042 2025-11-30T14:11:21.459Z 2025-12-06T14:51:34.359Z
8631775 8631775 20251127195954_icaPs AU0042 2025-11-29T14:16:22.454Z 2025-12-06T15:00:41.515Z
8631634 8631634 20251127193739_vGaqO AU0042 2025-11-29T14:15:53.784Z 2025-12-06T15:00:29.735Z
8631566 8631566 20251127192710_mDx3h AU0042 2025-11-29T14:15:45.883Z 2025-12-06T15:00:20.523Z
8631496 8631496 20251127191648_HFit8 AU0042 2025-11-29T14:15:37.973Z 2025-12-06T15:00:14.725Z
8631256 8631256 20251127184044_66rku AU0042 2025-11-29T14:15:00.520Z 2025-12-06T15:00:00.885Z
8631106 8631106 20251127181950_dlXCJ AU0042 2025-11-29T14:14:34.278Z 2025-12-06T14:59:54.114Z
8631023 8631023 20251127180452_WPJiv AU0042 2025-11-29T14:14:26.299Z 2025-12-06T14:59:50.201Z
8630676 8630676 20251127170401_FYD2b AU0042 2025-11-29T14:13:26.790Z 2025-12-06T14:59:16.899Z
8630644 8630644 20251127165629_RMfsp AU0042 2025-11-29T14:13:22.719Z 2025-12-06T14:59:15.104Z
8630420 8630420 20251127161105_8ihug AU0042 2025-11-29T14:12:38.757Z 2025-12-06T14:59:04.379Z
8630178 8630178 20251127150253_8NrHY AU0042 2025-11-29T14:11:59.777Z 2025-12-06T14:58:59.530Z
8630069 8630069 20251127140108_iO3bb AU0042 2025-11-29T14:11:29.287Z 2025-12-06T14:58:54.464Z
8630022 8630022 20251127122451_npmTQ AU0042 2025-11-29T14:10:57.586Z 2025-12-06T14:58:45.489Z
8622418 8622418 20251126190817_aLlPt AU0042 2025-11-28T14:18:49.695Z 2025-12-05T15:02:56.696Z
8621634 8621634 20251126155345_smxNM AU0042 2025-11-28T14:16:17.413Z 2025-12-05T15:02:46.179Z
8621567 8621567 20251126154137_aTOIk AU0042 2025-11-28T14:16:02.372Z 2025-12-05T15:02:45.463Z
8621510 8621510 20251126152610_dsXfN AU0042 2025-11-28T14:15:51.071Z 2025-12-05T15:02:44.927Z
8595826 8595826 20251124183618_xGuTp AU0042 2025-11-26T14:12:43.220Z 2025-12-02T15:06:13.321Z
8595740 8595740 20251124181451_bxLlW AU0042 2025-11-26T14:12:20.252Z 2025-12-02T15:06:06.764Z
8595425 8595425 20251124154525_JCkWN AU0042 2025-11-26T14:11:03.140Z 2025-12-02T15:05:56.598Z
8595410 8595410 20251124153053_kjh8l AU0042 2025-11-26T14:11:00.960Z 2025-12-02T15:05:56.305Z
8595324 8595324 20251124150604_CnMzj AU0042 2025-11-26T14:10:45.021Z 2025-12-02T15:05:52.307Z
8585639 8585639 20251123171908_3cKT2 AU0042 2025-11-25T14:10:26.835Z 2025-12-02T15:10:07.186Z
8585492 8585492 20251123162907_l52ik AU0042 2025-11-25T14:09:52.066Z 2025-12-02T15:09:58.853Z
8585470 8585470 20251123160250_4kSHk AU0042 2025-11-25T14:09:39.798Z 2025-12-02T15:09:58.365Z
8520742 8520742 20251118195847_e5nZ1 AU0042 2025-11-20T14:10:46.858Z 2025-11-27T15:11:35.112Z
8520710 8520710 20251118195503_792g4 AU0042 2025-11-20T14:10:42.929Z 2025-11-27T15:11:34.842Z
8520625 8520625 20251118194457_ZsDpN AU0042 2025-11-20T14:10:24.233Z 2025-11-27T15:11:34.345Z
8520589 8520589 20251118194123_hoXLU AU0042 2025-11-20T14:10:16.957Z 2025-11-27T15:11:34.209Z
8520321 8520321 20251118191505_6BvVJ AU0042 2025-11-20T14:09:35.669Z 2025-11-27T15:11:32.649Z
8520317 8520317 20251118191456_uljYF AU0042 2025-11-20T14:09:34.178Z 2025-11-27T15:11:32.581Z
8520095 8520095 20251118184813_SfW2c AU0042 2025-11-20T14:08:57.693Z 2025-11-27T15:11:31.117Z
8520093 8520093 20251118184754_LhnSy AU0042 2025-11-20T14:08:57.205Z 2025-11-27T15:11:31.097Z
8519734 8519734 20251118180024_XLdt2 AU0042 2025-11-20T14:07:48.082Z 2025-11-27T15:11:28.672Z
8519653 8519653 20251118174704_5Exg2 AU0042 2025-11-20T14:07:27.678Z 2025-11-27T15:11:28.297Z
8518456 8518456 20251118141728_L3pZ5 AU0042 2025-11-20T14:03:34.952Z 2025-11-27T15:11:03.856Z
8488520 8488520 20251116143408_gwHYY AU0042 2025-11-18T14:06:45.124Z 2025-11-25T15:06:49.472Z
8488508 8488508 20251116143248_KAIKJ AU0042 2025-11-18T14:06:42.659Z 2025-11-25T15:06:48.672Z
8487975 8487975 20251116134847_d58Oj AU0042 2025-11-18T14:05:03.355Z 2025-11-25T15:06:33.009Z
8487649 8487649 20251116131451_vVUe5 AU0042 2025-11-18T14:04:03.121Z 2025-11-25T15:06:24.320Z
8455702 8455702 20251113172625_sXJ3D AU0042 2025-11-15T14:09:36.175Z 2025-11-22T15:20:23.785Z
8455592 8455592 20251113171446_nX75w AU0042 2025-11-15T14:09:23.312Z 2025-11-22T15:20:18.583Z
8453785 8453785 20251113141838_F52WT AU0042 2025-11-15T14:03:48.600Z 2025-11-22T15:18:50.189Z
8447147 8447147 20251112190218_2GTXV AU0042 2025-11-14T14:13:13.986Z 2025-11-21T15:11:16.478Z
8446169 8446169 20251112165849_QIgRN AU0042 2025-11-14T14:09:51.151Z 2025-11-21T15:11:07.910Z
8446120 8446120 20251112164900_rupr7 AU0042 2025-11-14T14:09:32.017Z 2025-11-21T15:11:07.316Z
8445854 8445854 20251112160949_Pl0kf AU0042 2025-11-14T14:08:41.498Z 2025-11-21T15:11:05.342Z
8445597 8445597 20251112154330_MW2sW AU0042 2025-11-14T14:08:01.620Z 2025-11-21T15:10:57.678Z
8444988 8444988 20251112142836_YeBH3 AU0042 2025-11-14T14:06:01.867Z 2025-11-21T15:10:34.904Z
8444980 8444980 20251112142606_peglR AU0042 2025-11-14T14:05:59.822Z 2025-11-21T15:10:34.472Z
8420998 8420998 20251110195527_JYYWJ AU0042 2025-11-12T14:12:45.402Z 2025-11-19T15:14:18.677Z
8420811 8420811 20251110193748_FEudy AU0042 2025-11-12T14:12:10.804Z 2025-11-19T15:14:15.907Z
8420252 8420252 20251110183439_L3YzY AU0042 2025-11-12T14:09:58.653Z 2025-11-19T15:13:44.555Z
8419866 8419866 20251110174918_3HcvG AU0042 2025-11-12T14:08:35.198Z 2025-11-19T15:13:29.475Z
8419762 8419762 20251110173235_Ohd0P AU0042 2025-11-12T14:08:04.659Z 2025-11-19T15:13:22.552Z
8419668 8419668 20251110171610_jUlcN AU0042 2025-11-12T14:07:48.003Z 2025-11-19T15:13:19.808Z

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