participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
335 rows where station_code = "CA001Z" 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 |
---|---|---|---|---|---|
4223899 | 4223899 | 20240420095237_uN1V1 | CA001Z | 2024-04-22T12:04:48.091Z | 2024-04-28T12:21:36.091Z |
4223710 | 4223710 | 20240420044723_shZlc | CA001Z | 2024-04-22T12:04:10.213Z | 2024-04-28T12:21:30.290Z |
4180770 | 4180770 | 20240413083357_7Bcgm | CA001Z | 2024-04-14T12:06:01.414Z | 2024-04-21T12:21:54.649Z |
4177077 | 4177077 | 20240411062505_rOcoh | CA001Z | 2024-04-13T12:11:00.456Z | 2024-04-19T12:13:21.087Z |
4177053 | 4177053 | 20240411054604_jYL4s | CA001Z | 2024-04-13T12:10:57.184Z | 2024-04-19T12:13:20.970Z |
4172559 | 4172559 | 20240410074526_1aikc | CA001Z | 2024-04-12T12:09:51.974Z | 2024-04-18T12:21:27.524Z |
4172519 | 4172519 | 20240410073151_Erkv0 | CA001Z | 2024-04-12T12:09:44.702Z | 2024-04-18T12:21:27.137Z |
4172300 | 4172300 | 20240410054635_1v2sC | CA001Z | 2024-04-12T12:09:07.794Z | 2024-04-18T12:21:24.461Z |
4167605 | 4167605 | 20240409111242_LizEp | CA001Z | 2024-04-11T12:09:35.823Z | 2024-04-17T12:21:26.187Z |
4167401 | 4167401 | 20240409092450_iFYPH | CA001Z | 2024-04-11T12:09:16.497Z | 2024-04-17T12:21:22.805Z |
4088079 | 4088079 | 20240317074821_L6psW | CA001Z | 2024-03-19T12:13:30.366Z | 2024-03-25T12:22:29.945Z |
4087964 | 4087964 | 20240317053922_3EFRB | CA001Z | 2024-03-19T12:13:21.732Z | 2024-03-25T12:22:26.460Z |
4086944 | 4086944 | 20240318060949_Eg3rL | CA001Z | 2024-03-19T12:09:17.516Z | 2024-03-26T12:21:12.790Z |
4082832 | 4082832 | 20240317115949_ZXt1v | CA001Z | 2024-03-19T12:00:58.961Z | 2024-03-26T12:20:27.896Z |
4072374 | 4072374 | 20240314083627_03roD | CA001Z | 2024-03-16T12:12:38.221Z | 2024-03-22T12:17:44.764Z |
4068793 | 4068793 | 20240313094103_FRfum | CA001Z | 2024-03-15T12:09:30.267Z | 2024-03-21T12:22:25.066Z |
4046098 | 4046098 | 20240308022450_VwNM3 | CA001Z | 2024-03-09T14:09:13.064Z | 2024-03-16T12:21:38.289Z |
4003364 | 4003364 | 20240226035123_VFv1A | CA001Z | 2024-02-27T14:02:42.797Z | 2024-03-05T14:18:54.241Z |
4000381 | 4000381 | 20240223103252_IQOY0 | CA001Z | 2024-02-24T14:07:29.053Z | 2024-03-02T14:20:55.425Z |
3987312 | 3987312 | 20240219124439_3vgeh | CA001Z | 2024-02-20T14:00:50.886Z | 2024-02-28T14:13:51.988Z |
3986931 | 3986931 | 20240218023634_l9m9a | CA001Z | 2024-02-19T14:09:30.844Z | 2024-02-26T14:17:00.845Z |
3986882 | 3986882 | 20240218120205_niPLB | CA001Z | 2024-02-19T14:09:17.044Z | 2024-02-26T14:17:55.113Z |
3986461 | 3986461 | 20240218091857_monuA | CA001Z | 2024-02-19T14:08:22.361Z | 2024-02-26T14:17:34.274Z |
3982382 | 3982382 | 20240217091810_3Jcef | CA001Z | 2024-02-18T14:08:44.714Z | 2024-02-25T14:19:08.279Z |
3976526 | 3976526 | 20240216064704_xujsr | CA001Z | 2024-02-17T14:08:18.419Z | 2024-02-24T14:24:01.281Z |
3976367 | 3976367 | 20240216052923_L0v2c | CA001Z | 2024-02-17T14:07:55.841Z | 2024-02-24T14:23:54.779Z |
3973337 | 3973337 | 20240214125130_GivsK | CA001Z | 2024-02-16T14:12:50.454Z | 2024-02-22T14:25:08.029Z |
3944715 | 3944715 | 20240210115408_qP0pZ | CA001Z | 2024-02-11T14:08:38.213Z | 2024-02-18T14:22:20.473Z |
3944620 | 3944620 | 20240210105817_JL89P | CA001Z | 2024-02-11T14:08:29.850Z | 2024-02-18T14:22:19.900Z |
3944478 | 3944478 | 20240210071121_dQzRI | CA001Z | 2024-02-11T14:07:57.701Z | 2024-02-18T14:22:18.946Z |
3910066 | 3910066 | 20240202120758_zgP9J | CA001Z | 2024-02-03T14:07:03.417Z | 2024-02-10T14:25:12.668Z |
3909983 | 3909983 | 20240202114033_IFCWz | CA001Z | 2024-02-03T14:06:52.633Z | 2024-02-10T14:25:11.419Z |
3907184 | 3907184 | 20240201123303_1Z423 | CA001Z | 2024-02-02T14:07:40.182Z | 2024-02-09T14:20:39.063Z |
3907002 | 3907002 | 20240201095640_H9SYP | CA001Z | 2024-02-02T14:07:12.817Z | 2024-02-09T14:20:34.249Z |
3902763 | 3902763 | 20240131110114_6nqau | CA001Z | 2024-02-01T14:06:51.806Z | 2024-02-08T14:20:29.845Z |
3902574 | 3902574 | 20240131100543_zCyN8 | CA001Z | 2024-02-01T14:06:25.347Z | 2024-02-08T14:20:28.186Z |
3899189 | 3899189 | 20240130124324_Q6kg8 | CA001Z | 2024-01-31T14:07:19.257Z | 2024-02-07T14:22:38.242Z |
3887460 | 3887460 | 20240126130143_RiWGr | CA001Z | 2024-01-27T14:03:12.551Z | 2024-02-03T14:24:37.438Z |
3887265 | 3887265 | 20240126102434_iXTeZ | CA001Z | 2024-01-27T14:02:19.280Z | 2024-02-03T14:24:30.412Z |
3887251 | 3887251 | 20240126101032_Xi26J | CA001Z | 2024-01-27T14:02:16.664Z | 2024-02-03T14:24:29.828Z |
3887168 | 3887168 | 20240126070112_aQKPv | CA001Z | 2024-01-27T14:01:56.829Z | 2024-02-03T14:24:27.353Z |
3886970 | 3886970 | 20240126052826_YQ2kc | CA001Z | 2024-01-27T14:01:29.026Z | 2024-02-03T14:24:21.527Z |
3885172 | 3885172 | 20240124121655_S5fKq | CA001Z | 2024-01-26T14:05:24.180Z | 2024-02-01T14:18:07.976Z |
3885054 | 3885054 | 20240124104246_PPAPa | CA001Z | 2024-01-26T14:05:10.059Z | 2024-02-01T14:18:04.742Z |
3834161 | 3834161 | 20240115135517_5EVUy | CA001Z | 2024-01-18T14:09:58.303Z | 2024-01-24T14:18:56.604Z |
3832625 | 3832625 | 20240115103216_dSOZE | CA001Z | 2024-01-18T14:06:34.043Z | 2024-01-24T14:18:43.676Z |
3832399 | 3832399 | 20240115093157_YQPNv | CA001Z | 2024-01-18T14:05:56.378Z | 2024-01-24T14:18:40.316Z |
3828164 | 3828164 | 20240114111341_MQhJ7 | CA001Z | 2024-01-17T14:10:11.392Z | 2024-01-23T14:25:00.400Z |
3827998 | 3827998 | 20240114093116_BndmR | CA001Z | 2024-01-17T14:09:42.049Z | 2024-01-23T14:24:57.401Z |
3782248 | 3782248 | 20240108141527_Zk0vl | CA001Z | 2024-01-11T14:08:43.537Z | 2024-01-17T14:23:30.131Z |
3781646 | 3781646 | 20240108122014_HwVjz | CA001Z | 2024-01-11T14:07:18.371Z | 2024-01-17T14:23:27.250Z |
3780761 | 3780761 | 20240108081455_LDTVl | CA001Z | 2024-01-11T14:04:36.416Z | 2024-01-17T14:23:22.016Z |
3780735 | 3780735 | 20240108080029_dTpMa | CA001Z | 2024-01-11T14:04:32.064Z | 2024-01-17T14:23:21.883Z |
3780652 | 3780652 | 20240108065636_TKJKw | CA001Z | 2024-01-11T14:04:11.072Z | 2024-01-17T14:23:21.269Z |
3757339 | 3757339 | 20240106082034_iIuM0 | CA001Z | 2024-01-08T14:03:55.254Z | 2024-01-15T14:23:49.286Z |
3757178 | 3757178 | 20240106070847_kfeEV | CA001Z | 2024-01-08T14:03:18.183Z | 2024-01-15T14:23:47.470Z |
3753064 | 3753064 | 20240104142753_OfeOV | CA001Z | 2024-01-07T14:07:03.214Z | 2024-01-13T14:26:00.237Z |
3753047 | 3753047 | 20240104142417_LbxHE | CA001Z | 2024-01-07T14:07:00.674Z | 2024-01-13T14:26:00.193Z |
3753044 | 3753044 | 20240104142106_4IVGe | CA001Z | 2024-01-07T14:07:00.196Z | 2024-01-13T14:26:00.184Z |
3753032 | 3753032 | 20240104141853_PqY2y | CA001Z | 2024-01-07T14:06:58.761Z | 2024-01-13T14:26:00.182Z |
3752989 | 3752989 | 20240104140808_KAC02 | CA001Z | 2024-01-07T14:06:51.031Z | 2024-01-13T14:25:59.942Z |
3752979 | 3752979 | 20240104140307_r4bE3 | CA001Z | 2024-01-07T14:06:49.666Z | 2024-01-13T14:25:59.774Z |
3752977 | 3752977 | 20240104140205_sGda0 | CA001Z | 2024-01-07T14:06:49.551Z | 2024-01-13T14:25:59.773Z |
3752957 | 3752957 | 20240104135833_mrgXP | CA001Z | 2024-01-07T14:06:45.874Z | 2024-01-13T14:25:59.638Z |
3752934 | 3752934 | 20240104135303_83283 | CA001Z | 2024-01-07T14:06:40.831Z | 2024-01-13T14:25:59.600Z |
3752904 | 3752904 | 20240104134355_9AB3g | CA001Z | 2024-01-07T14:06:35.154Z | 2024-01-13T14:25:59.544Z |
3752877 | 3752877 | 20240104133842_GUs9o | CA001Z | 2024-01-07T14:06:30.130Z | 2024-01-13T14:25:59.433Z |
3752837 | 3752837 | 20240104133223_wJD4L | CA001Z | 2024-01-07T14:06:24.482Z | 2024-01-13T14:25:59.244Z |
3752835 | 3752835 | 20240104133142_MDBJ0 | CA001Z | 2024-01-07T14:06:24.183Z | 2024-01-13T14:25:59.234Z |
3752714 | 3752714 | 20240104131651_rc4yB | CA001Z | 2024-01-07T14:06:07.017Z | 2024-01-13T14:25:58.746Z |
3752686 | 3752686 | 20240104131157_9Hc8B | CA001Z | 2024-01-07T14:06:00.724Z | 2024-01-13T14:25:58.639Z |
3752650 | 3752650 | 20240104130642_w50M8 | CA001Z | 2024-01-07T14:05:54.681Z | 2024-01-13T14:25:58.538Z |
3752635 | 3752635 | 20240104130409_WOLZU | CA001Z | 2024-01-07T14:05:51.316Z | 2024-01-13T14:25:58.506Z |
3752597 | 3752597 | 20240104130025_w37fW | CA001Z | 2024-01-07T14:05:46.402Z | 2024-01-13T14:25:58.290Z |
3752524 | 3752524 | 20240104125256_93rDR | CA001Z | 2024-01-07T14:05:38.954Z | 2024-01-13T14:25:58.055Z |
3752511 | 3752511 | 20240104125137_WOt23 | CA001Z | 2024-01-07T14:05:38.142Z | 2024-01-13T14:25:57.926Z |
3752447 | 3752447 | 20240104123854_7eM2l | CA001Z | 2024-01-07T14:05:31.207Z | 2024-01-13T14:25:57.520Z |
3752391 | 3752391 | 20240104122950_D4bVc | CA001Z | 2024-01-07T14:05:23.403Z | 2024-01-13T14:25:57.385Z |
3752234 | 3752234 | 20240104121121_HcWtd | CA001Z | 2024-01-07T14:04:57.680Z | 2024-01-13T14:25:56.771Z |
3752216 | 3752216 | 20240104120942_uoiob | CA001Z | 2024-01-07T14:04:52.883Z | 2024-01-13T14:25:56.586Z |
3752193 | 3752193 | 20240104120700_xsQRU | CA001Z | 2024-01-07T14:04:49.315Z | 2024-01-13T14:25:56.481Z |
3752159 | 3752159 | 20240104120245_pvQy8 | CA001Z | 2024-01-07T14:04:46.514Z | 2024-01-13T14:25:56.350Z |
3752150 | 3752150 | 20240104120156_CH7Y1 | CA001Z | 2024-01-07T14:04:45.810Z | 2024-01-13T14:25:56.336Z |
3752101 | 3752101 | 20240104115239_LXyOq | CA001Z | 2024-01-07T14:04:40.127Z | 2024-01-13T14:25:56.093Z |
3751910 | 3751910 | 20240104112308_tsMIb | CA001Z | 2024-01-07T14:04:11.401Z | 2024-01-13T14:25:54.196Z |
3751690 | 3751690 | 20240104095440_fmImb | CA001Z | 2024-01-07T14:03:37.384Z | 2024-01-13T14:25:52.328Z |
3751558 | 3751558 | 20240104085221_DcEUD | CA001Z | 2024-01-07T14:03:10.093Z | 2024-01-13T14:25:50.757Z |
3751553 | 3751553 | 20240104085035_Ln62F | CA001Z | 2024-01-07T14:03:09.847Z | 2024-01-13T14:25:50.754Z |
3751532 | 3751532 | 20240104083153_fVgUG | CA001Z | 2024-01-07T14:03:06.742Z | 2024-01-13T14:25:50.642Z |
3751512 | 3751512 | 20240104080845_jb4NT | CA001Z | 2024-01-07T14:03:04.256Z | 2024-01-13T14:25:50.371Z |
3751496 | 3751496 | 20240104073946_QObqZ | CA001Z | 2024-01-07T14:03:01.463Z | 2024-01-13T14:25:50.142Z |
3751484 | 3751484 | 20240104072748_RVnYm | CA001Z | 2024-01-07T14:03:00.365Z | 2024-01-13T14:25:50.067Z |
3744878 | 3744878 | 20240104061120_GbrQs | CA001Z | 2024-01-06T14:01:55.020Z | 2024-01-13T14:25:46.606Z |
3723979 | 3723979 | 20231230084143_CWPRu | CA001Z | 2024-01-06T00:06:07.240Z | 2024-01-08T14:25:04.811Z |
3720925 | 3720925 | 20231229062229_GhQIE | CA001Z | 2024-01-06T00:06:04.269Z | 2024-01-06T14:21:15.168Z |
3720815 | 3720815 | 20231229055935_RDZXr | CA001Z | 2024-01-06T00:06:04.260Z | 2024-01-06T14:21:13.168Z |
3718540 | 3718540 | 20231227103901_7cVGW | CA001Z | 2024-01-06T00:06:02.717Z | 2024-01-06T01:01:35.298Z |
3718148 | 3718148 | 20231227045555_UyPsb | CA001Z | 2024-01-06T00:06:01.349Z | 2024-01-06T00:06:01.349Z |
3717659 | 3717659 | 20231226134943_7XsZr | CA001Z | 2024-01-06T00:06:01.267Z | 2024-01-06T00:06:01.267Z |
3716565 | 3716565 | 20231226052941_w5Q9D | CA001Z | 2024-01-06T00:05:59.676Z | 2024-01-06T00:05:59.676Z |
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);