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,459 rows where station_code = "CA003A" 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
9607311 9607311 20260404072103_JLat5 CA003A 2026-04-05T12:01:32.851Z 2026-04-07T12:14:24.480Z
9603068 9603068 20260402073514_Lz3fe CA003A 2026-04-03T12:01:38.195Z 2026-04-07T12:18:53.524Z
9602842 9602842 20260402033607_99tG9 CA003A 2026-04-03T12:00:53.620Z 2026-04-07T12:18:45.930Z
9590461 9590461 20260328091848_JsZjh CA003A 2026-03-29T12:02:42.418Z 2026-04-06T12:38:10.821Z
9590417 9590417 20260328090327_NvcKM CA003A 2026-03-29T12:02:36.135Z 2026-04-06T12:38:06.894Z
9572261 9572261 20260324082155_hOuND CA003A 2026-03-25T12:04:27.871Z 2026-04-02T12:35:11.384Z
9572256 9572256 20260324082147_k8Mjc CA003A 2026-03-25T12:04:26.640Z 2026-04-02T12:35:11.166Z
9572016 9572016 20260324070211_oeOtK CA003A 2026-03-25T12:03:30.678Z 2026-04-02T12:34:59.412Z
9571951 9571951 20260324062622_9yjc6 CA003A 2026-03-25T12:03:20.210Z 2026-04-02T12:34:56.791Z
9571514 9571514 20260324023944_i3nUI CA003A 2026-03-25T12:01:46.424Z 2026-04-02T12:34:30.118Z
9563955 9563955 20260323094028_oGV3s CA003A 2026-03-24T12:07:04.029Z 2026-03-31T12:26:59.754Z
9563738 9563738 20260323090538_MkPl0 CA003A 2026-03-24T12:06:37.997Z 2026-03-31T12:26:50.067Z
9563523 9563523 20260323082908_HGBTh CA003A 2026-03-24T12:06:09.984Z 2026-03-31T12:26:46.124Z
9563468 9563468 20260323082425_6TZ9y CA003A 2026-03-24T12:06:04.207Z 2026-03-31T12:26:43.870Z
9513337 9513337 20260318085910_O3nKq CA003A 2026-03-19T12:14:58.115Z 2026-03-26T12:37:54.232Z
9512938 9512938 20260318080729_0EgAV CA003A 2026-03-19T12:13:57.411Z 2026-03-26T12:37:50.235Z
9512899 9512899 20260318080248_qHRd7 CA003A 2026-03-19T12:13:51.231Z 2026-03-26T12:37:49.825Z
9512510 9512510 20260318063938_MRCiV CA003A 2026-03-19T12:12:46.311Z 2026-03-26T12:37:46.072Z
9511300 9511300 20260318034521_PH7Ls CA003A 2026-03-19T12:09:54.453Z 2026-03-26T12:37:34.696Z
9510144 9510144 20260318023529_gVfpm CA003A 2026-03-19T12:07:00.303Z 2026-03-26T12:37:10.487Z
9486215 9486215 20260315054917_yRLfS CA003A 2026-03-16T12:09:09.778Z 2026-03-23T12:21:56.017Z
9486045 9486045 20260315043747_3FIst CA003A 2026-03-16T12:08:28.398Z 2026-03-23T12:21:55.095Z
9485809 9485809 20260315035852_NFzgR CA003A 2026-03-16T12:07:44.070Z 2026-03-23T12:21:54.168Z
9451468 9451468 20260310021841_hFyia CA003A 2026-03-11T12:02:52.917Z 2026-03-18T12:38:46.965Z
9432856 9432856 20260306091547_Uvper CA003A 2026-03-07T14:06:25.430Z 2026-03-14T12:39:42.990Z
9432401 9432401 20260306055111_3NK2z CA003A 2026-03-07T14:04:36.689Z 2026-03-14T12:39:29.799Z
9432396 9432396 20260306054905_mjjkP CA003A 2026-03-07T14:04:35.429Z 2026-03-14T12:39:29.710Z
9432390 9432390 20260306054705_6Xod2 CA003A 2026-03-07T14:04:33.891Z 2026-03-14T12:39:29.637Z
9432374 9432374 20260306053102_DH133 CA003A 2026-03-07T14:04:29.480Z 2026-03-14T12:39:29.261Z
9432132 9432132 20260306033823_wtZsz CA003A 2026-03-07T14:03:33.578Z 2026-03-14T12:39:25.583Z
9426739 9426739 20260305043135_ruAQt CA003A 2026-03-06T14:06:10.676Z 2026-03-13T12:34:50.412Z
9423141 9423141 20260304081824_jbR2Z CA003A 2026-03-05T14:03:56.898Z 2026-03-12T12:32:52.516Z
9423056 9423056 20260304071310_WeuWD CA003A 2026-03-05T14:03:39.270Z 2026-03-12T12:32:51.012Z
9423044 9423044 20260304065326_qng49 CA003A 2026-03-05T14:03:35.415Z 2026-03-12T12:32:50.872Z
9416259 9416259 20260302094250_G82sI CA003A 2026-03-03T14:03:13.939Z 2026-03-10T12:36:01.915Z
9416209 9416209 20260302092955_rA1JL CA003A 2026-03-03T14:03:05.565Z 2026-03-10T12:36:00.842Z
9415977 9415977 20260302064955_3W3MT CA003A 2026-03-03T14:02:19.449Z 2026-03-10T12:35:54.961Z
9412072 9412072 20260228235921_g2X9q CA003A 2026-03-02T14:00:25.465Z 2026-03-09T12:39:18.279Z
9390588 9390588 20260225004524_CZyvR CA003A 2026-02-26T14:01:48.460Z 2026-03-05T14:35:50.323Z
9383557 9383557 20260224060142_OYSkE CA003A 2026-02-25T14:02:09.695Z 2026-03-04T14:17:51.263Z
9383427 9383427 20260224042429_ru3Ft CA003A 2026-02-25T14:01:30.803Z 2026-03-04T14:17:48.733Z
9374723 9374723 20260223093059_7HnaZ CA003A 2026-02-24T14:06:50.711Z 2026-03-03T14:31:34.995Z
9364855 9364855 20260222005439_ljiKX CA003A 2026-02-23T14:01:02.152Z 2026-02-24T14:14:38.023Z
9353243 9353243 20260220102458_izB3M CA003A 2026-02-21T14:04:04.102Z 2026-03-01T14:21:48.050Z
9352721 9352721 20260220090320_Ws5uX CA003A 2026-02-21T14:02:50.288Z 2026-03-01T14:21:41.690Z
9352655 9352655 20260220085049_NRH0n CA003A 2026-02-21T14:02:39.078Z 2026-03-01T14:21:41.048Z
9352576 9352576 20260220083032_qWEwn CA003A 2026-02-21T14:02:26.262Z 2026-03-01T14:21:39.918Z
9352528 9352528 20260220075946_HDf2y CA003A 2026-02-21T14:02:15.892Z 2026-03-01T14:21:39.216Z
9352518 9352518 20260220075136_V2i20 CA003A 2026-02-21T14:02:12.230Z 2026-03-01T14:21:39.054Z
9352455 9352455 20260220071714_2wR2u CA003A 2026-02-21T14:01:59.651Z 2026-03-01T14:21:38.053Z
9352444 9352444 20260220070740_sbbJL CA003A 2026-02-21T14:01:57.564Z 2026-03-01T14:21:37.917Z
9352422 9352422 20260220063550_9DuaD CA003A 2026-02-21T14:01:51.662Z 2026-03-01T14:21:37.581Z
9352375 9352375 20260220055015_JUIRR CA003A 2026-02-21T14:01:41.789Z 2026-03-01T14:21:36.622Z
9352305 9352305 20260220045521_FgjBH CA003A 2026-02-21T14:01:27.898Z 2026-03-01T14:21:35.690Z
9345528 9345528 20260218100316_Oew5p CA003A 2026-02-20T14:01:33.101Z 2026-02-27T14:34:38.765Z
9345413 9345413 20260218094452_lKYiF CA003A 2026-02-20T14:01:29.936Z 2026-02-27T14:34:37.797Z
9344998 9344998 20260218073759_suwMF CA003A 2026-02-20T14:01:22.671Z 2026-02-27T14:34:32.423Z
9341566 9341566 20260219094029_sEvho CA003A 2026-02-20T14:00:56.997Z 2026-02-28T14:43:52.058Z
9341480 9341480 20260219091356_opMT8 CA003A 2026-02-20T14:00:56.787Z 2026-02-28T14:43:51.455Z
9331761 9331761 20260216080635_gkIBa CA003A 2026-02-17T14:08:16.230Z 2026-02-25T14:42:01.732Z
9328413 9328413 20260215110305_F3ATj CA003A 2026-02-16T14:08:32.767Z 2026-02-24T14:42:24.143Z
9328267 9328267 20260215103637_9kiF0 CA003A 2026-02-16T14:08:02.996Z 2026-02-24T14:42:22.126Z
9328091 9328091 20260215100248_yjxVl CA003A 2026-02-16T14:07:18.060Z 2026-02-24T14:42:06.690Z
9327726 9327726 20260215082248_tnaJD CA003A 2026-02-16T14:05:43.630Z 2026-02-24T14:42:00.385Z
9327649 9327649 20260215075415_RMsk0 CA003A 2026-02-16T14:05:23.436Z 2026-02-24T14:41:59.003Z
9327642 9327642 20260215074842_boXFA CA003A 2026-02-16T14:05:20.755Z 2026-02-24T14:41:58.912Z
9327518 9327518 20260215062701_iP6nh CA003A 2026-02-16T14:04:48.615Z 2026-02-24T14:41:56.239Z
9327156 9327156 20260215042105_NG568 CA003A 2026-02-16T14:02:49.278Z 2026-02-24T14:41:48.437Z
9327019 9327019 20260215032841_tIeKc CA003A 2026-02-16T14:02:02.902Z 2026-02-24T14:41:40.241Z
9326912 9326912 20260215025853_4eO2i CA003A 2026-02-16T14:01:28.289Z 2026-02-24T14:41:38.283Z
9326777 9326777 20260215020955_2lF78 CA003A 2026-02-16T14:00:35.118Z 2026-02-24T14:41:33.262Z
9320437 9320437 20260213101223_kNiqz CA003A 2026-02-14T14:06:38.900Z 2026-02-22T14:42:03.718Z
9320368 9320368 20260213095142_Fj6ZR CA003A 2026-02-14T14:06:16.170Z 2026-02-22T14:41:54.036Z
9320280 9320280 20260213091805_8qkcV CA003A 2026-02-14T14:05:45.182Z 2026-02-22T14:41:52.187Z
9320270 9320270 20260213091224_AWnHT CA003A 2026-02-14T14:05:43.056Z 2026-02-22T14:41:52.072Z
9320259 9320259 20260213090751_6B8Dw CA003A 2026-02-14T14:05:38.836Z 2026-02-22T14:41:51.753Z
9320246 9320246 20260213090006_7LhKl CA003A 2026-02-14T14:05:33.534Z 2026-02-22T14:41:51.430Z
9320200 9320200 20260213083225_snQzh CA003A 2026-02-14T14:05:15.521Z 2026-02-22T14:41:50.360Z
9320166 9320166 20260213080011_UnSEU CA003A 2026-02-14T14:04:58.835Z 2026-02-22T14:41:49.521Z
9319785 9319785 20260213042607_38ZRM CA003A 2026-02-14T14:02:27.503Z 2026-02-22T14:41:39.149Z
9317048 9317048 20260212063258_P2bxK CA003A 2026-02-13T14:02:24.751Z 2026-02-21T14:36:49.336Z
9312080 9312080 20260210070944_je32q CA003A 2026-02-11T14:03:34.651Z 2026-02-18T14:55:54.479Z
9311631 9311631 20260209022420_sRrK4 CA003A 2026-02-10T14:24:41.922Z 2026-02-16T14:55:01.047Z
9311571 9311571 20260209013821_6yg9u CA003A 2026-02-10T14:24:26.030Z 2026-02-16T14:54:56.658Z
9311524 9311524 20260209000735_GWgKj CA003A 2026-02-10T14:24:12.753Z 2026-02-16T14:54:52.990Z
9307841 9307841 20260209080022_HPa1A CA003A 2026-02-10T14:04:31.570Z 2026-02-18T14:59:08.116Z
9307412 9307412 20260209053436_yUXS2 CA003A 2026-02-10T14:02:08.850Z 2026-02-18T14:58:28.333Z
9307278 9307278 20260209043416_AonHe CA003A 2026-02-10T14:01:19.043Z 2026-02-18T14:58:17.484Z
9306903 9306903 20260208022910_ZSyiV CA003A 2026-02-09T14:25:34.444Z 2026-02-16T15:01:07.477Z
9298304 9298304 20260206011350_cXxQi CA003A 2026-02-07T14:22:40.240Z 2026-02-14T15:06:17.603Z
9298273 9298273 20260206001531_XZ92x CA003A 2026-02-07T14:22:31.206Z 2026-02-14T15:06:15.321Z
9298267 9298267 20260206001352_GS2Q5 CA003A 2026-02-07T14:22:30.105Z 2026-02-14T15:06:14.853Z
9298244 9298244 20260205234530_o35EJ CA003A 2026-02-07T14:22:17.856Z 2026-02-14T15:06:11.688Z
9294743 9294743 20260205032734_mVfl2 CA003A 2026-02-06T14:20:59.817Z 2026-02-13T14:58:03.031Z
9294736 9294736 20260205032148_6BOE2 CA003A 2026-02-06T14:20:58.219Z 2026-02-13T14:58:02.440Z
9292823 9292823 20260205110432_PzzLu CA003A 2026-02-06T14:06:54.841Z 2026-02-14T15:03:33.294Z
9292365 9292365 20260205093409_HwkJf CA003A 2026-02-06T14:04:30.320Z 2026-02-14T15:02:49.538Z
9292101 9292101 20260205085356_ikOe3 CA003A 2026-02-06T14:03:12.544Z 2026-02-14T15:02:27.893Z
9291961 9291961 20260205082523_m0oCg CA003A 2026-02-06T14:02:31.548Z 2026-02-14T15:02:15.726Z
9291931 9291931 20260205081139_I3jdQ CA003A 2026-02-06T14:02:17.367Z 2026-02-14T15:02:12.717Z

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