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

3,166 rows where station_code = "CA002J" 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
8617905 8617905 20251127105103_nDUD3 CA002J 2025-11-28T14:02:46.386Z 2025-12-05T14:54:06.280Z
8582591 8582591 20251123071119_a6d98 CA002J 2025-11-24T14:34:17.638Z 2025-12-01T15:22:25.627Z
8582554 8582554 20251123070248_sQqG8 CA002J 2025-11-24T14:34:03.175Z 2025-12-01T15:22:25.191Z
8582424 8582424 20251123061203_2PPxh CA002J 2025-11-24T14:33:36.347Z 2025-12-01T15:22:23.658Z
8582416 8582416 20251123060742_il2aj CA002J 2025-11-24T14:33:35.824Z 2025-12-01T15:22:23.481Z
8582398 8582398 20251123060245_Gdgws CA002J 2025-11-24T14:33:33.589Z 2025-12-01T15:22:23.210Z
8582269 8582269 20251123050844_7kJc3 CA002J 2025-11-24T14:33:26.760Z 2025-12-01T15:22:20.865Z
8582253 8582253 20251123050123_l2EMG CA002J 2025-11-24T14:33:25.856Z 2025-12-01T15:22:20.289Z
8582249 8582249 20251123045942_vtz2r CA002J 2025-11-24T14:33:25.573Z 2025-12-01T15:22:20.205Z
8582227 8582227 20251123044819_G5uB6 CA002J 2025-11-24T14:33:23.859Z 2025-12-01T15:22:19.301Z
8582091 8582091 20251123040435_aoHtl CA002J 2025-11-24T14:33:16.308Z 2025-12-01T15:22:15.934Z
8582045 8582045 20251123035407_2Gpss CA002J 2025-11-24T14:33:13.587Z 2025-12-01T15:22:14.896Z
8582000 8582000 20251123033417_sltFb CA002J 2025-11-24T14:33:02.932Z 2025-12-01T15:22:11.444Z
8581944 8581944 20251123031302_BZvPv CA002J 2025-11-24T14:32:48.888Z 2025-12-01T15:22:02.822Z
8581902 8581902 20251123025940_HIDK0 CA002J 2025-11-24T14:32:45.997Z 2025-12-01T15:21:56.756Z
8581862 8581862 20251123024918_9bIbP CA002J 2025-11-24T14:32:42.256Z 2025-12-01T15:21:49.928Z
8581834 8581834 20251123024348_2AqiV CA002J 2025-11-24T14:32:40.853Z 2025-12-01T15:21:44.748Z
8581739 8581739 20251123020120_GTt5o CA002J 2025-11-24T14:32:35.407Z 2025-12-01T15:21:25.255Z
8574427 8574427 20251122063831_W2SxZ CA002J 2025-11-23T14:43:34.389Z 2025-11-23T14:43:34.389Z
8574357 8574357 20251122055909_QKrK3 CA002J 2025-11-23T14:43:09.421Z 2025-11-30T15:07:05.336Z
8554587 8554587 20251120101508_jDEW0 CA002J 2025-11-22T14:35:36.010Z 2025-11-28T14:58:53.612Z
8554469 8554469 20251120095345_7WAw5 CA002J 2025-11-22T14:35:29.533Z 2025-11-28T14:58:51.624Z
8554301 8554301 20251120092242_c1CHZ CA002J 2025-11-22T14:34:59.931Z 2025-11-28T14:58:48.998Z
8554102 8554102 20251120082446_eypVU CA002J 2025-11-22T14:34:45.864Z 2025-11-28T14:58:46.389Z
8554059 8554059 20251120072650_J24Jp CA002J 2025-11-22T14:34:42.148Z 2025-11-28T14:58:45.251Z
8541815 8541815 20251120104918_1ovV2 CA002J 2025-11-22T14:00:29.416Z 2025-11-29T14:52:56.671Z
8541727 8541727 20251120103854_YST8k CA002J 2025-11-22T14:00:14.905Z 2025-11-29T14:52:52.380Z
8393533 8393533 20251107092703_0AiwD CA002J 2025-11-08T14:21:15.653Z 2025-11-15T15:00:54.136Z
8393378 8393378 20251107090556_aFCvr CA002J 2025-11-08T14:21:00.384Z 2025-11-15T15:00:52.995Z
8393317 8393317 20251107085704_nz8d4 CA002J 2025-11-08T14:20:54.638Z 2025-11-15T15:00:51.607Z
8392963 8392963 20251107075459_Qfwr8 CA002J 2025-11-08T14:19:43.022Z 2025-11-15T15:00:48.874Z
8392805 8392805 20251107071813_Q4eai CA002J 2025-11-08T14:19:25.103Z 2025-11-15T15:00:47.691Z
8392759 8392759 20251107070314_kM6a3 CA002J 2025-11-08T14:19:05.202Z 2025-11-15T15:00:47.248Z
8392646 8392646 20251107062946_Q4Q22 CA002J 2025-11-08T14:18:50.672Z 2025-11-15T15:00:46.268Z
8392567 8392567 20251107060830_3imaD CA002J 2025-11-08T14:18:42.194Z 2025-11-15T15:00:45.705Z
8392544 8392544 20251107060641_FZnNC CA002J 2025-11-08T14:18:40.863Z 2025-11-15T15:00:45.667Z
8392438 8392438 20251107053740_1oLUk CA002J 2025-11-08T14:18:14.729Z 2025-11-15T15:00:45.063Z
8392363 8392363 20251107052416_ydtAd CA002J 2025-11-08T14:18:04.241Z 2025-11-15T15:00:44.502Z
8381642 8381642 20251105064739_UqPe7 CA002J 2025-11-06T14:15:43.990Z 2025-11-13T15:15:34.762Z
8381523 8381523 20251105054418_4ojjz CA002J 2025-11-06T14:15:30.373Z 2025-11-13T15:15:31.745Z
8381508 8381508 20251105053522_xm6zA CA002J 2025-11-06T14:15:28.536Z 2025-11-13T15:15:31.053Z
8381502 8381502 20251105053245_0ja4c CA002J 2025-11-06T14:15:28.101Z 2025-11-13T15:15:30.952Z
8381485 8381485 20251105052331_csDAa CA002J 2025-11-06T14:15:25.800Z 2025-11-13T15:15:30.443Z
8381457 8381457 20251105051729_thhhg CA002J 2025-11-06T14:15:22.136Z 2025-11-13T15:15:29.776Z
8381257 8381257 20251105043516_7jGR9 CA002J 2025-11-06T14:14:23.098Z 2025-11-13T15:15:22.629Z
8381189 8381189 20251105041736_1c2Yu CA002J 2025-11-06T14:14:11.345Z 2025-11-13T15:15:20.260Z
8381085 8381085 20251105035950_8KSxw CA002J 2025-11-06T14:13:58.526Z 2025-11-13T15:15:15.761Z
8375155 8375155 20251103062213_5J337 CA002J 2025-11-05T14:34:05.112Z 2025-11-11T15:08:12.763Z
8375126 8375126 20251103061522_F3PoH CA002J 2025-11-05T14:34:03.313Z 2025-11-11T15:08:12.254Z
8375055 8375055 20251103055656_Xjjiw CA002J 2025-11-05T14:33:58.888Z 2025-11-11T15:08:11.472Z
8374848 8374848 20251103050931_TU46y CA002J 2025-11-05T14:33:18.482Z 2025-11-11T15:08:08.725Z
8374703 8374703 20251103043746_p7dT1 CA002J 2025-11-05T14:33:04.080Z 2025-11-11T15:08:05.577Z
8374656 8374656 20251103042432_HzNCP CA002J 2025-11-05T14:32:40.429Z 2025-11-11T15:07:56.088Z
8374595 8374595 20251103041320_QJo3R CA002J 2025-11-05T14:32:29.564Z 2025-11-11T15:07:46.107Z
8374462 8374462 20251103034959_NorNx CA002J 2025-11-05T14:32:12.846Z 2025-11-11T15:07:33.849Z
8374449 8374449 20251103034639_qFR5u CA002J 2025-11-05T14:32:11.239Z 2025-11-11T15:07:33.262Z
8373997 8373997 20251103021957_ocY9h CA002J 2025-11-05T14:30:33.355Z 2025-11-11T15:06:38.285Z
8326495 8326495 20251030094716_1SO7n CA002J 2025-11-01T12:35:36.054Z 2025-11-07T15:18:08.035Z
8326445 8326445 20251030094253_4y9l0 CA002J 2025-11-01T12:35:33.083Z 2025-11-07T15:18:00.517Z
8326371 8326371 20251030093557_BDsVh CA002J 2025-11-01T12:35:28.866Z 2025-11-07T15:17:55.762Z
8326218 8326218 20251030092046_aY0N2 CA002J 2025-11-01T12:35:20.790Z 2025-11-07T15:17:46.779Z
8326099 8326099 20251030090717_vF4xa CA002J 2025-11-01T12:35:15.914Z 2025-11-07T15:17:41.974Z
8326071 8326071 20251030090410_D3H4o CA002J 2025-11-01T12:35:14.452Z 2025-11-07T15:17:41.160Z
8325983 8325983 20251030085022_qQIw3 CA002J 2025-11-01T12:35:08.524Z 2025-11-07T15:17:36.207Z
8325891 8325891 20251030083614_OgV3g CA002J 2025-11-01T12:34:39.878Z 2025-11-07T15:17:31.288Z
8325674 8325674 20251030081242_SIj5d CA002J 2025-11-01T12:34:20.952Z 2025-11-07T15:17:27.918Z
8325640 8325640 20251030081023_7jWnq CA002J 2025-11-01T12:34:19.387Z 2025-11-07T15:17:27.452Z
8325631 8325631 20251030080934_vqQ63 CA002J 2025-11-01T12:34:18.961Z 2025-11-07T15:17:27.332Z
8325621 8325621 20251030080915_eh5vm CA002J 2025-11-01T12:34:18.350Z 2025-11-07T15:17:27.136Z
8325424 8325424 20251030074616_DTQFK CA002J 2025-11-01T12:34:08.797Z 2025-11-07T15:17:22.176Z
8325205 8325205 20251030072416_2WZeb CA002J 2025-11-01T12:33:30.499Z 2025-11-07T15:17:19.215Z
8324795 8324795 20251030062938_jLDXg CA002J 2025-11-01T12:33:04.179Z 2025-11-07T15:17:13.275Z
8324651 8324651 20251030060712_W1dmI CA002J 2025-11-01T12:32:34.210Z 2025-11-07T15:17:10.890Z
8324579 8324579 20251030055736_3sqrJ CA002J 2025-11-01T12:32:27.947Z 2025-11-07T15:17:09.505Z
8324473 8324473 20251030054629_kKtai CA002J 2025-11-01T12:32:22.379Z 2025-11-07T15:17:07.374Z
8324380 8324380 20251030053901_e90cm CA002J 2025-11-01T12:32:18.532Z 2025-11-07T15:17:06.146Z
8324170 8324170 20251030052739_MRPyw CA002J 2025-11-01T12:31:56.598Z 2025-11-07T15:17:03.667Z
8323694 8323694 20251030050636_hJONv CA002J 2025-11-01T12:31:22.903Z 2025-11-07T15:16:19.405Z
8323692 8323692 20251030050603_5Ra7W CA002J 2025-11-01T12:31:22.865Z 2025-11-07T15:16:19.361Z
8322947 8322947 20251030043227_GmcEu CA002J 2025-11-01T12:30:16.135Z 2025-11-07T15:15:50.621Z
8322606 8322606 20251030041838_wQNFg CA002J 2025-11-01T12:29:32.435Z 2025-11-07T15:15:41.993Z
8322424 8322424 20251030041151_41tbL CA002J 2025-11-01T12:29:24.020Z 2025-11-07T15:15:40.158Z
8322036 8322036 20251030035538_fBjvK CA002J 2025-11-01T12:28:35.736Z 2025-11-07T15:15:35.689Z
8320228 8320228 20251030024631_tWkAI CA002J 2025-11-01T12:25:56.237Z 2025-11-07T15:14:15.585Z
8300692 8300692 20251029093051_8OuVg CA002J 2025-10-30T12:54:01.783Z 2025-11-06T15:15:29.278Z
8300549 8300549 20251029074456_GWBOj CA002J 2025-10-30T12:53:50.761Z 2025-11-06T15:15:01.376Z
8300543 8300543 20251029074241_d5SVa CA002J 2025-10-30T12:53:50.149Z 2025-11-06T15:15:01.230Z
8300539 8300539 20251029074131_yjAFk CA002J 2025-10-30T12:53:50.076Z 2025-11-06T15:15:01.036Z
8300497 8300497 20251029071610_8t0lo CA002J 2025-10-30T12:53:48.368Z 2025-10-30T12:53:48.368Z
8300475 8300475 20251029071044_bxW2s CA002J 2025-10-30T12:53:46.617Z 2025-11-06T15:14:55.383Z
8300460 8300460 20251029070223_ul7hn CA002J 2025-10-30T12:53:45.641Z 2025-11-06T15:14:54.990Z
8300439 8300439 20251029065243_HIrVz CA002J 2025-10-30T12:53:44.717Z 2025-11-06T15:14:52.643Z
8300420 8300420 20251029064356_0G7lv CA002J 2025-10-30T12:53:43.659Z 2025-11-06T15:14:49.893Z
8300346 8300346 20251029055636_McEXC CA002J 2025-10-30T12:53:32.456Z 2025-11-06T15:14:43.591Z
8300296 8300296 20251029053328_L3ZRg CA002J 2025-10-30T12:53:26.995Z 2025-11-06T15:14:40.134Z
8300248 8300248 20251029051707_8qtIC CA002J 2025-10-30T12:53:14.877Z 2025-11-06T15:14:32.036Z
8300238 8300238 20251029051249_wwaMF CA002J 2025-10-30T12:53:13.350Z 2025-11-06T15:14:29.217Z
8300218 8300218 20251029050651_rK0pB CA002J 2025-10-30T12:53:12.767Z 2025-11-06T15:14:27.888Z
8300173 8300173 20251029045449_jsNdC CA002J 2025-10-30T12:53:10.058Z 2025-11-06T15:14:25.284Z
8300165 8300165 20251029045246_V7jax CA002J 2025-10-30T12:53:08.828Z 2025-11-06T15:14:24.881Z

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