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

4,481 rows where station_code = "CZ000E" 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
9610693 9610693 20260404211436_2Ac9a CZ000E 2026-04-06T12:10:47.147Z 2026-04-06T12:16:14.637Z
9608052 9608052 20260403184841_Lohpn CZ000E 2026-04-05T12:08:06.840Z 2026-04-06T12:19:29.723Z
9606724 9606724 20260402193932_2cJWw CZ000E 2026-04-04T12:11:14.948Z 2026-04-06T12:23:33.578Z
9600180 9600180 20260330023545_7Z8ZM CZ000E 2026-04-01T12:06:32.600Z 2026-04-06T12:29:42.712Z
9579649 9579649 20260324220224_fUAR3 CZ000E 2026-03-26T12:14:07.544Z 2026-04-02T12:37:18.843Z
9575484 9575484 20260323224824_OTVe8 CZ000E 2026-03-25T12:21:14.910Z 2026-03-31T12:29:00.017Z
9575309 9575309 20260323203118_LQjzN CZ000E 2026-03-25T12:20:48.130Z 2026-03-31T12:28:54.356Z
9575125 9575125 20260323184958_krbWe CZ000E 2026-03-25T12:20:20.944Z 2026-03-31T12:28:49.058Z
9571091 9571091 20260322234348_C8NOy CZ000E 2026-03-24T12:24:19.711Z 2026-03-30T12:30:55.056Z
9571026 9571026 20260322233827_qvUOF CZ000E 2026-03-24T12:24:10.764Z 2026-03-30T12:30:54.087Z
9570891 9570891 20260322230922_yDNKu CZ000E 2026-03-24T12:23:58.671Z 2026-03-30T12:30:51.402Z
9562770 9562770 20260323031150_s93Dv CZ000E 2026-03-24T12:04:00.551Z 2026-03-31T12:26:25.615Z
9562749 9562749 20260323030857_hWz62 CZ000E 2026-03-24T12:03:56.843Z 2026-03-31T12:26:25.047Z
9562639 9562639 20260323025211_oNb6V CZ000E 2026-03-24T12:03:38.906Z 2026-03-31T12:26:16.334Z
9562575 9562575 20260323023929_p2Ci0 CZ000E 2026-03-24T12:03:28.583Z 2026-03-31T12:26:14.750Z
9562568 9562568 20260323023511_SM3va CZ000E 2026-03-24T12:03:27.482Z 2026-03-31T12:26:14.559Z
9562361 9562361 20260323021417_naP4E CZ000E 2026-03-24T12:02:55.203Z 2026-03-31T12:26:08.651Z
9562275 9562275 20260323020048_Hdom5 CZ000E 2026-03-24T12:02:41.290Z 2026-03-31T12:26:06.333Z
9562135 9562135 20260323013655_XFBiC CZ000E 2026-03-24T12:02:17.162Z 2026-03-31T12:26:02.209Z
9561331 9561331 20260321232325_oldNE CZ000E 2026-03-23T12:12:16.800Z 2026-03-29T12:21:06.507Z
9561328 9561328 20260321232325_nnCna CZ000E 2026-03-23T12:12:16.714Z 2026-03-29T12:21:06.461Z
9560420 9560420 20260321211937_BhhOT CZ000E 2026-03-23T12:11:46.318Z 2026-03-29T12:20:59.989Z
9560143 9560143 20260321203505_v3Hm7 CZ000E 2026-03-23T12:11:38.908Z 2026-03-29T12:20:58.172Z
9559690 9559690 20260321192935_hch4n CZ000E 2026-03-23T12:11:27.179Z 2026-03-29T12:20:46.356Z
9554684 9554684 20260322032607_KPpHD CZ000E 2026-03-23T12:02:46.183Z 2026-03-30T12:28:07.253Z
9553929 9553929 20260322022449_g0RM2 CZ000E 2026-03-23T12:02:00.560Z 2026-03-30T12:27:55.291Z
9553830 9553830 20260322021842_jNK6h CZ000E 2026-03-23T12:01:54.460Z 2026-03-30T12:27:53.298Z
9553612 9553612 20260322020043_jUOKG CZ000E 2026-03-23T12:01:42.884Z 2026-03-30T12:27:50.099Z
9553532 9553532 20260322014747_4YH0J CZ000E 2026-03-23T12:01:36.507Z 2026-03-30T12:27:42.670Z
9542390 9542390 20260319232109_APMnn CZ000E 2026-03-21T12:30:01.460Z 2026-03-27T12:43:01.797Z
9542362 9542362 20260319231520_moS8w CZ000E 2026-03-21T12:29:59.399Z 2026-03-27T12:42:59.937Z
9541468 9541468 20260319204131_WyW6C CZ000E 2026-03-21T12:28:58.898Z 2026-03-27T12:42:38.022Z
9540980 9540980 20260319184825_uzK8i CZ000E 2026-03-21T12:28:21.441Z 2026-03-27T12:42:32.709Z
9534161 9534161 20260320033250_uaxxu CZ000E 2026-03-21T12:07:19.114Z 2026-03-28T12:34:15.231Z
9533944 9533944 20260320031005_u2fa3 CZ000E 2026-03-21T12:06:42.827Z 2026-03-28T12:34:02.504Z
9533928 9533928 20260320030943_c3lPj CZ000E 2026-03-21T12:06:40.464Z 2026-03-28T12:34:02.328Z
9533075 9533075 20260320015704_zyIjd CZ000E 2026-03-21T12:04:21.779Z 2026-03-28T12:33:48.349Z
9531106 9531106 20260318222614_VhQog CZ000E 2026-03-20T12:24:57.910Z 2026-03-26T12:39:17.470Z
9530940 9530940 20260318220324_YyDvb CZ000E 2026-03-20T12:24:52.080Z 2026-03-26T12:39:16.639Z
9530881 9530881 20260318215703_jIw0i CZ000E 2026-03-20T12:24:50.754Z 2026-03-26T12:39:16.404Z
9521058 9521058 20260319035304_oY8Ie CZ000E 2026-03-20T12:07:28.206Z 2026-03-27T12:40:50.742Z
9520914 9520914 20260319034428_r322X CZ000E 2026-03-20T12:07:13.789Z 2026-03-27T12:40:49.007Z
9516711 9516711 20260317214202_lxgf5 CZ000E 2026-03-19T12:26:41.017Z 2026-03-25T12:43:06.253Z
9516563 9516563 20260317211248_YyhXs CZ000E 2026-03-19T12:26:25.175Z 2026-03-25T12:43:02.886Z
9516070 9516070 20260317195046_qdcGO CZ000E 2026-03-19T12:25:36.547Z 2026-03-25T12:42:47.631Z
9515897 9515897 20260317191655_YPCk2 CZ000E 2026-03-19T12:25:14.087Z 2026-03-25T12:42:41.456Z
9515772 9515772 20260317183035_y9njH CZ000E 2026-03-19T12:24:50.135Z 2026-03-25T12:42:35.588Z
9483602 9483602 20260312015305_5e2zx CZ000E 2026-03-15T12:28:05.243Z 2026-03-20T12:36:22.733Z
9483598 9483598 20260312010629_cANYm CZ000E 2026-03-15T12:27:46.427Z 2026-03-20T12:36:20.057Z
9483455 9483455 20260313221744_kI9Wd CZ000E 2026-03-15T12:26:32.925Z 2026-03-21T12:50:27.814Z
9482952 9482952 20260313195820_nrqN2 CZ000E 2026-03-15T12:25:37.764Z 2026-03-21T12:50:11.863Z
9482832 9482832 20260313191422_Lz9bG CZ000E 2026-03-15T12:25:16.584Z 2026-03-21T12:50:01.639Z
9476722 9476722 20260314033555_EKGNO CZ000E 2026-03-15T12:06:43.253Z 2026-03-22T12:41:58.759Z
9476514 9476514 20260314031348_yHmXn CZ000E 2026-03-15T12:06:13.703Z 2026-03-22T12:41:57.362Z
9476432 9476432 20260314030753_QYJT3 CZ000E 2026-03-15T12:05:58.419Z 2026-03-22T12:41:56.623Z
9476253 9476253 20260314024819_ObOkU CZ000E 2026-03-15T12:05:24.559Z 2026-03-22T12:41:55.319Z
9475722 9475722 20260314020036_bVMT3 CZ000E 2026-03-15T12:03:56.723Z 2026-03-22T12:41:50.493Z
9475468 9475468 20260314013117_T1GtN CZ000E 2026-03-15T12:03:14.268Z 2026-03-22T12:41:39.690Z
9475313 9475313 20260314011414_jHgT1 CZ000E 2026-03-15T12:02:50.897Z 2026-03-22T12:41:32.835Z
9475121 9475121 20260314004253_u4sJt CZ000E 2026-03-15T12:02:18.421Z 2026-03-22T12:41:27.132Z
9475002 9475002 20260314002545_5VrvS CZ000E 2026-03-15T12:01:59.242Z 2026-03-22T12:41:26.173Z
9474975 9474975 20260314002308_g6E3Q CZ000E 2026-03-15T12:01:54.681Z 2026-03-22T12:41:25.905Z
9474872 9474872 20260314000918_4RtYg CZ000E 2026-03-15T12:01:34.471Z 2026-03-22T12:41:25.000Z
9474681 9474681 20260313233803_O2d3z CZ000E 2026-03-15T12:00:56.444Z 2026-03-22T12:41:23.271Z
9467714 9467714 20260311223756_LQxxf CZ000E 2026-03-13T12:19:43.599Z 2026-03-19T12:45:54.427Z
9467712 9467712 20260311223707_rZl2x CZ000E 2026-03-13T12:19:43.431Z 2026-03-14T12:28:18.440Z
9463490 9463490 20260312015823_OXVN7 CZ000E 2026-03-13T12:04:21.808Z 2026-03-20T12:36:22.928Z
9463411 9463411 20260312014629_pTIQt CZ000E 2026-03-13T12:04:03.988Z 2026-03-20T12:36:22.394Z
9462289 9462289 20260311224910_5vl28 CZ000E 2026-03-13T12:00:20.949Z 2026-03-20T12:36:14.920Z
9456801 9456801 20260311010141_E3ZBB CZ000E 2026-03-12T12:01:49.765Z 2026-03-19T12:44:22.155Z
9456716 9456716 20260311003230_nAJ2h CZ000E 2026-03-12T12:01:32.995Z 2026-03-19T12:44:21.076Z
9455923 9455923 20260309210355_gPwbO CZ000E 2026-03-11T12:15:15.515Z 2026-03-17T12:42:40.667Z
9455897 9455897 20260309205404_ZdgPS CZ000E 2026-03-11T12:15:12.626Z 2026-03-17T12:42:40.333Z
9455533 9455533 20260309183323_MhbW0 CZ000E 2026-03-11T12:14:32.080Z 2026-03-17T12:42:34.315Z
9445710 9445710 20260307211621_4R11q CZ000E 2026-03-09T12:20:29.458Z 2026-03-15T12:42:13.551Z
9445536 9445536 20260307202139_bII3g CZ000E 2026-03-09T12:19:39.630Z 2026-03-15T12:42:10.660Z
9445349 9445349 20260307183331_NSiin CZ000E 2026-03-09T12:18:37.389Z 2026-03-15T12:42:06.516Z
9441854 9441854 20260308000116_P5rEw CZ000E 2026-03-09T12:01:31.397Z 2026-03-16T12:43:32.345Z
9441673 9441673 20260307231031_BWRio CZ000E 2026-03-09T12:00:40.817Z 2026-03-16T12:43:29.385Z
9441530 9441530 20260306222633_mRkiu CZ000E 2026-03-08T12:22:17.154Z 2026-03-14T12:40:54.731Z
9441297 9441297 20260306205425_vjne5 CZ000E 2026-03-08T12:21:17.314Z 2026-03-14T12:40:49.793Z
9441295 9441295 20260306205410_2qLGO CZ000E 2026-03-08T12:21:16.884Z 2026-03-14T12:40:49.777Z
9441207 9441207 20260306202709_cgt2W CZ000E 2026-03-08T12:20:51.103Z 2026-03-14T12:40:47.112Z
9436587 9436587 20260306224432_9L6SN CZ000E 2026-03-08T12:00:13.030Z 2026-03-15T12:40:54.998Z
9436359 9436359 20260305210817_c8sut CZ000E 2026-03-07T14:25:39.758Z 2026-03-13T12:35:58.979Z
9436127 9436127 20260305191800_GgGOW CZ000E 2026-03-07T14:24:35.132Z 2026-03-13T12:35:40.972Z
9435966 9435966 20260305174846_3y5QR CZ000E 2026-03-07T14:23:51.623Z 2026-03-13T12:35:38.628Z
9431392 9431392 20260305231919_kaFN0 CZ000E 2026-03-07T14:00:28.075Z 2026-03-14T12:39:11.845Z
9431321 9431321 20260305224233_XL03Q CZ000E 2026-03-07T14:00:12.389Z 2026-03-14T12:39:10.195Z
9430457 9430457 20260304190431_U1F5A CZ000E 2026-03-06T14:23:02.580Z 2026-03-12T12:33:31.221Z
9414887 9414887 20260228182418_OEIHJ CZ000E 2026-03-02T14:06:57.069Z 2026-03-08T12:42:45.440Z
9409277 9409277 20260228023206_RazVn CZ000E 2026-03-01T14:01:06.632Z 2026-03-08T12:41:04.434Z
9409251 9409251 20260228022526_qwu3b CZ000E 2026-03-01T14:01:01.837Z 2026-03-08T12:41:03.251Z
9409096 9409096 20260228010908_fdhia CZ000E 2026-03-01T14:00:41.219Z 2026-03-08T12:40:55.771Z
9408884 9408884 20260225220037_tsB1D CZ000E 2026-02-28T14:31:45.047Z 2026-03-05T14:39:04.908Z
9407641 9407641 20260226200304_D2vq3 CZ000E 2026-02-28T14:22:05.180Z 2026-03-06T14:45:14.533Z
9407542 9407542 20260226191404_QR9o6 CZ000E 2026-02-28T14:21:49.833Z 2026-03-06T14:45:11.871Z
9407536 9407536 20260226191403_dmQQz CZ000E 2026-02-28T14:21:49.549Z 2026-03-06T14:45:11.821Z
9402580 9402580 20260227040710_Cp0qG CZ000E 2026-02-28T14:05:18.357Z 2026-03-07T14:46:53.260Z
9402060 9402060 20260227023730_UOIYi CZ000E 2026-02-28T14:03:22.737Z 2026-03-07T14:46:21.963Z

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