participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,316 rows where station_code = "CA002L" sorted by created_at descending
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 |
---|---|---|---|---|---|
5134376 | 5134376 | 20240916083943_x8MnF | CA002L | 2024-09-19T12:17:40.046Z | 2024-09-19T12:17:40.046Z |
5134295 | 5134295 | 20240916075104_7GqnC | CA002L | 2024-09-19T12:17:35.930Z | 2024-09-19T12:17:35.930Z |
5130102 | 5130102 | 20240917090718_9y0Yl | CA002L | 2024-09-19T12:12:34.949Z | 2024-09-19T12:12:34.949Z |
5122403 | 5122403 | 20240914060834_1D5a3 | CA002L | 2024-09-18T12:11:17.394Z | 2024-09-19T12:20:04.184Z |
5122346 | 5122346 | 20240914054818_3TexW | CA002L | 2024-09-18T12:11:15.166Z | 2024-09-19T12:20:03.975Z |
5122311 | 5122311 | 20240914053325_ao87A | CA002L | 2024-09-18T12:11:13.703Z | 2024-09-19T12:20:03.862Z |
5122270 | 5122270 | 20240914051744_cwbDm | CA002L | 2024-09-18T12:11:12.102Z | 2024-09-19T12:20:03.562Z |
5122186 | 5122186 | 20240914044654_TWOxB | CA002L | 2024-09-18T12:11:08.866Z | 2024-09-19T12:20:02.948Z |
5122094 | 5122094 | 20240914043223_nQ7VJ | CA002L | 2024-09-18T12:11:06.805Z | 2024-09-19T12:20:02.757Z |
5121713 | 5121713 | 20240914041226_XPUKP | CA002L | 2024-09-18T12:10:59.916Z | 2024-09-19T12:20:02.266Z |
5118186 | 5118186 | 20240915084744_sZGDn | CA002L | 2024-09-18T12:08:28.919Z | 2024-09-19T12:19:21.112Z |
5118178 | 5118178 | 20240915084643_k2kbi | CA002L | 2024-09-18T12:08:28.588Z | 2024-09-19T12:19:21.078Z |
5118116 | 5118116 | 20240915083601_ayeU9 | CA002L | 2024-09-18T12:08:24.987Z | 2024-09-19T12:19:20.571Z |
5118052 | 5118052 | 20240915081815_Uqrx2 | CA002L | 2024-09-18T12:08:20.817Z | 2024-09-19T12:19:19.966Z |
5117831 | 5117831 | 20240915071552_dGcks | CA002L | 2024-09-18T12:08:02.307Z | 2024-09-19T12:19:18.323Z |
5117771 | 5117771 | 20240915065728_djF30 | CA002L | 2024-09-18T12:07:57.970Z | 2024-09-19T12:19:17.690Z |
5117746 | 5117746 | 20240915064146_4DrVT | CA002L | 2024-09-18T12:07:54.968Z | 2024-09-19T12:19:17.495Z |
5117736 | 5117736 | 20240915064132_13jMO | CA002L | 2024-09-18T12:07:54.512Z | 2024-09-19T12:19:17.357Z |
5116312 | 5116312 | 20240915032109_vJ9jd | CA002L | 2024-09-18T12:06:56.571Z | 2024-09-19T12:19:10.315Z |
5116311 | 5116311 | 20240915032107_0adDM | CA002L | 2024-09-18T12:06:56.312Z | 2024-09-19T12:19:10.302Z |
5113317 | 5113317 | 20240915003716_qWUd4 | CA002L | 2024-09-18T12:04:07.803Z | 2024-09-19T12:18:48.456Z |
5108439 | 5108439 | 20240913053348_ruPXd | CA002L | 2024-09-17T12:13:44.676Z | 2024-09-19T12:20:48.827Z |
5105152 | 5105152 | 20240913023247_3HD0T | CA002L | 2024-09-17T12:11:59.392Z | 2024-09-19T12:20:44.002Z |
5093775 | 5093775 | 20240912033450_67tMy | CA002L | 2024-09-16T12:14:25.145Z | 2024-09-19T12:21:15.644Z |
5078180 | 5078180 | 20240911014228_FRl4A | CA002L | 2024-09-15T12:15:22.680Z | 2024-09-19T12:21:40.048Z |
5048172 | 5048172 | 20240909071758_szLUA | CA002L | 2024-09-13T12:10:19.443Z | 2024-09-17T12:19:06.014Z |
5041648 | 5041648 | 20240906084428_vcWXT | CA002L | 2024-09-12T12:16:46.216Z | 2024-09-14T12:23:14.265Z |
5041643 | 5041643 | 20240906084340_iHDh2 | CA002L | 2024-09-12T12:16:46.135Z | 2024-09-14T12:23:14.262Z |
5041475 | 5041475 | 20240906082310_n7sS8 | CA002L | 2024-09-12T12:16:42.875Z | 2024-09-14T12:23:13.629Z |
5041314 | 5041314 | 20240906075430_zFyCD | CA002L | 2024-09-12T12:16:38.552Z | 2024-09-14T12:23:12.626Z |
5040979 | 5040979 | 20240906065030_ETaCP | CA002L | 2024-09-12T12:16:30.966Z | 2024-09-14T12:23:11.136Z |
5040942 | 5040942 | 20240906063453_PePpZ | CA002L | 2024-09-12T12:16:28.947Z | 2024-09-14T12:23:11.057Z |
5040899 | 5040899 | 20240906062442_a2vUB | CA002L | 2024-09-12T12:16:28.039Z | 2024-09-14T12:23:10.954Z |
5040886 | 5040886 | 20240906062106_G2S3x | CA002L | 2024-09-12T12:16:27.567Z | 2024-09-14T12:23:10.879Z |
5040878 | 5040878 | 20240906061758_HwwWR | CA002L | 2024-09-12T12:16:27.381Z | 2024-09-14T12:23:10.801Z |
5040856 | 5040856 | 20240906061242_3uhl3 | CA002L | 2024-09-12T12:16:26.633Z | 2024-09-14T12:23:10.685Z |
5040851 | 5040851 | 20240906061216_bmqR0 | CA002L | 2024-09-12T12:16:26.630Z | 2024-09-14T12:23:10.685Z |
5040815 | 5040815 | 20240906055650_JfKNG | CA002L | 2024-09-12T12:16:25.550Z | 2024-09-14T12:23:10.630Z |
5040666 | 5040666 | 20240906052236_ncoHG | CA002L | 2024-09-12T12:16:19.109Z | 2024-09-14T12:23:10.268Z |
5040635 | 5040635 | 20240906051307_relAB | CA002L | 2024-09-12T12:16:18.198Z | 2024-09-14T12:23:10.135Z |
5040624 | 5040624 | 20240906050721_wmDF9 | CA002L | 2024-09-12T12:16:17.764Z | 2024-09-14T12:23:10.127Z |
5040545 | 5040545 | 20240906044433_c79Ci | CA002L | 2024-09-12T12:16:15.658Z | 2024-09-14T12:23:09.879Z |
5040502 | 5040502 | 20240906043048_UCK5F | CA002L | 2024-09-12T12:16:13.727Z | 2024-09-14T12:23:09.561Z |
5040495 | 5040495 | 20240906042935_f29hu | CA002L | 2024-09-12T12:16:13.194Z | 2024-09-14T12:23:09.557Z |
5040451 | 5040451 | 20240906041635_jIZeW | CA002L | 2024-09-12T12:16:11.734Z | 2024-09-14T12:23:09.271Z |
5040429 | 5040429 | 20240906041122_A8QdW | CA002L | 2024-09-12T12:16:11.040Z | 2024-09-14T12:23:09.134Z |
5040331 | 5040331 | 20240906034441_3CBrx | CA002L | 2024-09-12T12:16:06.711Z | 2024-09-14T12:23:08.756Z |
5040306 | 5040306 | 20240906033853_DsbPM | CA002L | 2024-09-12T12:16:06.119Z | 2024-09-14T12:23:08.675Z |
5040249 | 5040249 | 20240906032144_0Sk6z | CA002L | 2024-09-12T12:16:04.199Z | 2024-09-14T12:23:08.476Z |
5039885 | 5039885 | 20240906021838_ujnDB | CA002L | 2024-09-12T12:15:48.661Z | 2024-09-14T12:23:05.743Z |
5039855 | 5039855 | 20240906021016_vc24w | CA002L | 2024-09-12T12:15:47.690Z | 2024-09-14T12:23:05.392Z |
5039841 | 5039841 | 20240906020735_a3Qxe | CA002L | 2024-09-12T12:15:47.226Z | 2024-09-14T12:23:05.317Z |
5039658 | 5039658 | 20240906014637_RKog8 | CA002L | 2024-09-12T12:15:41.393Z | 2024-09-14T12:23:03.903Z |
5039639 | 5039639 | 20240906014137_nU9uO | CA002L | 2024-09-12T12:15:40.944Z | 2024-09-14T12:23:03.871Z |
5039612 | 5039612 | 20240906013409_XtCyE | CA002L | 2024-09-12T12:15:38.801Z | 2024-09-14T12:23:03.726Z |
5039390 | 5039390 | 20240906004119_FgDHV | CA002L | 2024-09-12T12:15:29.001Z | 2024-09-14T12:23:01.797Z |
5035057 | 5035057 | 20240907083831_YH6uj | CA002L | 2024-09-12T12:11:50.725Z | 2024-09-15T12:21:38.023Z |
5035028 | 5035028 | 20240907083528_HEg1R | CA002L | 2024-09-12T12:11:49.713Z | 2024-09-15T12:21:37.919Z |
5035022 | 5035022 | 20240907083504_akxhC | CA002L | 2024-09-12T12:11:49.463Z | 2024-09-15T12:21:37.907Z |
5035018 | 5035018 | 20240907083244_h2SA1 | CA002L | 2024-09-12T12:11:49.376Z | 2024-09-15T12:21:37.899Z |
5034915 | 5034915 | 20240907081813_wyA7l | CA002L | 2024-09-12T12:11:44.256Z | 2024-09-15T12:21:37.541Z |
5034821 | 5034821 | 20240907080710_SV5AV | CA002L | 2024-09-12T12:11:31.162Z | 2024-09-15T12:21:36.826Z |
5034773 | 5034773 | 20240907075926_xQ5k2 | CA002L | 2024-09-12T12:11:23.126Z | 2024-09-15T12:21:36.619Z |
5034744 | 5034744 | 20240907075538_8rd4I | CA002L | 2024-09-12T12:11:19.091Z | 2024-09-15T12:21:36.297Z |
5034627 | 5034627 | 20240907072912_CaCuA | CA002L | 2024-09-12T12:11:08.306Z | 2024-09-15T12:21:35.334Z |
5034554 | 5034554 | 20240907071844_prkmn | CA002L | 2024-09-12T12:11:02.927Z | 2024-09-15T12:21:35.218Z |
5034546 | 5034546 | 20240907071648_KEDg3 | CA002L | 2024-09-12T12:11:01.841Z | 2024-09-15T12:21:35.181Z |
5034511 | 5034511 | 20240907071116_r3Bca | CA002L | 2024-09-12T12:10:59.690Z | 2024-09-15T12:21:34.866Z |
5034298 | 5034298 | 20240907062532_GM42Q | CA002L | 2024-09-12T12:10:49.534Z | 2024-09-15T12:21:33.574Z |
5034196 | 5034196 | 20240907060116_a2z5x | CA002L | 2024-09-12T12:10:44.466Z | 2024-09-15T12:21:33.063Z |
5034163 | 5034163 | 20240907054715_8Kq2u | CA002L | 2024-09-12T12:10:41.707Z | 2024-09-15T12:21:32.970Z |
5034087 | 5034087 | 20240907052844_ur02n | CA002L | 2024-09-12T12:10:31.971Z | 2024-09-15T12:21:32.800Z |
5034028 | 5034028 | 20240907050008_A8B5P | CA002L | 2024-09-12T12:10:24.445Z | 2024-09-15T12:21:32.616Z |
5033983 | 5033983 | 20240907044932_3YzHH | CA002L | 2024-09-12T12:10:17.304Z | 2024-09-15T12:21:32.525Z |
5033902 | 5033902 | 20240907041758_wvwH2 | CA002L | 2024-09-12T12:10:07.495Z | 2024-09-15T12:21:32.198Z |
5033860 | 5033860 | 20240907041029_CuTc5 | CA002L | 2024-09-12T12:10:02.840Z | 2024-09-15T12:21:32.033Z |
5033806 | 5033806 | 20240907035502_dhTi9 | CA002L | 2024-09-12T12:09:59.117Z | 2024-09-15T12:21:31.822Z |
5033794 | 5033794 | 20240907035157_uqkxu | CA002L | 2024-09-12T12:09:58.376Z | 2024-09-15T12:21:31.801Z |
5033790 | 5033790 | 20240907035110_2firA | CA002L | 2024-09-12T12:09:58.003Z | 2024-09-15T12:21:31.790Z |
5033758 | 5033758 | 20240907034305_bqmrU | CA002L | 2024-09-12T12:09:55.665Z | 2024-09-15T12:21:31.692Z |
5033583 | 5033583 | 20240907031353_H32c6 | CA002L | 2024-09-12T12:09:42.179Z | 2024-09-15T12:21:30.551Z |
5033397 | 5033397 | 20240907025502_4aJNr | CA002L | 2024-09-12T12:09:26.706Z | 2024-09-15T12:21:29.995Z |
5032811 | 5032811 | 20240907015049_RhTNj | CA002L | 2024-09-12T12:08:06.015Z | 2024-09-15T12:21:27.972Z |
5032683 | 5032683 | 20240907012925_FsUfu | CA002L | 2024-09-12T12:07:51.214Z | 2024-09-15T12:21:27.419Z |
5032649 | 5032649 | 20240907012540_oIXOV | CA002L | 2024-09-12T12:07:48.164Z | 2024-09-15T12:21:27.283Z |
5032502 | 5032502 | 20240907011020_60rEj | CA002L | 2024-09-12T12:07:25.583Z | 2024-09-15T12:21:26.642Z |
5032458 | 5032458 | 20240907010422_FnKvs | CA002L | 2024-09-12T12:07:20.479Z | 2024-09-15T12:21:26.482Z |
5032274 | 5032274 | 20240907003913_i9ttr | CA002L | 2024-09-12T12:07:02.249Z | 2024-09-15T12:21:25.786Z |
5027806 | 5027806 | 20240905082658_M4GLX | CA002L | 2024-09-11T12:14:31.780Z | 2024-09-13T12:20:04.740Z |
5027400 | 5027400 | 20240905073322_Qq5jq | CA002L | 2024-09-11T12:14:08.508Z | 2024-09-13T12:20:02.500Z |
5027270 | 5027270 | 20240905071650_0tPEe | CA002L | 2024-09-11T12:14:03.346Z | 2024-09-13T12:20:02.223Z |
5027213 | 5027213 | 20240905070550_pNQXL | CA002L | 2024-09-11T12:13:54.328Z | 2024-09-13T12:20:02.103Z |
5027121 | 5027121 | 20240905064825_wWG74 | CA002L | 2024-09-11T12:13:42.791Z | 2024-09-13T12:20:01.447Z |
5027108 | 5027108 | 20240905064507_8fDQy | CA002L | 2024-09-11T12:13:41.110Z | 2024-09-13T12:20:01.416Z |
5027067 | 5027067 | 20240905063040_TUM6x | CA002L | 2024-09-11T12:13:36.092Z | 2024-09-13T12:20:01.161Z |
5026982 | 5026982 | 20240905061141_Q3cgF | CA002L | 2024-09-11T12:13:27.447Z | 2024-09-13T12:20:00.673Z |
5026860 | 5026860 | 20240905054341_47bA2 | CA002L | 2024-09-11T12:13:15.421Z | 2024-09-13T12:20:00.089Z |
5026850 | 5026850 | 20240905054157_Q7ERz | CA002L | 2024-09-11T12:13:14.517Z | 2024-09-13T12:20:00.068Z |
5026803 | 5026803 | 20240905052652_Qy38Z | CA002L | 2024-09-11T12:13:09.391Z | 2024-09-13T12:19:59.786Z |
5026744 | 5026744 | 20240905050401_lIjtN | CA002L | 2024-09-11T12:13:02.980Z | 2024-09-13T12:19:59.594Z |
Advanced export
JSON shape: default, array, newline-delimited
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);