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,074 rows where station_code = "CL0003" 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
9273495 9273495 20260128063653_wP62t CL0003 2026-01-29T14:30:01.270Z 2026-01-29T14:30:25.825Z
9273088 9273088 20260128043407_sSI53 CL0003 2026-01-29T14:28:43.176Z 2026-01-29T14:30:25.747Z
9272448 9272448 20260128020926_FAKom CL0003 2026-01-29T14:26:40.705Z 2026-01-29T14:30:25.348Z
9268132 9268132 20260128085743_LIe4c CL0003 2026-01-29T14:01:16.723Z 2026-01-29T14:01:16.723Z
9267887 9267887 20260127062931_F1nVh CL0003 2026-01-28T14:23:45.670Z 2026-01-29T14:35:50.863Z
9267850 9267850 20260127060121_t6kCD CL0003 2026-01-28T14:23:33.376Z 2026-01-29T14:35:48.301Z
9267696 9267696 20260127042446_lTEWQ CL0003 2026-01-28T14:22:55.123Z 2026-01-29T14:35:29.435Z
9267682 9267682 20260127041518_dKd8J CL0003 2026-01-28T14:22:51.840Z 2026-01-29T14:35:28.114Z
9267553 9267553 20260127030424_D7dDd CL0003 2026-01-28T14:22:12.968Z 2026-01-29T14:35:17.196Z
9263499 9263499 20260127084139_LUF25 CL0003 2026-01-28T14:01:00.370Z 2026-01-29T14:30:16.535Z
9263018 9263018 20260126061439_SjL38 CL0003 2026-01-27T14:16:38.089Z 2026-01-29T14:39:09.836Z
9262970 9262970 20260126054007_y09ZG CL0003 2026-01-27T14:16:18.920Z 2026-01-29T14:39:07.084Z
9260719 9260719 20260125073722_ZKSuW CL0003 2026-01-26T14:23:08.961Z 2026-01-29T14:44:37.585Z
9260714 9260714 20260125073220_zN0nj CL0003 2026-01-26T14:23:08.387Z 2026-01-29T14:44:37.349Z
9260712 9260712 20260125073210_mwrzi CL0003 2026-01-26T14:23:08.019Z 2026-01-29T14:44:37.209Z
9260685 9260685 20260125070820_3sx2v CL0003 2026-01-26T14:23:02.529Z 2026-01-29T14:44:35.525Z
9260674 9260674 20260125063906_jq73m CL0003 2026-01-26T14:22:59.916Z 2026-01-29T14:44:34.872Z
9260638 9260638 20260125060942_hM936 CL0003 2026-01-26T14:22:41.920Z 2026-01-29T14:44:32.788Z
9260623 9260623 20260125055941_liYun CL0003 2026-01-26T14:22:38.046Z 2026-01-29T14:44:31.666Z
9260371 9260371 20260125040243_coP6i CL0003 2026-01-26T14:21:26.263Z 2026-01-29T14:44:08.679Z
9260232 9260232 20260125031158_vx4AX CL0003 2026-01-26T14:20:53.161Z 2026-01-29T14:44:01.214Z
9259945 9259945 20260125012240_2aAoH CL0003 2026-01-26T14:19:25.917Z 2026-01-29T14:43:36.436Z
9256310 9256310 20260124071347_em1f1 CL0003 2026-01-25T14:16:36.825Z 2026-01-29T14:48:36.672Z
9256308 9256308 20260124070909_ObXU2 CL0003 2026-01-25T14:16:36.269Z 2026-01-29T14:48:36.530Z
9256297 9256297 20260124065318_JFxUV CL0003 2026-01-25T14:16:33.271Z 2026-01-29T14:48:35.789Z
9256295 9256295 20260124065029_ip2J3 CL0003 2026-01-25T14:16:32.907Z 2026-01-29T14:48:35.586Z
9255571 9255571 20260124041403_wHvqx CL0003 2026-01-25T14:14:00.003Z 2026-01-29T14:47:40.755Z
9255119 9255119 20260124010156_j4tXt CL0003 2026-01-25T14:11:57.309Z 2026-01-29T14:47:03.357Z
9252919 9252919 20260123080416_hM6GR CL0003 2026-01-24T14:17:47.102Z 2026-01-29T14:53:42.197Z
9252868 9252868 20260123071822_TRMhr CL0003 2026-01-24T14:17:33.773Z 2026-01-29T14:53:38.720Z
9252845 9252845 20260123070111_Z2fCj CL0003 2026-01-24T14:17:28.658Z 2026-01-29T14:53:37.064Z
9252818 9252818 20260123064204_Lj4kQ CL0003 2026-01-24T14:17:23.286Z 2026-01-29T14:53:34.861Z
9252733 9252733 20260123055635_Z73Yl CL0003 2026-01-24T14:16:57.334Z 2026-01-29T14:53:21.684Z
9252548 9252548 20260123040518_x6BHD CL0003 2026-01-24T14:16:08.720Z 2026-01-29T14:53:07.777Z
9252349 9252349 20260123022455_Umcgb CL0003 2026-01-24T14:15:13.393Z 2026-01-29T14:52:46.240Z
9252169 9252169 20260123012852_kYqL2 CL0003 2026-01-24T14:14:37.647Z 2026-01-29T14:52:37.519Z
9249731 9249731 20260122080238_yCn9x CL0003 2026-01-23T14:16:01.725Z 2026-01-29T14:58:52.083Z
9249729 9249729 20260122075444_c1FXJ CL0003 2026-01-23T14:16:01.515Z 2026-01-29T14:58:51.974Z
9249718 9249718 20260122072906_0shH3 CL0003 2026-01-23T14:16:00.241Z 2026-01-29T14:58:51.341Z
9249716 9249716 20260122072849_G26Ul CL0003 2026-01-23T14:15:59.850Z 2026-01-29T14:58:51.162Z
9249562 9249562 20260122054943_SKlK9 CL0003 2026-01-23T14:15:42.836Z 2026-01-29T14:58:44.855Z
9249533 9249533 20260122053909_o4Izv CL0003 2026-01-23T14:15:39.726Z 2026-01-29T14:58:43.424Z
9249391 9249391 20260122050657_flxMY CL0003 2026-01-23T14:15:17.067Z 2026-01-29T14:58:28.498Z
9248975 9248975 20260122025800_aVhrj CL0003 2026-01-23T14:14:14.513Z 2026-01-29T14:58:01.584Z
9244410 9244410 20260121081920_wrgjP CL0003 2026-01-22T14:25:25.000Z 2026-01-29T15:06:07.877Z
9244255 9244255 20260121070211_qLYRx CL0003 2026-01-22T14:24:44.646Z 2026-01-29T15:05:57.747Z
9243608 9243608 20260121045139_av8ID CL0003 2026-01-22T14:22:23.267Z 2026-01-29T15:05:19.809Z
9242994 9242994 20260121032536_dOBGe CL0003 2026-01-22T14:20:14.736Z 2026-01-29T15:04:42.719Z
9242495 9242495 20260121020603_ssuAc CL0003 2026-01-22T14:18:03.593Z 2026-01-29T15:04:01.676Z
9238099 9238099 20260120071947_1JV9K CL0003 2026-01-21T14:28:41.192Z 2026-01-28T15:02:07.262Z
9237971 9237971 20260120063946_p6P7t CL0003 2026-01-21T14:28:09.863Z 2026-01-28T15:02:01.066Z
9236166 9236166 20260120024251_IAdTI CL0003 2026-01-21T14:21:51.885Z 2026-01-28T14:59:48.126Z
9235812 9235812 20260120020210_MzWrx CL0003 2026-01-21T14:20:26.961Z 2026-01-28T14:59:21.886Z
9235225 9235225 20260120004509_OnMGA CL0003 2026-01-21T14:17:59.800Z 2026-01-28T14:58:44.519Z
9231455 9231455 20260119081047_qsWuR CL0003 2026-01-20T14:32:55.916Z 2026-01-27T15:06:30.487Z
9231440 9231440 20260119080003_Hb4jt CL0003 2026-01-20T14:32:53.058Z 2026-01-27T15:06:29.791Z
9231435 9231435 20260119075844_URGL1 CL0003 2026-01-20T14:32:51.934Z 2026-01-27T15:06:29.600Z
9231403 9231403 20260119075314_757Y5 CL0003 2026-01-20T14:32:39.100Z 2026-01-27T15:06:27.959Z
9231332 9231332 20260119072344_C6S4x CL0003 2026-01-20T14:32:23.718Z 2026-01-27T15:06:24.291Z
9231320 9231320 20260119071759_Hh65D CL0003 2026-01-20T14:32:20.655Z 2026-01-27T15:06:23.549Z
9231127 9231127 20260119060847_iKOkK CL0003 2026-01-20T14:31:26.498Z 2026-01-27T15:06:00.043Z
9231071 9231071 20260119055521_ZmsRI CL0003 2026-01-20T14:31:07.723Z 2026-01-27T15:05:56.474Z
9225002 9225002 20260118071044_lHvT6 CL0003 2026-01-19T14:27:13.980Z 2026-01-26T15:03:57.906Z
9224724 9224724 20260118055101_DbPEx CL0003 2026-01-19T14:25:44.223Z 2026-01-26T15:03:46.859Z
9223869 9223869 20260118023854_fEhwf CL0003 2026-01-19T14:21:32.607Z 2026-01-26T15:02:39.466Z
9219142 9219142 20260117081942_fax96 CL0003 2026-01-18T14:15:12.091Z 2026-01-25T14:59:03.425Z
9219063 9219063 20260117072541_n8AkA CL0003 2026-01-18T14:14:49.544Z 2026-01-25T14:59:00.384Z
9219003 9219003 20260117070015_lF5Y2 CL0003 2026-01-18T14:14:33.790Z 2026-01-25T14:58:57.906Z
9218739 9218739 20260117053324_QYp2R CL0003 2026-01-18T14:13:30.196Z 2026-01-25T14:58:37.552Z
9214904 9214904 20260116084354_NEylq CL0003 2026-01-17T14:23:41.226Z 2026-01-24T15:14:14.043Z
9214800 9214800 20260116081333_E1Yp4 CL0003 2026-01-17T14:23:18.635Z 2026-01-24T15:14:08.346Z
9214639 9214639 20260116071530_Yy3gW CL0003 2026-01-17T14:22:30.305Z 2026-01-24T15:13:57.232Z
9214268 9214268 20260116060329_FIVtK CL0003 2026-01-17T14:20:49.947Z 2026-01-24T15:13:27.108Z
9214208 9214208 20260116055432_D2r7E CL0003 2026-01-17T14:20:36.113Z 2026-01-24T15:13:22.884Z
9214192 9214192 20260116055224_fOy4K CL0003 2026-01-17T14:20:31.011Z 2026-01-24T15:13:21.198Z
9214058 9214058 20260116052844_RQ8nn CL0003 2026-01-17T14:19:51.335Z 2026-01-24T15:13:01.502Z
9213943 9213943 20260116050430_Qmfsc CL0003 2026-01-17T14:19:17.375Z 2026-01-24T15:12:53.012Z
9213636 9213636 20260116041036_fBG4y CL0003 2026-01-17T14:17:51.791Z 2026-01-24T15:12:28.965Z
9213535 9213535 20260116035803_3l9gT CL0003 2026-01-17T14:17:24.323Z 2026-01-24T15:12:20.491Z
9212772 9212772 20260116005756_uLe7C CL0003 2026-01-17T14:13:46.686Z 2026-01-24T15:11:25.908Z
9209035 9209035 20260115081136_HSDA2 CL0003 2026-01-16T14:14:53.048Z 2026-01-22T15:04:47.190Z
9208775 9208775 20260115064511_olemB CL0003 2026-01-16T14:13:55.316Z 2026-01-22T15:04:39.452Z
9208505 9208505 20260115054752_qJL2C CL0003 2026-01-16T14:12:56.662Z 2026-01-22T15:04:31.943Z
9208186 9208186 20260115043125_rI8fJ CL0003 2026-01-16T14:11:38.703Z 2026-01-22T15:04:03.583Z
9208102 9208102 20260115041704_xpPO3 CL0003 2026-01-16T14:11:20.606Z 2026-01-22T15:04:01.425Z
9207329 9207329 20260115010216_zokDQ CL0003 2026-01-16T14:08:18.431Z 2026-01-22T15:03:19.082Z
9204776 9204776 20260114084713_gpThm CL0003 2026-01-15T14:28:35.152Z 2026-01-22T15:11:02.846Z
9204656 9204656 20260114075652_5zAak CL0003 2026-01-15T14:28:02.664Z 2026-01-22T15:11:00.548Z
9204599 9204599 20260114072349_ZTtpT CL0003 2026-01-15T14:27:46.336Z 2026-01-22T15:10:46.849Z
9204594 9204594 20260114071947_1wJms CL0003 2026-01-15T14:27:44.945Z 2026-01-22T15:10:45.684Z
9202462 9202462 20260114034044_glRKT CL0003 2026-01-15T14:21:21.073Z 2026-01-22T15:09:20.493Z
9201724 9201724 20260114024534_9uXR4 CL0003 2026-01-15T14:19:27.781Z 2026-01-22T15:09:08.245Z
9196537 9196537 20260113073715_b2Dgr CL0003 2026-01-14T14:18:48.328Z 2026-01-21T15:05:34.315Z
9196369 9196369 20260113063615_TJ450 CL0003 2026-01-14T14:17:59.482Z 2026-01-21T15:05:32.174Z
9196121 9196121 20260113044714_3hzSL CL0003 2026-01-14T14:16:45.635Z 2026-01-21T15:05:28.380Z
9196029 9196029 20260113040550_cvmfY CL0003 2026-01-14T14:16:09.938Z 2026-01-21T15:05:10.858Z
9195804 9195804 20260113025455_k9yQ4 CL0003 2026-01-14T14:15:01.468Z 2026-01-21T15:04:47.881Z
9195386 9195386 20260113011757_Lf20K CL0003 2026-01-14T14:13:07.893Z 2026-01-21T15:04:39.806Z
9190104 9190104 20260112075005_zXM2v CL0003 2026-01-13T14:20:43.736Z 2026-01-20T15:24:07.021Z
9190062 9190062 20260112074306_AM3mx CL0003 2026-01-13T14:20:35.293Z 2026-01-20T15:24:05.332Z

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