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

7,732 rows where station_code = "AU000Z" 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
9271703 9271703 20260127192240_Ugl7c AU000Z 2026-01-29T14:22:38.627Z 2026-01-29T14:30:25.031Z
9271405 9271405 20260127151413_Y0Ynh AU000Z 2026-01-29T14:19:40.239Z 2026-01-29T14:30:24.546Z
9267173 9267173 20260126201343_2I5Uf AU000Z 2026-01-28T14:20:00.254Z 2026-01-29T14:34:28.232Z
9267114 9267114 20260126192515_mcFQd AU000Z 2026-01-28T14:19:20.905Z 2026-01-29T14:34:19.392Z
9267040 9267040 20260126182344_fcGWy AU000Z 2026-01-28T14:18:36.998Z 2026-01-29T14:34:01.215Z
9266913 9266913 20260126162000_rBCxd AU000Z 2026-01-28T14:17:30.897Z 2026-01-29T14:33:43.163Z
9258765 9258765 20260124165218_F71vn AU000Z 2026-01-26T14:14:20.045Z 2026-01-29T14:42:07.805Z
9258602 9258602 20260124150511_T3tLo AU000Z 2026-01-26T14:13:17.074Z 2026-01-29T14:41:40.147Z
9254609 9254609 20260123202245_LERZs AU000Z 2026-01-25T14:10:02.683Z 2026-01-29T14:46:32.240Z
9254483 9254483 20260123193652_AzdXL AU000Z 2026-01-25T14:09:26.256Z 2026-01-29T14:46:26.073Z
9254356 9254356 20260123183453_97zYB AU000Z 2026-01-25T14:08:41.915Z 2026-01-29T14:46:11.527Z
9254305 9254305 20260123180232_5hrJo AU000Z 2026-01-25T14:08:25.232Z 2026-01-29T14:46:05.138Z
9254199 9254199 20260123164537_Rsinn AU000Z 2026-01-25T14:07:46.040Z 2026-01-29T14:45:57.388Z
9254069 9254069 20260123142626_B3FN6 AU000Z 2026-01-25T14:06:47.281Z 2026-01-29T14:45:31.642Z
9246887 9246887 20260121152111_wLken AU000Z 2026-01-23T14:08:17.369Z 2026-01-29T14:55:18.514Z
9241197 9241197 20260120192323_VcKl8 AU000Z 2026-01-22T14:12:06.525Z 2026-01-29T15:02:26.321Z
9240569 9240569 20260120164846_GLZsh AU000Z 2026-01-22T14:09:02.734Z 2026-01-29T15:01:30.963Z
9240279 9240279 20260120145346_82jX1 AU000Z 2026-01-22T14:07:32.956Z 2026-01-29T15:01:01.963Z
9234145 9234145 20260119194811_PSUcP AU000Z 2026-01-21T14:12:32.979Z 2026-01-28T14:57:17.486Z
9233983 9233983 20260119190809_aYLCc AU000Z 2026-01-21T14:11:41.470Z 2026-01-28T14:56:57.247Z
9233639 9233639 20260119155611_432DI AU000Z 2026-01-21T14:09:24.804Z 2026-01-28T14:56:16.752Z
9233613 9233613 20260119152830_yYfOi AU000Z 2026-01-21T14:09:09.073Z 2026-01-28T14:56:05.708Z
9233572 9233572 20260119143608_ZjGqk AU000Z 2026-01-21T14:08:25.568Z 2026-01-28T14:55:51.374Z
9227658 9227658 20260118154550_SficF AU000Z 2026-01-20T14:12:47.215Z 2026-01-27T15:00:27.756Z
9222589 9222589 20260117200250_m84uH AU000Z 2026-01-19T14:15:25.607Z 2026-01-26T15:01:14.458Z
9221763 9221763 20260117155406_moxqu AU000Z 2026-01-19T14:11:35.690Z 2026-01-26T15:00:04.135Z
9216238 9216238 20260115192401_B819u AU000Z 2026-01-17T14:28:43.837Z 2026-01-24T15:10:26.011Z
9216177 9216177 20260115152046_MYa4b AU000Z 2026-01-17T14:28:14.060Z 2026-01-24T15:09:12.230Z
9211619 9211619 20260115165858_oOc5y AU000Z 2026-01-17T14:07:32.279Z 2026-01-24T15:09:40.972Z
9211482 9211482 20260115160258_uTf64 AU000Z 2026-01-17T14:06:53.229Z 2026-01-24T15:09:17.774Z
9211406 9211406 20260115152204_aKWvb AU000Z 2026-01-17T14:06:29.973Z 2026-01-24T15:09:12.492Z
9211239 9211239 20260115135900_UrgN6 AU000Z 2026-01-17T14:05:43.865Z 2026-01-24T15:08:55.235Z
9206906 9206906 20260114194207_r32ze AU000Z 2026-01-16T14:06:07.311Z 2026-01-22T15:02:42.981Z
9206725 9206725 20260114183832_buwFx AU000Z 2026-01-16T14:05:18.617Z 2026-01-22T15:02:34.709Z
9206566 9206566 20260114174437_RqCgE AU000Z 2026-01-16T14:04:30.159Z 2026-01-22T15:02:30.166Z
9206277 9206277 20260114152040_QGqpK AU000Z 2026-01-16T14:03:03.822Z 2026-01-22T15:01:57.588Z
9206162 9206162 20260114135427_RelCR AU000Z 2026-01-16T14:02:27.561Z 2026-01-22T15:01:51.377Z
9199204 9199204 20260113192241_fmTm8 AU000Z 2026-01-15T14:09:46.106Z 2026-01-22T15:07:16.782Z
9199084 9199084 20260113190102_Y3cER AU000Z 2026-01-15T14:09:10.032Z 2026-01-22T15:07:13.610Z
9198471 9198471 20260113163815_AAgpA AU000Z 2026-01-15T14:04:38.451Z 2026-01-22T15:06:30.939Z
9198310 9198310 20260113153257_aEEcC AU000Z 2026-01-15T14:03:11.780Z 2026-01-22T15:06:22.113Z
9198144 9198144 20260113135509_oFbem AU000Z 2026-01-15T14:01:26.069Z 2026-01-22T15:06:14.872Z
9194299 9194299 20260112194131_2nUZE AU000Z 2026-01-14T14:08:34.208Z 2026-01-21T15:03:47.658Z
9180367 9180367 20260110201117_lbfRD AU000Z 2026-01-12T14:06:53.923Z 2026-01-19T15:15:59.598Z
9180269 9180269 20260110194949_lD80z AU000Z 2026-01-12T14:06:30.768Z 2026-01-19T15:15:54.327Z
9179829 9179829 20260110174813_t3B1I AU000Z 2026-01-12T14:04:30.377Z 2026-01-19T15:15:19.283Z
9179574 9179574 20260110164826_3YWx2 AU000Z 2026-01-12T14:03:21.050Z 2026-01-19T15:15:05.971Z
9179461 9179461 20260110154928_g3Cb4 AU000Z 2026-01-12T14:02:32.333Z 2026-01-19T15:14:40.418Z
9179340 9179340 20260110144437_JlYT4 AU000Z 2026-01-12T14:01:16.963Z 2026-01-19T15:14:09.058Z
9171133 9171133 20260108192738_pJ9mY AU000Z 2026-01-10T14:05:28.938Z 2026-01-17T15:23:25.444Z
9166465 9166465 20260107183933_34iPd AU000Z 2026-01-09T14:03:21.605Z 2026-01-16T15:09:56.304Z
9166428 9166428 20260107182812_TH19X AU000Z 2026-01-09T14:03:12.437Z 2026-01-16T15:09:54.266Z
9166246 9166246 20260107173122_iGcW3 AU000Z 2026-01-09T14:02:19.764Z 2026-01-16T15:09:34.170Z
9166085 9166085 20260107160853_CEoQm AU000Z 2026-01-09T14:01:21.180Z 2026-01-16T15:09:21.459Z
9165825 9165825 20260106134502_skr3H AU000Z 2026-01-08T14:24:54.055Z 2026-01-13T15:10:51.617Z
9165705 9165705 20260107145719_QdaTj AU000Z 2026-01-08T14:17:43.846Z 2026-01-13T15:05:26.315Z
9161768 9161768 20260105132213_WBt0H AU000Z 2026-01-07T14:24:22.807Z 2026-01-13T15:16:28.251Z
9161565 9161565 20260106142955_O97Lg AU000Z 2026-01-07T14:17:08.202Z 2026-01-13T15:10:56.899Z
9161557 9161557 20260106142103_7RhSU AU000Z 2026-01-07T14:17:03.972Z 2026-01-13T15:10:56.049Z
9157188 9157188 20260104162021_D019j AU000Z 2026-01-06T14:41:59.546Z 2026-01-12T15:13:04.638Z
9156905 9156905 20260104140225_7bFgd AU000Z 2026-01-06T14:41:12.218Z 2026-01-12T15:12:42.479Z
9133733 9133733 20260103150019_2Gx9t AU000Z 2026-01-04T14:22:31.707Z 2026-01-10T15:03:37.481Z
9126091 9126091 20251230190403_xJQHM AU000Z 2026-01-02T15:08:45.441Z 2026-01-07T15:13:20.880Z
9125832 9125832 20251231190028_2jYOf AU000Z 2026-01-02T14:56:14.167Z 2026-01-08T15:16:10.313Z
9125336 9125336 20251231173855_JSyV2 AU000Z 2026-01-02T14:54:55.978Z 2026-01-08T15:15:26.248Z
9124770 9124770 20251231142642_iDQ1n AU000Z 2026-01-02T14:52:23.156Z 2026-01-08T15:14:20.135Z
9120873 9120873 20251231195309_96jAs AU000Z 2026-01-02T14:04:40.632Z 2026-01-09T14:51:28.532Z
9120388 9120388 20260101200811_sMD2p AU000Z 2026-01-02T14:02:00.946Z 2026-01-02T14:02:00.946Z
9120380 9120380 20260101200636_6R6It AU000Z 2026-01-02T14:01:57.855Z 2026-01-09T14:48:25.643Z
9120344 9120344 20260101194555_rlRfB AU000Z 2026-01-02T14:01:39.313Z 2026-01-09T14:48:21.717Z
9120341 9120341 20260101194347_iVdzS AU000Z 2026-01-02T14:01:38.425Z 2026-01-02T14:01:38.425Z
9120316 9120316 20260101193327_WrY9s AU000Z 2026-01-02T14:01:26.513Z 2026-01-09T14:48:19.052Z
9120275 9120275 20260101191837_k8L7P AU000Z 2026-01-02T14:01:05.027Z 2026-01-09T14:48:15.259Z
9120016 9120016 20251229190353_LBtwm AU000Z 2026-01-01T15:19:07.664Z 2026-01-06T15:21:38.090Z
9119816 9119816 20251230190403_0cqJD AU000Z 2026-01-01T14:57:21.549Z 2026-01-07T15:13:20.759Z
9119760 9119760 20251230185310_WesMQ AU000Z 2026-01-01T14:57:14.245Z 2026-01-07T15:13:16.093Z
9119245 9119245 20251230171220_luMvo AU000Z 2026-01-01T14:55:27.530Z 2026-01-01T14:58:01.615Z
9119154 9119154 20251230163951_AEnbV AU000Z 2026-01-01T14:54:59.250Z 2026-01-07T15:12:08.159Z
9118829 9118829 20251230131650_pQgmw AU000Z 2026-01-01T14:53:35.475Z 2026-01-07T15:11:15.548Z
9118809 9118809 20251230125833_bUPpf AU000Z 2026-01-01T14:53:21.534Z 2026-01-07T15:11:12.303Z
9118799 9118799 20251230123846_V50no AU000Z 2026-01-01T14:53:16.452Z 2026-01-07T15:11:09.838Z
9109510 9109510 20251230194702_bcuW1 AU000Z 2026-01-01T14:01:10.420Z 2026-01-08T15:03:55.462Z
9108384 9108384 20251229183904_0EWYB AU000Z 2025-12-31T14:43:27.506Z 2026-01-06T15:21:33.363Z
9107724 9107724 20251229170216_W28Rj AU000Z 2025-12-31T14:41:46.176Z 2026-01-06T15:20:58.191Z
9107620 9107620 20251229163932_fqCDs AU000Z 2025-12-31T14:41:28.273Z 2026-01-06T15:20:54.427Z
9107615 9107615 20251229163839_Y3ehd AU000Z 2025-12-31T14:41:27.370Z 2026-01-06T15:20:54.170Z
9107425 9107425 20251229154944_dUXGy AU000Z 2025-12-31T14:40:51.345Z 2026-01-06T15:20:46.091Z
9107382 9107382 20251229154030_CY8kF AU000Z 2025-12-31T14:40:44.774Z 2026-01-06T15:20:44.085Z
9107379 9107379 20251229154017_zZBE8 AU000Z 2025-12-31T14:40:44.500Z 2026-01-06T15:20:43.951Z
9100421 9100421 20251229195943_Xf2A5 AU000Z 2025-12-31T14:02:40.530Z 2026-01-07T15:05:15.910Z
9099079 9099079 20251226152502_wkQk2 AU000Z 2025-12-30T15:21:47.097Z 2026-01-03T15:41:35.265Z
9099060 9099060 20251226140850_cxf0X AU000Z 2025-12-30T15:21:35.919Z 2025-12-30T15:21:35.919Z
9098802 9098802 20251227200417_7u8Y4 AU000Z 2025-12-30T15:11:08.754Z 2026-01-04T15:35:27.640Z
9098608 9098608 20251227193844_VKM9H AU000Z 2025-12-30T15:10:39.653Z 2025-12-30T15:10:39.653Z
9098413 9098413 20251227190324_B7k7j AU000Z 2025-12-30T15:10:28.664Z 2026-01-04T15:35:00.452Z
9098114 9098114 20251227181254_TF9b0 AU000Z 2025-12-30T15:09:52.650Z 2026-01-04T15:34:33.979Z
9097958 9097958 20251227175152_3i2kE AU000Z 2025-12-30T15:09:43.157Z 2026-01-04T15:34:27.307Z
9097727 9097727 20251227172613_bZnj1 AU000Z 2025-12-30T15:09:14.745Z 2026-01-04T15:34:19.445Z
9097673 9097673 20251227171757_s1Ffq AU000Z 2025-12-30T15:09:11.681Z 2025-12-30T15:09:11.681Z
9097620 9097620 20251227170519_F3CCZ AU000Z 2025-12-30T15:09:08.217Z 2026-01-04T15:34:15.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