participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,335 rows where station_code = "CA002U" 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 |
---|---|---|---|---|---|
5583958 | 5583958 | 20241117085339_1VqFr | CA002U | 2024-11-23T14:25:15.391Z | 2024-11-23T14:25:15.391Z |
5583956 | 5583956 | 20241117085339_jHJtb | CA002U | 2024-11-23T14:25:15.357Z | 2024-11-23T14:25:15.357Z |
5561992 | 5561992 | 20241119224119_R2W39 | CA002U | 2024-11-21T14:14:18.519Z | 2024-11-23T14:24:27.158Z |
5561934 | 5561934 | 20241119223514_ckBNU | CA002U | 2024-11-21T14:14:15.550Z | 2024-11-23T14:24:26.905Z |
5557228 | 5557228 | 20241119044054_5ZJpP | CA002U | 2024-11-20T14:12:29.218Z | 2024-11-23T14:25:10.784Z |
5554792 | 5554792 | 20241119104041_kpPpQ | CA002U | 2024-11-20T14:03:18.570Z | 2024-11-23T14:24:08.493Z |
5554661 | 5554661 | 20241119100156_n538P | CA002U | 2024-11-20T14:02:57.828Z | 2024-11-23T14:24:07.062Z |
5554641 | 5554641 | 20241119095323_23Nd2 | CA002U | 2024-11-20T14:02:54.353Z | 2024-11-23T14:24:06.593Z |
5554613 | 5554613 | 20241119094818_1P36r | CA002U | 2024-11-20T14:02:41.483Z | 2024-11-23T14:24:06.316Z |
5554600 | 5554600 | 20241119094657_Qm5wS | CA002U | 2024-11-20T14:02:36.007Z | 2024-11-23T14:24:06.181Z |
5554595 | 5554595 | 20241119094413_FTJCN | CA002U | 2024-11-20T14:02:34.538Z | 2024-11-23T14:24:06.137Z |
5554238 | 5554238 | 20241119072053_LsL6O | CA002U | 2024-11-20T14:01:13.312Z | 2024-11-23T14:24:00.430Z |
5554213 | 5554213 | 20241119071117_kQjvn | CA002U | 2024-11-20T14:01:09.182Z | 2024-11-23T14:23:59.951Z |
5554175 | 5554175 | 20241119064955_hoYwb | CA002U | 2024-11-20T14:01:00.984Z | 2024-11-23T14:23:59.101Z |
5554123 | 5554123 | 20241119061836_lPOUY | CA002U | 2024-11-20T14:00:48.402Z | 2024-11-23T14:23:58.662Z |
5554088 | 5554088 | 20241119060502_AsT11 | CA002U | 2024-11-20T14:00:42.289Z | 2024-11-23T14:23:58.289Z |
5554041 | 5554041 | 20241119054053_gFt7k | CA002U | 2024-11-20T14:00:32.531Z | 2024-11-23T14:23:57.891Z |
5554003 | 5554003 | 20241119052139_eUTCS | CA002U | 2024-11-20T14:00:22.135Z | 2024-11-23T14:23:57.438Z |
5553979 | 5553979 | 20241119050601_yogMa | CA002U | 2024-11-20T14:00:16.876Z | 2024-11-23T14:23:56.410Z |
5553974 | 5553974 | 20241119050313_YtRGY | CA002U | 2024-11-20T14:00:15.757Z | 2024-11-23T14:23:55.951Z |
5553946 | 5553946 | 20241119044434_G0tZQ | CA002U | 2024-11-20T14:00:08.711Z | 2024-11-23T14:23:55.584Z |
5549498 | 5549498 | 20241117050733_x0IYD | CA002U | 2024-11-18T14:11:46.124Z | 2024-11-23T14:25:44.485Z |
5549156 | 5549156 | 20241117032813_ztv4q | CA002U | 2024-11-18T14:11:09.911Z | 2024-11-23T14:25:43.274Z |
5549139 | 5549139 | 20241117032139_ad6G7 | CA002U | 2024-11-18T14:11:04.831Z | 2024-11-23T14:25:43.240Z |
5549120 | 5549120 | 20241117031503_8YyVu | CA002U | 2024-11-18T14:11:00.496Z | 2024-11-23T14:25:43.206Z |
5548860 | 5548860 | 20241117015934_ktupM | CA002U | 2024-11-18T14:10:20.654Z | 2024-11-23T14:25:41.772Z |
5548474 | 5548474 | 20241116234543_6I5KO | CA002U | 2024-11-18T14:09:18.529Z | 2024-11-23T14:25:40.426Z |
5548392 | 5548392 | 20241116230532_VEEMT | CA002U | 2024-11-18T14:09:06.906Z | 2024-11-23T14:25:40.088Z |
5545853 | 5545853 | 20241117072559_2m6Pp | CA002U | 2024-11-18T14:01:12.099Z | 2024-11-23T14:25:14.178Z |
5545736 | 5545736 | 20241117062812_GI2U3 | CA002U | 2024-11-18T14:00:48.852Z | 2024-11-23T14:25:13.306Z |
5545680 | 5545680 | 20241117061035_tFyZo | CA002U | 2024-11-18T14:00:38.364Z | 2024-11-23T14:25:13.101Z |
5545661 | 5545661 | 20241117060500_ZMnlo | CA002U | 2024-11-18T14:00:34.416Z | 2024-11-23T14:25:13.032Z |
5545526 | 5545526 | 20241117050853_MDgJv | CA002U | 2024-11-18T14:00:11.071Z | 2024-11-23T14:25:12.492Z |
5545362 | 5545362 | 20241116051023_0Wqz2 | CA002U | 2024-11-17T14:04:31.667Z | 2024-11-23T14:25:59.227Z |
5545354 | 5545354 | 20241116045639_9SeHx | CA002U | 2024-11-17T14:04:30.765Z | 2024-11-23T14:25:59.210Z |
5545287 | 5545287 | 20241116035710_b0EHh | CA002U | 2024-11-17T14:04:23.935Z | 2024-11-23T14:25:58.465Z |
5545271 | 5545271 | 20241116035131_4O3nc | CA002U | 2024-11-17T14:04:22.393Z | 2024-11-23T14:25:58.396Z |
5545138 | 5545138 | 20241116011921_kjLvl | CA002U | 2024-11-17T14:03:53.280Z | 2024-11-23T14:25:55.982Z |
5545071 | 5545071 | 20241115231648_ChYVI | CA002U | 2024-11-17T14:03:44.194Z | 2024-11-23T14:25:55.117Z |
5543690 | 5543690 | 20241115025945_PTy6u | CA002U | 2024-11-16T14:07:01.775Z | 2024-11-23T14:26:20.366Z |
5541745 | 5541745 | 20241114041717_T8olm | CA002U | 2024-11-15T14:08:19.784Z | 2024-11-22T14:24:20.090Z |
5541629 | 5541629 | 20241114032404_wEVtp | CA002U | 2024-11-15T14:07:59.458Z | 2024-11-22T14:24:19.708Z |
5541361 | 5541361 | 20241114005826_5nLLR | CA002U | 2024-11-15T14:07:30.890Z | 2024-11-22T14:24:18.326Z |
5541347 | 5541347 | 20241114004303_daWkf | CA002U | 2024-11-15T14:07:29.714Z | 2024-11-22T14:24:18.276Z |
5541264 | 5541264 | 20241113225626_sNAd0 | CA002U | 2024-11-15T14:07:16.679Z | 2024-11-22T14:24:17.598Z |
5540362 | 5540362 | 20241114104440_1N0s2 | CA002U | 2024-11-15T14:03:30.158Z | 2024-11-23T14:26:11.072Z |
5540071 | 5540071 | 20241114100018_7Htu1 | CA002U | 2024-11-15T14:02:49.394Z | 2024-11-23T14:26:08.936Z |
5539987 | 5539987 | 20241114094322_YpVWf | CA002U | 2024-11-15T14:02:29.252Z | 2024-11-23T14:26:08.319Z |
5539858 | 5539858 | 20241114091619_9U96c | CA002U | 2024-11-15T14:02:13.203Z | 2024-11-23T14:26:07.321Z |
5539806 | 5539806 | 20241114090415_JXzBw | CA002U | 2024-11-15T14:02:01.909Z | 2024-11-23T14:26:06.924Z |
5539718 | 5539718 | 20241114084419_Lfk8y | CA002U | 2024-11-15T14:01:44.977Z | 2024-11-23T14:26:06.040Z |
5539604 | 5539604 | 20241114080647_SD8oj | CA002U | 2024-11-15T14:01:31.138Z | 2024-11-23T14:26:04.934Z |
5539062 | 5539062 | 20241113053921_Xd1Qh | CA002U | 2024-11-14T14:14:10.526Z | 2024-11-21T14:26:31.101Z |
5539058 | 5539058 | 20241113053831_BDYfl | CA002U | 2024-11-14T14:14:10.272Z | 2024-11-21T14:26:31.084Z |
5538976 | 5538976 | 20241113052702_g4949 | CA002U | 2024-11-14T14:14:06.354Z | 2024-11-21T14:26:30.556Z |
5538974 | 5538974 | 20241113052633_F7ls6 | CA002U | 2024-11-14T14:14:06.153Z | 2024-11-21T14:26:30.551Z |
5538780 | 5538780 | 20241113045627_ymkYR | CA002U | 2024-11-14T14:13:57.087Z | 2024-11-21T14:26:28.710Z |
5538645 | 5538645 | 20241113043040_Cb1AI | CA002U | 2024-11-14T14:13:46.208Z | 2024-11-21T14:26:28.334Z |
5538489 | 5538489 | 20241113035554_vw2kv | CA002U | 2024-11-14T14:13:32.655Z | 2024-11-21T14:26:26.594Z |
5538397 | 5538397 | 20241113032750_oLlCU | CA002U | 2024-11-14T14:13:23.152Z | 2024-11-21T14:26:25.222Z |
5538341 | 5538341 | 20241113031628_MLMSs | CA002U | 2024-11-14T14:13:17.138Z | 2024-11-21T14:26:23.986Z |
5538329 | 5538329 | 20241113031400_rzm2z | CA002U | 2024-11-14T14:13:15.808Z | 2024-11-21T14:26:23.504Z |
5538124 | 5538124 | 20241113021521_tlQFt | CA002U | 2024-11-14T14:12:52.739Z | 2024-11-21T14:26:20.873Z |
5538019 | 5538019 | 20241113015435_DrrUS | CA002U | 2024-11-14T14:12:43.183Z | 2024-11-21T14:26:18.857Z |
5537909 | 5537909 | 20241113012546_DXuew | CA002U | 2024-11-14T14:12:36.908Z | 2024-11-21T14:26:16.870Z |
5537772 | 5537772 | 20241113003307_88kHR | CA002U | 2024-11-14T14:12:29.479Z | 2024-11-21T14:26:15.882Z |
5537650 | 5537650 | 20241112235838_7Ua4M | CA002U | 2024-11-14T14:12:22.223Z | 2024-11-21T14:26:15.079Z |
5537387 | 5537387 | 20241112223418_ic86E | CA002U | 2024-11-14T14:11:43.386Z | 2024-11-21T14:26:11.842Z |
5534026 | 5534026 | 20241113104259_KBrr6 | CA002U | 2024-11-14T14:03:27.544Z | 2024-11-22T14:24:12.012Z |
5533851 | 5533851 | 20241113101826_mChmG | CA002U | 2024-11-14T14:03:01.789Z | 2024-11-22T14:24:11.531Z |
5533829 | 5533829 | 20241113101632_uu0yw | CA002U | 2024-11-14T14:02:57.617Z | 2024-11-22T14:24:11.445Z |
5533683 | 5533683 | 20241113094439_GyGwl | CA002U | 2024-11-14T14:02:37.480Z | 2024-11-22T14:24:10.704Z |
5533459 | 5533459 | 20241113090133_VjryN | CA002U | 2024-11-14T14:02:02.610Z | 2024-11-22T14:24:09.435Z |
5533411 | 5533411 | 20241113085056_8d8Qn | CA002U | 2024-11-14T14:01:55.002Z | 2024-11-22T14:24:09.033Z |
5533405 | 5533405 | 20241113084839_Q74To | CA002U | 2024-11-14T14:01:54.059Z | 2024-11-22T14:24:09.012Z |
5533398 | 5533398 | 20241113084757_WT25S | CA002U | 2024-11-14T14:01:53.373Z | 2024-11-22T14:24:08.972Z |
5518128 | 5518128 | 20241110060506_NAfPb | CA002U | 2024-11-11T14:15:14.921Z | 2024-11-18T14:26:39.614Z |
5518115 | 5518115 | 20241110060302_HkBAS | CA002U | 2024-11-11T14:15:13.902Z | 2024-11-18T14:26:39.583Z |
5518089 | 5518089 | 20241110055815_VemtQ | CA002U | 2024-11-11T14:15:12.167Z | 2024-11-18T14:26:39.499Z |
5517968 | 5517968 | 20241110052503_QQUmB | CA002U | 2024-11-11T14:15:05.521Z | 2024-11-18T14:26:39.065Z |
5517903 | 5517903 | 20241110051145_3cAJX | CA002U | 2024-11-11T14:15:00.385Z | 2024-11-18T14:26:38.841Z |
5517835 | 5517835 | 20241110045927_EeI1E | CA002U | 2024-11-11T14:14:55.434Z | 2024-11-18T14:26:38.558Z |
5517822 | 5517822 | 20241110045258_8gsUi | CA002U | 2024-11-11T14:14:54.524Z | 2024-11-18T14:26:38.505Z |
5517816 | 5517816 | 20241110045127_go1g8 | CA002U | 2024-11-11T14:14:53.871Z | 2024-11-18T14:26:38.437Z |
5517724 | 5517724 | 20241110043752_5XA3K | CA002U | 2024-11-11T14:14:46.750Z | 2024-11-18T14:26:37.968Z |
5517701 | 5517701 | 20241110043228_l2PVp | CA002U | 2024-11-11T14:14:45.977Z | 2024-11-18T14:26:37.902Z |
5517699 | 5517699 | 20241110043226_3E5yl | CA002U | 2024-11-11T14:14:45.824Z | 2024-11-18T14:26:37.883Z |
5517563 | 5517563 | 20241110040238_Iyb0v | CA002U | 2024-11-11T14:14:35.217Z | 2024-11-18T14:26:37.151Z |
5517110 | 5517110 | 20241110024928_3GCW6 | CA002U | 2024-11-11T14:13:56.234Z | 2024-11-18T14:26:34.787Z |
5517084 | 5517084 | 20241110024552_jOKce | CA002U | 2024-11-11T14:13:51.824Z | 2024-11-18T14:26:34.663Z |
5516576 | 5516576 | 20241110012344_4OdQi | CA002U | 2024-11-11T14:13:09.588Z | 2024-11-18T14:26:32.103Z |
5516339 | 5516339 | 20241110004309_XG0q3 | CA002U | 2024-11-11T14:12:48.292Z | 2024-11-18T14:26:30.732Z |
5516194 | 5516194 | 20241110001131_LUFiV | CA002U | 2024-11-11T14:12:26.208Z | 2024-11-18T14:26:30.035Z |
5515880 | 5515880 | 20241109230255_D0dsA | CA002U | 2024-11-11T14:11:42.386Z | 2024-11-18T14:26:28.319Z |
5512671 | 5512671 | 20241110092714_gRnnq | CA002U | 2024-11-11T14:02:56.247Z | 2024-11-19T14:21:27.218Z |
5512334 | 5512334 | 20241110083334_Uaew5 | CA002U | 2024-11-11T14:02:07.963Z | 2024-11-19T14:21:23.396Z |
5512153 | 5512153 | 20241110080618_8dS8p | CA002U | 2024-11-11T14:01:37.975Z | 2024-11-19T14:21:20.961Z |
5512112 | 5512112 | 20241110075816_2PaXq | CA002U | 2024-11-11T14:01:33.752Z | 2024-11-19T14:21:20.651Z |
5512086 | 5512086 | 20241110075436_Zp6Dm | CA002U | 2024-11-11T14:01:31.099Z | 2024-11-19T14:21:20.477Z |
5512080 | 5512080 | 20241110075247_fjA4f | CA002U | 2024-11-11T14:01:29.681Z | 2024-11-19T14:21:20.374Z |
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);