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

9,362 rows where station_code = "AU000C" 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
9271770 9271770 20260127195853_eviYd AU000C 2026-01-29T14:23:24.380Z 2026-01-29T14:30:25.122Z
9271621 9271621 20260127184221_Ibft4 AU000C 2026-01-29T14:21:52.299Z 2026-01-29T14:30:24.976Z
9271573 9271573 20260127180547_10n2u AU000C 2026-01-29T14:21:34.654Z 2026-01-29T14:30:24.925Z
9271471 9271471 20260127164708_xtto6 AU000C 2026-01-29T14:20:46.267Z 2026-01-29T14:30:24.826Z
9271446 9271446 20260127160308_M7a4c AU000C 2026-01-29T14:20:23.406Z 2026-01-29T14:30:24.690Z
9271413 9271413 20260127151835_jJ9fv AU000C 2026-01-29T14:19:48.375Z 2026-01-29T14:30:24.556Z
9271390 9271390 20260127144725_FGWuI AU000C 2026-01-29T14:19:25.336Z 2026-01-29T14:30:24.512Z
9271386 9271386 20260127144414_QKufp AU000C 2026-01-29T14:19:23.646Z 2026-01-29T14:30:24.509Z
9267198 9267198 20260126202637_8GbDg AU000C 2026-01-28T14:20:16.152Z 2026-01-29T14:34:33.000Z
9267187 9267187 20260126202220_q9f1O AU000C 2026-01-28T14:20:11.062Z 2026-01-29T14:34:29.879Z
9267139 9267139 20260126194402_2OvIk AU000C 2026-01-28T14:19:37.472Z 2026-01-29T14:34:23.447Z
9267106 9267106 20260126190631_JvAox AU000C 2026-01-28T14:19:16.305Z 2026-01-29T14:34:18.014Z
9267098 9267098 20260126185450_PbYpy AU000C 2026-01-28T14:19:11.211Z 2026-01-29T14:34:16.743Z
9267084 9267084 20260126184820_Zxh8N AU000C 2026-01-28T14:19:05.953Z 2026-01-29T14:34:15.251Z
9267076 9267076 20260126184211_gaNrm AU000C 2026-01-28T14:18:57.443Z 2026-01-29T14:34:13.755Z
9267072 9267072 20260126184021_3aDMs AU000C 2026-01-28T14:18:54.181Z 2026-01-29T14:34:12.996Z
9267022 9267022 20260126180708_2f9Wl AU000C 2026-01-28T14:18:24.209Z 2026-01-29T14:33:56.369Z
9267005 9267005 20260126174612_4kAiY AU000C 2026-01-28T14:18:14.595Z 2026-01-29T14:33:53.959Z
9266980 9266980 20260126173252_m7WTZ AU000C 2026-01-28T14:18:06.702Z 2026-01-29T14:33:52.067Z
9266967 9266967 20260126172524_vdDzb AU000C 2026-01-28T14:18:02.784Z 2026-01-29T14:33:50.709Z
9266963 9266963 20260126172359_2Zi3v AU000C 2026-01-28T14:17:56.225Z 2026-01-29T14:33:50.074Z
9266951 9266951 20260126171530_AlPP3 AU000C 2026-01-28T14:17:50.412Z 2026-01-29T14:33:48.047Z
9266890 9266890 20260126155152_2ixvP AU000C 2026-01-28T14:17:18.129Z 2026-01-29T14:33:37.899Z
9262574 9262574 20260125202357_HBX5Q AU000C 2026-01-27T14:13:44.336Z 2026-01-29T14:38:20.490Z
9254605 9254605 20260123201951_gQgob AU000C 2026-01-25T14:10:01.712Z 2026-01-29T14:46:32.022Z
9254559 9254559 20260123201153_uFAxs AU000C 2026-01-25T14:09:49.413Z 2026-01-29T14:46:30.190Z
9254550 9254550 20260123201043_It0DE AU000C 2026-01-25T14:09:47.045Z 2026-01-29T14:46:29.812Z
9254537 9254537 20260123200122_uWEUZ AU000C 2026-01-25T14:09:41.357Z 2026-01-29T14:46:29.193Z
9254500 9254500 20260123194920_xRcv0 AU000C 2026-01-25T14:09:30.621Z 2026-01-29T14:46:26.939Z
9206879 9206879 20260114193420_Q63j7 AU000C 2026-01-16T14:05:59.464Z 2026-01-22T15:02:41.770Z
9206750 9206750 20260114184312_0bpyW AU000C 2026-01-16T14:05:24.376Z 2026-01-22T15:02:35.447Z
9206709 9206709 20260114182507_9jAo7 AU000C 2026-01-16T14:05:12.746Z 2026-01-22T15:02:34.174Z
9206541 9206541 20260114173534_uEinh AU000C 2026-01-16T14:04:22.383Z 2026-01-22T15:02:29.296Z
9206536 9206536 20260114173406_o9P3P AU000C 2026-01-16T14:04:21.643Z 2026-01-22T15:02:29.250Z
9206532 9206532 20260114173134_0WLRJ AU000C 2026-01-16T14:04:21.075Z 2026-01-22T15:02:29.146Z
9206422 9206422 20260114164419_f9fu4 AU000C 2026-01-16T14:03:50.502Z 2026-01-22T15:02:25.106Z
9206399 9206399 20260114163758_WYDOm AU000C 2026-01-16T14:03:43.075Z 2026-01-22T15:02:23.800Z
9206392 9206392 20260114163230_1avXz AU000C 2026-01-16T14:03:41.225Z 2026-01-22T15:02:23.583Z
9206344 9206344 20260114161230_vZn6i AU000C 2026-01-16T14:03:26.529Z 2026-01-22T15:02:10.843Z
9206330 9206330 20260114155555_uggUg AU000C 2026-01-16T14:03:21.928Z 2026-01-22T15:02:06.775Z
9206310 9206310 20260114153606_KGH9o AU000C 2026-01-16T14:03:12.986Z 2026-01-22T15:02:00.752Z
9206166 9206166 20260114135447_2p7SU AU000C 2026-01-16T14:02:28.439Z 2026-01-22T15:01:51.502Z
9205743 9205743 20260113125430_866JF AU000C 2026-01-15T14:41:16.503Z 2026-01-21T15:06:26.220Z
9199351 9199351 20260113194850_sKM8C AU000C 2026-01-15T14:10:29.330Z 2026-01-22T15:07:22.448Z
9199198 9199198 20260113192131_dZCso AU000C 2026-01-15T14:09:44.058Z 2026-01-22T15:07:16.523Z
9199049 9199049 20260113185515_XtHVi AU000C 2026-01-15T14:09:01.910Z 2026-01-22T15:07:12.757Z
9199018 9199018 20260113185119_w9n8F AU000C 2026-01-15T14:08:54.673Z 2026-01-22T15:07:11.813Z
9198867 9198867 20260113181721_MKBFE AU000C 2026-01-15T14:07:48.987Z 2026-01-22T15:07:06.933Z
9198858 9198858 20260113181616_nKS2s AU000C 2026-01-15T14:07:46.957Z 2026-01-22T15:07:06.806Z
9198742 9198742 20260113174922_hSV1M AU000C 2026-01-15T14:06:51.847Z 2026-01-22T15:07:02.733Z
9198429 9198429 20260113162340_ToeOa AU000C 2026-01-15T14:04:24.582Z 2026-01-22T15:06:27.518Z
9198398 9198398 20260113161030_aVP0A AU000C 2026-01-15T14:04:02.670Z 2026-01-22T15:06:26.111Z
9198355 9198355 20260113155025_3BjZH AU000C 2026-01-15T14:03:34.153Z 2026-01-22T15:06:24.111Z
9198347 9198347 20260113154731_4Do4O AU000C 2026-01-15T14:03:31.907Z 2026-01-22T15:06:23.814Z
9198280 9198280 20260113151847_AvgfU AU000C 2026-01-15T14:02:52.928Z 2026-01-22T15:06:20.912Z
9198214 9198214 20260113144428_dMtBd AU000C 2026-01-15T14:02:16.450Z 2026-01-22T15:06:18.272Z
9198203 9198203 20260113143804_3YDH1 AU000C 2026-01-15T14:02:05.603Z 2026-01-22T15:06:17.360Z
9198147 9198147 20260113135932_33Z4u AU000C 2026-01-15T14:01:28.617Z 2026-01-22T15:06:15.034Z
9156835 9156835 20260104134042_ZGFyf AU000C 2026-01-06T14:40:56.768Z 2026-01-12T15:12:39.421Z
9156736 9156736 20260104130521_0qfod AU000C 2026-01-06T14:40:41.833Z 2026-01-12T15:12:34.869Z
9126081 9126081 20251230185450_C3SBb AU000C 2026-01-02T15:08:36.986Z 2026-01-07T15:13:16.646Z
9125935 9125935 20251230165033_zU0bY AU000C 2026-01-02T15:05:54.136Z 2026-01-07T15:12:10.809Z
9125768 9125768 20251231184535_c72GG AU000C 2026-01-02T14:56:03.606Z 2026-01-08T15:15:58.187Z
9125570 9125570 20251231182200_MXEzA AU000C 2026-01-02T14:55:33.226Z 2026-01-08T15:15:47.428Z
9120782 9120782 20251231193739_xaN4R AU000C 2026-01-02T14:04:14.715Z 2026-01-09T14:51:23.614Z
9120622 9120622 20251231191333_POA32 AU000C 2026-01-02T14:03:25.374Z 2026-01-09T14:51:16.490Z
9120601 9120601 20251231191234_EslRB AU000C 2026-01-02T14:03:20.433Z 2026-01-09T14:51:15.745Z
9120558 9120558 20251231190638_VqLxH AU000C 2026-01-02T14:03:06.042Z 2026-01-09T14:51:14.014Z
9120203 9120203 20260101184922_4ww9F AU000C 2026-01-02T14:00:25.942Z 2026-01-09T14:48:09.037Z
9120200 9120200 20260101184915_63Ku1 AU000C 2026-01-02T14:00:24.786Z 2026-01-09T14:48:08.894Z
9120195 9120195 20260101184842_ssBd3 AU000C 2026-01-02T14:00:22.111Z 2026-01-09T14:48:08.529Z
9120170 9120170 20251228195721_lPaZH AU000C 2026-01-01T15:34:11.625Z 2026-01-05T15:14:26.674Z
9120147 9120147 20251228182710_2T6AO AU000C 2026-01-01T15:33:01.282Z 2026-01-05T15:14:07.337Z
9119661 9119661 20251230183541_Wt0iC AU000C 2026-01-01T14:56:46.191Z 2026-01-07T15:13:00.067Z
9119524 9119524 20251230181316_UBP3I AU000C 2026-01-01T14:56:22.476Z 2026-01-07T15:12:50.278Z
9119183 9119183 20251230165501_XYXMI AU000C 2026-01-01T14:55:09.341Z 2026-01-07T15:12:11.955Z
9119112 9119112 20251230162804_JOZHw AU000C 2026-01-01T14:54:52.290Z 2026-01-07T15:12:05.399Z
9119043 9119043 20251230160840_CBWiV AU000C 2026-01-01T14:54:34.927Z 2026-01-07T15:11:52.943Z
9119030 9119030 20251230160417_vpNa9 AU000C 2026-01-01T14:54:32.991Z 2026-01-07T15:11:52.214Z
9118984 9118984 20251230153248_Vic2Z AU000C 2026-01-01T14:54:21.389Z 2026-01-07T15:11:45.754Z
9109404 9109404 20251230193150_p8eAK AU000C 2026-01-01T14:00:11.772Z 2026-01-08T15:03:46.914Z
9109296 9109296 20251227190405_aECwW AU000C 2025-12-31T15:20:17.065Z 2026-01-04T15:35:00.702Z
9109103 9109103 20251228175446_TkqW6 AU000C 2025-12-31T14:56:57.695Z 2026-01-05T15:14:01.755Z
9108590 9108590 20251229191011_d7j4t AU000C 2025-12-31T14:43:59.313Z 2026-01-06T15:21:39.837Z
9107227 9107227 20251229144153_TQ8Os AU000C 2025-12-31T14:40:08.853Z 2026-01-06T15:20:19.808Z
9107213 9107213 20251229144029_bjSo2 AU000C 2025-12-31T14:40:05.969Z 2026-01-06T15:20:18.882Z
9107186 9107186 20251229142113_Y8OeN AU000C 2025-12-31T14:39:54.959Z 2026-01-06T15:20:16.794Z
9107134 9107134 20251229134526_wYk2Z AU000C 2025-12-31T14:39:42.668Z 2026-01-06T15:20:14.332Z
9107108 9107108 20251229133316_E5q43 AU000C 2025-12-31T14:39:36.142Z 2025-12-31T14:39:36.142Z
9106177 9106177 20251230160841_U63qW AU000C 2025-12-31T14:28:00.573Z 2025-12-31T14:29:55.286Z
9106134 9106134 20251230154538_u3SXn AU000C 2025-12-31T14:27:48.355Z 2026-01-07T15:11:47.848Z
9105949 9105949 20251230143709_hkers AU000C 2025-12-31T14:27:07.679Z 2026-01-07T15:11:26.503Z
9105904 9105904 20251230140637_JKxp3 AU000C 2025-12-31T14:26:53.113Z 2026-01-07T15:11:21.381Z
9105720 9105720 20251230122917_3JrnZ AU000C 2025-12-31T14:26:15.197Z 2026-01-07T15:11:08.041Z
9098538 9098538 20251227192659_2pVU9 AU000C 2025-12-30T15:10:35.323Z 2026-01-04T15:35:07.658Z
9098518 9098518 20251227191950_xTdR2 AU000C 2025-12-30T15:10:34.358Z 2026-01-04T15:35:06.834Z
9098364 9098364 20251227185505_NJl6A AU000C 2025-12-30T15:10:25.092Z 2026-01-04T15:34:58.303Z
9098193 9098193 20251227182431_YAoqP AU000C 2025-12-30T15:09:56.441Z 2026-01-04T15:34:49.142Z
9097883 9097883 20251227174157_dSVOW AU000C 2025-12-30T15:09:23.603Z 2026-01-04T15:34:23.783Z
9097555 9097555 20251227165355_KZro9 AU000C 2025-12-30T15:09:02.368Z 2026-01-04T15:34:01.555Z

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