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,015 rows where station_code = "AU001Z" 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
9225853 9225853 20260116151057_NSmu8 AU001Z 2026-01-19T14:33:37.197Z 2026-01-25T14:57:17.041Z
9225838 9225838 20260116141519_Vsv3Y AU001Z 2026-01-19T14:33:12.846Z 2026-01-25T14:57:12.540Z
9212312 9212312 20260115202721_OG3vn AU001Z 2026-01-17T14:11:11.341Z 2026-01-24T15:10:47.083Z
9212251 9212251 20260115200846_KlYYn AU001Z 2026-01-17T14:10:51.212Z 2026-01-24T15:10:44.547Z
9212218 9212218 20260115195936_P95fZ AU001Z 2026-01-17T14:10:40.992Z 2026-01-24T15:10:32.527Z
9211934 9211934 20260115182601_oW9IP AU001Z 2026-01-17T14:09:06.666Z 2026-01-24T15:10:12.092Z
9211450 9211450 20260115154252_HQyf3 AU001Z 2026-01-17T14:06:41.094Z 2026-01-24T15:09:15.185Z
9211416 9211416 20260115152850_HzEtE AU001Z 2026-01-17T14:06:32.944Z 2026-01-24T15:09:13.153Z
9211177 9211177 20260115131351_zldLp AU001Z 2026-01-17T14:05:19.356Z 2026-01-24T15:08:44.879Z
9206727 9206727 20260114183832_4prTz AU001Z 2026-01-16T14:05:19.206Z 2026-01-22T15:02:34.818Z
9206452 9206452 20260114165255_nksI6 AU001Z 2026-01-16T14:03:58.024Z 2026-01-22T15:02:26.189Z
9206150 9206150 20260114134633_YeWTm AU001Z 2026-01-16T14:02:23.877Z 2026-01-22T15:01:50.939Z
9206126 9206126 20260114133055_H6JiM AU001Z 2026-01-16T14:02:14.369Z 2026-01-22T15:01:49.796Z
9199535 9199535 20260113201609_zEZju AU001Z 2026-01-15T14:11:22.605Z 2026-01-22T15:07:26.240Z
9199206 9199206 20260113192242_I2MDC AU001Z 2026-01-15T14:09:46.921Z 2026-01-22T15:07:16.815Z
9198838 9198838 20260113181438_285Ym AU001Z 2026-01-15T14:07:34.658Z 2026-01-22T15:07:06.166Z
9198608 9198608 20260113171512_AXokz AU001Z 2026-01-15T14:05:51.057Z 2026-01-22T15:06:51.149Z
9198572 9198572 20260113171011_SSvA9 AU001Z 2026-01-15T14:05:35.861Z 2026-01-22T15:06:36.029Z
9198415 9198415 20260113161614_qnyFh AU001Z 2026-01-15T14:04:10.419Z 2026-01-22T15:06:26.769Z
9198342 9198342 20260113154520_kunQi AU001Z 2026-01-15T14:03:25.310Z 2026-01-22T15:06:23.399Z
9198116 9198116 20260113132850_e0NwC AU001Z 2026-01-15T14:00:57.328Z 2026-01-22T15:06:13.204Z
9194172 9194172 20260112183926_OyeOx AU001Z 2026-01-14T14:07:45.363Z 2026-01-21T15:03:37.800Z
9180318 9180318 20260110195649_OD7Wx AU001Z 2026-01-12T14:06:40.529Z 2026-01-19T15:15:56.192Z
9180298 9180298 20260110195333_snweh AU001Z 2026-01-12T14:06:36.652Z 2026-01-19T15:15:55.376Z
9180192 9180192 20260110193251_vED0v AU001Z 2026-01-12T14:06:09.104Z 2026-01-19T15:15:50.628Z
9180187 9180187 20260110193235_OJ7NW AU001Z 2026-01-12T14:06:07.975Z 2026-01-19T15:15:50.424Z
9179900 9179900 20260110180645_6glD7 AU001Z 2026-01-12T14:04:50.389Z 2026-01-19T15:15:22.437Z
9179545 9179545 20260110163052_8GQnO AU001Z 2026-01-12T14:03:11.174Z 2026-01-19T15:15:04.176Z
9179525 9179525 20260110161816_1IB6B AU001Z 2026-01-12T14:03:04.025Z 2026-01-19T15:15:02.895Z
9179356 9179356 20260110145345_J2Hg2 AU001Z 2026-01-12T14:01:29.823Z 2026-01-19T15:14:13.626Z
9174379 9174379 20260109161938_ZVGe3 AU001Z 2026-01-11T14:02:50.350Z 2026-01-18T15:06:40.767Z
9174373 9174373 20260109155943_jRNkK AU001Z 2026-01-11T14:02:44.753Z 2026-01-18T15:06:39.136Z
9170329 9170329 20260107151645_pYNgk AU001Z 2026-01-09T14:20:30.910Z 2026-01-13T15:05:33.687Z
9170274 9170274 20260107131629_O7UlL AU001Z 2026-01-09T14:19:32.877Z 2026-01-13T15:04:37.441Z
9170262 9170262 20260107125549_KWTSg AU001Z 2026-01-09T14:19:22.328Z 2026-01-13T15:04:30.278Z
9166499 9166499 20260107185038_o6l6b AU001Z 2026-01-09T14:03:29.596Z 2026-01-16T15:09:58.150Z
9166221 9166221 20260107172213_i0XC5 AU001Z 2026-01-09T14:02:12.037Z 2026-01-16T15:09:32.414Z
9166140 9166140 20260107164629_7aLK9 AU001Z 2026-01-09T14:01:44.276Z 2026-01-16T15:09:26.301Z
9166122 9166122 20260107164200_3tYhS AU001Z 2026-01-09T14:01:39.898Z 2026-01-16T15:09:25.352Z
9161802 9161802 20260105140601_MdaUu AU001Z 2026-01-07T14:24:38.488Z 2026-01-13T15:16:33.816Z
9161584 9161584 20260106143700_h0fIL AU001Z 2026-01-07T14:17:14.769Z 2026-01-13T15:10:58.295Z
9126265 9126265 20260101184931_oyocZ AU001Z 2026-01-03T14:01:48.332Z 2026-01-09T14:48:09.313Z
9125932 9125932 20251230163138_j28nV AU001Z 2026-01-02T15:05:32.840Z 2026-01-07T15:12:06.664Z
9125860 9125860 20251231190419_qimMy AU001Z 2026-01-02T14:56:16.622Z 2026-01-08T15:16:11.466Z
9125849 9125849 20251231190306_y3Z13 AU001Z 2026-01-02T14:56:15.415Z 2026-01-08T15:16:10.993Z
9125791 9125791 20251231185132_TwOnx AU001Z 2026-01-02T14:56:05.499Z 2026-01-08T15:16:07.799Z
9125709 9125709 20251231183631_0Rn43 AU001Z 2026-01-02T14:55:56.987Z 2026-01-08T15:15:55.327Z
9125694 9125694 20251231183131_4FCCw AU001Z 2026-01-02T14:55:54.586Z 2026-01-08T15:15:54.203Z
9125301 9125301 20251231172749_2zBFl AU001Z 2026-01-02T14:54:51.672Z 2026-01-08T15:15:24.359Z
9120354 9120354 20260101195008_x5rhp AU001Z 2026-01-02T14:01:41.895Z 2026-01-09T14:48:23.013Z
9120266 9120266 20260101191307_Bu06l AU001Z 2026-01-02T14:00:59.316Z 2026-01-09T14:48:14.030Z
9120249 9120249 20260101190542_jilSX AU001Z 2026-01-02T14:00:49.853Z 2026-01-09T14:48:12.428Z
9120191 9120191 20260101184758_CWxaG AU001Z 2026-01-02T14:00:19.197Z 2026-01-09T14:48:08.354Z
9119521 9119521 20251230181153_YX18B AU001Z 2026-01-01T14:56:21.866Z 2026-01-07T15:12:49.885Z
9119390 9119390 20251230174552_NZnv6 AU001Z 2026-01-01T14:56:01.379Z 2026-01-07T15:12:30.722Z
9119214 9119214 20251230165857_a0y59 AU001Z 2026-01-01T14:55:20.143Z 2026-01-07T15:12:13.875Z
9119118 9119118 20251230162942_2WNXk AU001Z 2026-01-01T14:54:53.436Z 2026-01-07T15:12:05.975Z
9119097 9119097 20251230162224_Uvr3e AU001Z 2026-01-01T14:54:49.633Z 2026-01-07T15:12:03.340Z
9109658 9109658 20251230201305_f5JtB AU001Z 2026-01-01T14:02:27.604Z 2026-01-08T15:04:17.569Z
9109478 9109478 20251230194158_9Xrzb AU001Z 2026-01-01T14:00:55.066Z 2026-01-08T15:03:53.088Z
9109261 9109261 20251227171816_4lS5k AU001Z 2025-12-31T15:18:55.242Z 2026-01-04T15:34:17.439Z
9109032 9109032 20251228155236_0QpCt AU001Z 2025-12-31T14:56:06.881Z 2026-01-05T15:13:31.641Z
9108927 9108927 20251229195418_e4g2k AU001Z 2025-12-31T14:44:51.415Z 2026-01-06T15:22:06.936Z
9108680 9108680 20251229192157_H50KQ AU001Z 2025-12-31T14:44:10.899Z 2026-01-06T15:21:43.949Z
9108435 9108435 20251229184926_AGqtz AU001Z 2025-12-31T14:43:32.490Z 2026-01-06T15:21:34.935Z
9108089 9108089 20251229175653_L277k AU001Z 2025-12-31T14:42:50.175Z 2025-12-31T14:42:50.175Z
9107993 9107993 20251229174224_Zegs2 AU001Z 2025-12-31T14:42:28.091Z 2026-01-06T15:21:20.668Z
9107642 9107642 20251229164147_xYT7B AU001Z 2025-12-31T14:41:35.433Z 2026-01-06T15:20:55.014Z
9107524 9107524 20251229161546_90z5Q AU001Z 2025-12-31T14:41:11.428Z 2026-01-06T15:20:50.071Z
9107509 9107509 20251229161125_Xml1C AU001Z 2025-12-31T14:41:08.585Z 2026-01-06T15:20:49.134Z
9107249 9107249 20251229145033_CHfrz AU001Z 2025-12-31T14:40:12.699Z 2026-01-06T15:20:21.146Z
9100422 9100422 20251229195943_Xf2A5 AU001Z 2025-12-31T14:02:40.557Z 2026-01-07T15:05:15.910Z
9099800 9099800 20251225185838_3vwcH AU001Z 2025-12-30T15:36:06.762Z 2026-01-02T15:48:04.774Z
9098719 9098719 20251227195747_bp3xo AU001Z 2025-12-30T15:10:47.638Z 2026-01-04T15:35:24.554Z
9098610 9098610 20251227193844_VKM9H AU001Z 2025-12-30T15:10:39.653Z 2025-12-30T15:10:39.653Z
9098415 9098415 20251227190324_B7k7j AU001Z 2025-12-30T15:10:28.664Z 2026-01-04T15:35:00.452Z
9098163 9098163 20251227182112_YAJye AU001Z 2025-12-30T15:09:54.940Z 2025-12-30T15:09:54.940Z
9098107 9098107 20251227181205_CMwms AU001Z 2025-12-30T15:09:52.364Z 2026-01-04T15:34:33.779Z
9097980 9097980 20251227175335_QpnP0 AU001Z 2025-12-30T15:09:44.734Z 2026-01-04T15:34:28.181Z
9097677 9097677 20251227171816_eDPbs AU001Z 2025-12-30T15:09:11.819Z 2026-01-04T15:34:17.514Z
9097423 9097423 20251227162515_01CVg AU001Z 2025-12-30T15:08:39.966Z 2026-01-04T15:33:53.949Z
9097381 9097381 20251227161606_6rzJt AU001Z 2025-12-30T15:08:37.050Z 2026-01-04T15:33:52.081Z
9096284 9096284 20251227144053_P0m2w AU001Z 2025-12-30T15:07:21.836Z 2025-12-30T15:07:21.836Z
9091511 9091511 20251228191343_mC4ZQ AU001Z 2025-12-30T14:52:46.878Z 2026-01-05T15:14:15.703Z
9091151 9091151 20251228180354_2MdR6 AU001Z 2025-12-30T14:52:00.540Z 2026-01-05T15:14:03.423Z
9090965 9090965 20251228172924_ruiRn AU001Z 2025-12-30T14:51:31.565Z 2026-01-05T15:13:46.077Z
9090648 9090648 20251228160421_sSnnD AU001Z 2025-12-30T14:50:48.872Z 2026-01-05T15:13:32.728Z
9090256 9090256 20251228144932_07opL AU001Z 2025-12-30T14:49:55.736Z 2026-01-05T15:13:04.774Z
9075885 9075885 20251222195020_YhNmf AU001Z 2025-12-29T15:21:34.194Z 2025-12-30T15:49:13.222Z
9075752 9075752 20251223165510_onT32 AU001Z 2025-12-29T15:12:02.699Z 2025-12-31T15:43:36.540Z
9074025 9074025 20251225190243_O97FO AU001Z 2025-12-29T15:00:02.574Z 2026-01-02T15:48:05.374Z
9073999 9073999 20251225185837_M8Z2k AU001Z 2025-12-29T15:00:01.619Z 2026-01-02T15:48:04.447Z
9073256 9073256 20251225171727_U2262 AU001Z 2025-12-29T14:59:08.766Z 2026-01-02T15:47:47.894Z
9071531 9071531 20251226185147_FDmy8 AU001Z 2025-12-29T14:49:34.469Z 2026-01-03T15:42:58.768Z
9071469 9071469 20251226184123_ThDqj AU001Z 2025-12-29T14:49:30.533Z 2025-12-30T15:22:39.382Z
9071037 9071037 20251226174300_jrOFb AU001Z 2025-12-29T14:48:49.821Z 2026-01-03T15:42:26.220Z
9070943 9070943 20251226173304_P3kP7 AU001Z 2025-12-29T14:48:44.267Z 2025-12-30T15:22:26.916Z
9070487 9070487 20251226162715_XNFWm AU001Z 2025-12-29T14:47:44.651Z 2026-01-03T15:41:49.143Z
9070452 9070452 20251226161914_tfarw AU001Z 2025-12-29T14:47:42.208Z 2026-01-03T15:41:47.911Z
9070319 9070319 20251226155110_1sCiV AU001Z 2025-12-29T14:47:32.662Z 2026-01-03T15:41:42.007Z

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