participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
606 rows where station_code = "CA002H" 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 |
---|---|---|---|---|---|
5134335 | 5134335 | 20240916081938_XWE08 | CA002H | 2024-09-19T12:17:37.309Z | 2024-09-19T12:17:37.309Z |
5134237 | 5134237 | 20240916072130_XWvS0 | CA002H | 2024-09-19T12:17:32.788Z | 2024-09-19T12:17:32.788Z |
5134204 | 5134204 | 20240916063912_ixB2I | CA002H | 2024-09-19T12:17:29.883Z | 2024-09-19T12:17:29.883Z |
5134078 | 5134078 | 20240916044314_xrnSV | CA002H | 2024-09-19T12:17:18.229Z | 2024-09-19T12:17:18.229Z |
5133534 | 5133534 | 20240916033653_i1YeS | CA002H | 2024-09-19T12:17:00.787Z | 2024-09-19T12:17:00.787Z |
5133286 | 5133286 | 20240916031823_7sgfV | CA002H | 2024-09-19T12:16:52.944Z | 2024-09-19T12:16:52.944Z |
5129896 | 5129896 | 20240917053847_wi2vw | CA002H | 2024-09-19T12:12:14.085Z | 2024-09-19T12:12:14.085Z |
5129855 | 5129855 | 20240917044249_aImA2 | CA002H | 2024-09-19T12:12:10.199Z | 2024-09-19T12:12:10.199Z |
5127983 | 5127983 | 20240917001559_SzHr3 | CA002H | 2024-09-19T12:09:52.172Z | 2024-09-19T12:09:52.172Z |
5126161 | 5126161 | 20240918085946_kk8O3 | CA002H | 2024-09-19T12:05:14.323Z | 2024-09-19T12:06:42.152Z |
5126133 | 5126133 | 20240918083609_kyLfD | CA002H | 2024-09-19T12:05:10.870Z | 2024-09-19T12:06:42.146Z |
5126014 | 5126014 | 20240918063251_iDUR6 | CA002H | 2024-09-19T12:04:44.837Z | 2024-09-19T12:06:42.124Z |
5125534 | 5125534 | 20240918025450_82K6E | CA002H | 2024-09-19T12:03:27.719Z | 2024-09-19T12:06:42.048Z |
5125364 | 5125364 | 20240918022108_G7DGH | CA002H | 2024-09-19T12:03:04.994Z | 2024-09-19T12:06:42.021Z |
5125080 | 5125080 | 20240917235949_0FY3v | CA002H | 2024-09-19T12:02:10.526Z | 2024-09-19T12:06:41.973Z |
5123130 | 5123130 | 20240914085824_HZEhT | CA002H | 2024-09-18T12:11:40.484Z | 2024-09-19T12:20:08.045Z |
5122878 | 5122878 | 20240914081518_3mRxo | CA002H | 2024-09-18T12:11:33.343Z | 2024-09-19T12:20:06.603Z |
5122470 | 5122470 | 20240914063250_lbb0V | CA002H | 2024-09-18T12:11:19.770Z | 2024-09-19T12:20:04.458Z |
5122282 | 5122282 | 20240914052311_qfQkI | CA002H | 2024-09-18T12:11:12.391Z | 2024-09-19T12:20:03.674Z |
5118407 | 5118407 | 20240915093813_pFw65 | CA002H | 2024-09-18T12:08:42.812Z | 2024-09-19T12:19:22.538Z |
5118039 | 5118039 | 20240915081239_TXuIg | CA002H | 2024-09-18T12:08:20.195Z | 2024-09-19T12:19:19.911Z |
5115984 | 5115984 | 20240915030158_C4E9z | CA002H | 2024-09-18T12:06:33.185Z | 2024-09-19T12:19:08.047Z |
5114337 | 5114337 | 20240915013718_d5wAJ | CA002H | 2024-09-18T12:05:11.428Z | 2024-09-19T12:18:57.595Z |
5108396 | 5108396 | 20240913052019_yluzT | CA002H | 2024-09-17T12:13:42.594Z | 2024-09-19T12:20:48.663Z |
5102820 | 5102820 | 20240914014657_XEz2O | CA002H | 2024-09-17T12:07:38.563Z | 2024-09-19T12:19:55.819Z |
5095009 | 5095009 | 20240912050853_QXVXP | CA002H | 2024-09-16T12:15:08.946Z | 2024-09-19T12:21:16.941Z |
5081813 | 5081813 | 20240911084607_J3x0X | CA002H | 2024-09-15T12:17:49.221Z | 2024-09-19T12:21:46.491Z |
5081565 | 5081565 | 20240911080234_fJqWS | CA002H | 2024-09-15T12:17:37.935Z | 2024-09-19T12:21:45.765Z |
5081122 | 5081122 | 20240911063917_q84Sw | CA002H | 2024-09-15T12:17:24.483Z | 2024-09-19T12:21:44.660Z |
5081105 | 5081105 | 20240911063610_bEzXb | CA002H | 2024-09-15T12:17:23.955Z | 2024-09-19T12:21:44.630Z |
5081021 | 5081021 | 20240911060231_tjhcf | CA002H | 2024-09-15T12:17:20.720Z | 2024-09-19T12:21:44.395Z |
5081006 | 5081006 | 20240911055857_XzAIN | CA002H | 2024-09-15T12:17:20.313Z | 2024-09-19T12:21:44.351Z |
5080916 | 5080916 | 20240911052559_doXxs | CA002H | 2024-09-15T12:17:17.271Z | 2024-09-19T12:21:44.041Z |
5080856 | 5080856 | 20240911050545_1gyon | CA002H | 2024-09-15T12:17:15.835Z | 2024-09-19T12:21:43.890Z |
5080828 | 5080828 | 20240911045813_iJWbv | CA002H | 2024-09-15T12:17:14.767Z | 2024-09-19T12:21:43.841Z |
5079239 | 5079239 | 20240911024319_wuVMs | CA002H | 2024-09-15T12:16:12.089Z | 2024-09-19T12:21:41.274Z |
5077175 | 5077175 | 20240911003007_2Rf1f | CA002H | 2024-09-15T12:14:27.274Z | 2024-09-19T12:21:38.313Z |
5067097 | 5067097 | 20240910085427_nqq3F | CA002H | 2024-09-14T12:18:30.388Z | 2024-09-18T12:15:23.371Z |
5067033 | 5067033 | 20240910084836_NT0So | CA002H | 2024-09-14T12:18:27.491Z | 2024-09-18T12:15:23.224Z |
5066515 | 5066515 | 20240910074318_cbLI7 | CA002H | 2024-09-14T12:17:59.934Z | 2024-09-18T12:15:22.111Z |
5066421 | 5066421 | 20240910072648_JwE5f | CA002H | 2024-09-14T12:17:55.751Z | 2024-09-18T12:15:21.861Z |
5066171 | 5066171 | 20240910064605_SdKTc | CA002H | 2024-09-14T12:17:43.021Z | 2024-09-18T12:15:21.292Z |
5065473 | 5065473 | 20240910041722_dZ7sj | CA002H | 2024-09-14T12:17:06.851Z | 2024-09-18T12:15:19.553Z |
5065463 | 5065463 | 20240910041431_tlaCL | CA002H | 2024-09-14T12:17:06.519Z | 2024-09-18T12:15:19.525Z |
5065181 | 5065181 | 20240910031733_QWzrF | CA002H | 2024-09-14T12:16:33.153Z | 2024-09-18T12:15:18.601Z |
5065015 | 5065015 | 20240910025240_qM4UN | CA002H | 2024-09-14T12:16:17.678Z | 2024-09-18T12:15:18.146Z |
5064412 | 5064412 | 20240910010042_uFuxp | CA002H | 2024-09-14T12:15:25.591Z | 2024-09-18T12:15:16.598Z |
5055002 | 5055002 | 20240908055655_AVpqC | CA002H | 2024-09-13T12:17:01.787Z | 2024-09-16T12:21:17.641Z |
5048728 | 5048728 | 20240909090049_anrI4 | CA002H | 2024-09-13T12:11:12.275Z | 2024-09-17T12:19:08.173Z |
5048663 | 5048663 | 20240909085004_cbl3U | CA002H | 2024-09-13T12:11:08.501Z | 2024-09-17T12:19:07.865Z |
5048496 | 5048496 | 20240909081813_9BG2Z | CA002H | 2024-09-13T12:10:41.946Z | 2024-09-17T12:19:07.240Z |
5040993 | 5040993 | 20240906065422_5PMv3 | CA002H | 2024-09-12T12:16:31.388Z | 2024-09-14T12:23:11.222Z |
5040655 | 5040655 | 20240906051939_obmGI | CA002H | 2024-09-12T12:16:18.675Z | 2024-09-14T12:23:10.216Z |
5040584 | 5040584 | 20240906045708_mAvgM | CA002H | 2024-09-12T12:16:16.880Z | 2024-09-14T12:23:09.978Z |
5040137 | 5040137 | 20240906030351_03e2b | CA002H | 2024-09-12T12:15:58.887Z | 2024-09-14T12:23:07.688Z |
5040091 | 5040091 | 20240906025757_abqYa | CA002H | 2024-09-12T12:15:58.053Z | 2024-09-14T12:23:07.445Z |
5033994 | 5033994 | 20240907045510_RUarv | CA002H | 2024-09-12T12:10:21.220Z | 2024-09-15T12:21:32.539Z |
5028288 | 5028288 | 20240905092431_Qnrh4 | CA002H | 2024-09-11T12:15:06.977Z | 2024-09-13T12:20:05.883Z |
5028286 | 5028286 | 20240905092252_NTSnu | CA002H | 2024-09-11T12:15:06.827Z | 2024-09-13T12:20:05.881Z |
5027573 | 5027573 | 20240905075424_3WUka | CA002H | 2024-09-11T12:14:17.800Z | 2024-09-13T12:20:03.816Z |
5027455 | 5027455 | 20240905074013_Mh8QH | CA002H | 2024-09-11T12:14:11.827Z | 2024-09-13T12:20:03.213Z |
5027226 | 5027226 | 20240905070832_J8uXF | CA002H | 2024-09-11T12:13:55.628Z | 2024-09-13T12:20:02.155Z |
5027201 | 5027201 | 20240905070333_aNYf1 | CA002H | 2024-09-11T12:13:51.607Z | 2024-09-13T12:20:01.918Z |
5027064 | 5027064 | 20240905063014_6AfIr | CA002H | 2024-09-11T12:13:35.701Z | 2024-09-13T12:20:01.155Z |
5026894 | 5026894 | 20240905055615_0RDT6 | CA002H | 2024-09-11T12:13:20.285Z | 2024-09-13T12:20:00.365Z |
5026761 | 5026761 | 20240905051902_2fUMQ | CA002H | 2024-09-11T12:13:04.662Z | 2024-09-13T12:19:59.652Z |
5022723 | 5022723 | 20240905092431_JCWq9 | CA002H | 2024-09-10T12:16:28.444Z | 2024-09-10T12:16:55.604Z |
5022721 | 5022721 | 20240905092252_Ex99m | CA002H | 2024-09-10T12:16:28.404Z | 2024-09-10T12:16:55.603Z |
5022019 | 5022019 | 20240905075424_yK1my | CA002H | 2024-09-10T12:16:01.712Z | 2024-09-10T12:16:55.478Z |
5021907 | 5021907 | 20240905074013_yKUpH | CA002H | 2024-09-10T12:15:56.226Z | 2024-09-10T12:16:55.458Z |
5021682 | 5021682 | 20240905070832_hA0lb | CA002H | 2024-09-10T12:15:46.321Z | 2024-09-10T12:16:55.420Z |
5021661 | 5021661 | 20240905070333_n0yAI | CA002H | 2024-09-10T12:15:45.318Z | 2024-09-10T12:16:55.416Z |
5021520 | 5021520 | 20240905063014_JBB2d | CA002H | 2024-09-10T12:15:37.512Z | 2024-09-13T12:20:01.160Z |
5021356 | 5021356 | 20240905055615_Wltnz | CA002H | 2024-09-10T12:15:27.913Z | 2024-09-10T12:16:55.359Z |
5021223 | 5021223 | 20240905051902_zg2Ww | CA002H | 2024-09-10T12:15:21.458Z | 2024-09-10T12:16:55.334Z |
5020672 | 5020672 | 20240905024514_d17G2 | CA002H | 2024-09-10T12:14:55.757Z | 2024-09-10T12:16:55.212Z |
5012997 | 5012997 | 20240903080807_JaZf3 | CA002H | 2024-09-09T12:18:23.527Z | 2024-09-11T12:21:19.534Z |
5012766 | 5012766 | 20240903073055_3YIpg | CA002H | 2024-09-09T12:18:15.888Z | 2024-09-11T12:21:18.755Z |
5012731 | 5012731 | 20240903072733_5R9xV | CA002H | 2024-09-09T12:18:14.074Z | 2024-09-11T12:21:18.672Z |
5012008 | 5012008 | 20240904082727_P7Y87 | CA002H | 2024-09-09T12:10:17.134Z | 2024-09-12T12:19:34.494Z |
5011771 | 5011771 | 20240904074942_WvzrJ | CA002H | 2024-09-09T12:10:00.770Z | 2024-09-12T12:19:33.357Z |
5011534 | 5011534 | 20240904070540_jRVwV | CA002H | 2024-09-09T12:09:50.617Z | 2024-09-12T12:19:32.261Z |
5011530 | 5011530 | 20240904070537_304k7 | CA002H | 2024-09-09T12:09:50.336Z | 2024-09-12T12:19:32.259Z |
5011471 | 5011471 | 20240904064710_2r633 | CA002H | 2024-09-09T12:09:42.287Z | 2024-09-12T12:19:31.975Z |
5011152 | 5011152 | 20240904051330_Z2lar | CA002H | 2024-09-09T12:09:27.247Z | 2024-09-12T12:19:30.568Z |
5011002 | 5011002 | 20240904041936_IcP4c | CA002H | 2024-09-09T12:09:18.874Z | 2024-09-12T12:19:30.087Z |
5010802 | 5010802 | 20240904034737_wrlhP | CA002H | 2024-09-09T12:09:02.401Z | 2024-09-12T12:19:29.083Z |
5003592 | 5003592 | 20240903091952_dcLw2 | CA002H | 2024-09-09T12:01:53.153Z | 2024-09-12T12:18:58.003Z |
5002053 | 5002053 | 20240902073418_DxFok | CA002H | 2024-09-08T12:17:08.428Z | 2024-09-10T12:19:35.984Z |
5001973 | 5001973 | 20240902072250_2qT3I | CA002H | 2024-09-08T12:17:05.265Z | 2024-09-10T12:19:35.770Z |
5001946 | 5001946 | 20240902071507_fE3Rr | CA002H | 2024-09-08T12:17:03.901Z | 2024-09-10T12:19:35.590Z |
5001775 | 5001775 | 20240902063820_SH3C6 | CA002H | 2024-09-08T12:16:57.272Z | 2024-09-10T12:19:34.560Z |
4999128 | 4999128 | 20240903052757_Gae9h | CA002H | 2024-09-08T12:08:30.443Z | 2024-09-11T12:21:16.492Z |
4999067 | 4999067 | 20240903051749_cch6B | CA002H | 2024-09-08T12:08:28.204Z | 2024-09-11T12:21:16.285Z |
4999023 | 4999023 | 20240903050401_j0B5I | CA002H | 2024-09-08T12:08:19.513Z | 2024-09-11T12:21:16.012Z |
4997841 | 4997841 | 20240903013315_399Qc | CA002H | 2024-09-08T12:06:52.074Z | 2024-09-11T12:21:09.430Z |
4992252 | 4992252 | 20240901064726_NlM4m | CA002H | 2024-09-07T12:13:07.260Z | 2024-09-09T12:27:57.720Z |
4992175 | 4992175 | 20240901061244_nC1Ls | CA002H | 2024-09-07T12:13:00.154Z | 2024-09-09T12:27:53.684Z |
4983965 | 4983965 | 20240901083438_cS4Ry | CA002H | 2024-09-07T12:01:09.414Z | 2024-09-10T12:19:03.994Z |
4983584 | 4983584 | 20240901071201_Yigk4 | CA002H | 2024-09-07T12:00:22.122Z | 2024-09-10T12:19:02.009Z |
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);