participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,288 rows where station_code = "CA000N" 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 |
---|---|---|---|---|---|
5183344 | 5183344 | 20240928063644_ac1d8 | CA000N | 2024-09-29T12:16:56.805Z | 2024-10-06T12:28:07.484Z |
5183174 | 5183174 | 20240928051039_O4umH | CA000N | 2024-09-29T12:16:46.166Z | 2024-10-06T12:28:06.047Z |
5183137 | 5183137 | 20240928044454_iQUXp | CA000N | 2024-09-29T12:16:43.639Z | 2024-10-06T12:28:05.386Z |
5118158 | 5118158 | 20240915084530_x2A33 | CA000N | 2024-09-18T12:08:27.719Z | 2024-09-23T12:16:33.164Z |
5081066 | 5081066 | 20240911062008_4JX2D | CA000N | 2024-09-15T12:17:22.629Z | 2024-09-19T12:21:44.537Z |
5067164 | 5067164 | 20240910090121_e1LqG | CA000N | 2024-09-14T12:18:34.351Z | 2024-09-18T12:15:23.506Z |
5066103 | 5066103 | 20240910063704_hEO4r | CA000N | 2024-09-14T12:17:39.063Z | 2024-09-18T12:15:21.152Z |
5065750 | 5065750 | 20240910052609_Plm0u | CA000N | 2024-09-14T12:17:22.334Z | 2024-09-18T12:15:20.309Z |
5040737 | 5040737 | 20240906053747_s7Opr | CA000N | 2024-09-12T12:16:22.852Z | 2024-09-14T12:23:10.518Z |
5027338 | 5027338 | 20240905072509_l7Ff5 | CA000N | 2024-09-11T12:14:06.175Z | 2024-09-13T12:20:02.431Z |
5026934 | 5026934 | 20240905060555_aowYO | CA000N | 2024-09-11T12:13:24.048Z | 2024-09-13T12:20:00.546Z |
5026692 | 5026692 | 20240905044519_0PRUi | CA000N | 2024-09-11T12:12:56.024Z | 2024-09-13T12:19:59.333Z |
5021791 | 5021791 | 20240905072509_Laog7 | CA000N | 2024-09-10T12:15:51.724Z | 2024-09-10T12:16:55.439Z |
5021392 | 5021392 | 20240905060555_E2Pyb | CA000N | 2024-09-10T12:15:30.793Z | 2024-09-10T12:16:55.365Z |
5021152 | 5021152 | 20240905044519_LxzcA | CA000N | 2024-09-10T12:15:17.955Z | 2024-09-10T12:16:55.319Z |
5011220 | 5011220 | 20240904053853_u5Wgj | CA000N | 2024-09-09T12:09:30.384Z | 2024-09-12T12:19:30.849Z |
5001954 | 5001954 | 20240902071845_NkvEG | CA000N | 2024-09-08T12:17:04.335Z | 2024-09-10T12:19:35.728Z |
5001708 | 5001708 | 20240902062312_2hfnk | CA000N | 2024-09-08T12:16:54.515Z | 2024-09-10T12:19:34.282Z |
4957364 | 4957364 | 20240811083257_BxkCT | CA000N | 2024-09-03T12:21:08.788Z | 2024-09-06T12:31:16.258Z |
4956044 | 4956044 | 20240811063942_QPjEh | CA000N | 2024-09-03T12:19:46.889Z | 2024-09-06T12:30:10.258Z |
4955863 | 4955863 | 20240811061517_jk42b | CA000N | 2024-09-03T12:19:30.672Z | 2024-09-06T12:30:01.742Z |
4955514 | 4955514 | 20240811052030_dwr7m | CA000N | 2024-09-03T12:19:16.961Z | 2024-09-06T12:29:45.579Z |
4955375 | 4955375 | 20240811044649_ddyb1 | CA000N | 2024-09-03T12:19:10.600Z | 2024-09-06T12:29:36.986Z |
4955210 | 4955210 | 20240811040311_nxRmG | CA000N | 2024-09-03T12:18:56.563Z | 2024-09-06T12:29:26.140Z |
4904927 | 4904927 | 20240808075301_rfjfu | CA000N | 2024-08-28T12:20:50.071Z | 2024-08-28T12:20:50.071Z |
4904758 | 4904758 | 20240808071152_2H53G | CA000N | 2024-08-28T12:20:43.519Z | 2024-08-28T12:20:43.519Z |
4904752 | 4904752 | 20240808071053_XQsir | CA000N | 2024-08-28T12:20:43.305Z | 2024-08-28T12:20:43.305Z |
4904556 | 4904556 | 20240808060936_F7bRk | CA000N | 2024-08-28T12:20:35.904Z | 2024-08-28T12:20:35.904Z |
4904256 | 4904256 | 20240808044620_6t6se | CA000N | 2024-08-28T12:20:13.198Z | 2024-08-28T12:20:13.198Z |
4885183 | 4885183 | 20240807081738_4i6uf | CA000N | 2024-08-20T12:16:21.082Z | 2024-08-27T12:16:59.527Z |
4885172 | 4885172 | 20240807081322_pQgZ0 | CA000N | 2024-08-20T12:16:20.778Z | 2024-08-27T12:16:59.204Z |
4885030 | 4885030 | 20240807073630_4o15v | CA000N | 2024-08-20T12:16:11.858Z | 2024-08-27T12:16:45.110Z |
4847201 | 4847201 | 20240805025357_qKms7 | CA000N | 2024-08-16T12:20:23.393Z | 2024-08-17T12:32:54.496Z |
4669011 | 4669011 | 20240719070209_mXUc2 | CA000N | 2024-07-20T12:05:25.198Z | 2024-07-27T12:17:21.835Z |
4663020 | 4663020 | 20240718053942_b222J | CA000N | 2024-07-19T12:05:37.105Z | 2024-07-26T12:17:48.590Z |
4635669 | 4635669 | 20240714071820_UUqGj | CA000N | 2024-07-16T12:00:17.252Z | 2024-07-23T12:08:30.706Z |
4628155 | 4628155 | 20240713062635_Fmxhr | CA000N | 2024-07-15T12:00:11.709Z | 2024-07-22T12:09:52.765Z |
4597812 | 4597812 | 20240708064242_2uJqy | CA000N | 2024-07-11T12:03:27.847Z | 2024-07-16T12:09:13.854Z |
4535488 | 4535488 | 20240702064448_DHj1o | CA000N | 2024-07-03T12:03:21.102Z | 2024-07-10T12:15:29.799Z |
4486024 | 4486024 | 20240619073020_kFCvl | CA000N | 2024-06-21T12:01:51.469Z | 2024-06-28T12:09:26.560Z |
4485868 | 4485868 | 20240619061825_rXK9X | CA000N | 2024-06-21T12:01:37.793Z | 2024-06-28T12:09:25.698Z |
4472021 | 4472021 | 20240616051128_uETDr | CA000N | 2024-06-18T12:01:24.537Z | 2024-06-24T12:11:02.019Z |
4471824 | 4471824 | 20240616033646_ZXoJA | CA000N | 2024-06-18T12:00:58.798Z | 2024-06-24T12:11:00.240Z |
4457161 | 4457161 | 20240613064722_JapUp | CA000N | 2024-06-14T12:02:40.354Z | 2024-06-21T12:11:37.462Z |
4315902 | 4315902 | 20240507073755_5l2Wk | CA000N | 2024-05-15T12:12:03.141Z | 2024-05-16T12:13:52.022Z |
4315895 | 4315895 | 20240507073520_VpHBP | CA000N | 2024-05-15T12:12:02.131Z | 2024-05-16T12:13:51.864Z |
4272364 | 4272364 | 20240503074744_9Xr35 | CA000N | 2024-05-05T12:00:58.391Z | 2024-05-12T12:15:02.240Z |
4031670 | 4031670 | 20240305061024_XbjY5 | CA000N | 2024-03-06T14:09:32.115Z | 2024-03-13T12:21:00.557Z |
3924077 | 3924077 | 20240205104612_QWWXH | CA000N | 2024-02-06T14:12:48.536Z | 2024-02-13T14:27:50.693Z |
3702235 | 3702235 | 20231221110513_0u5Xy | CA000N | 2024-01-06T00:05:50.179Z | 2024-01-06T00:05:50.179Z |
3702115 | 3702115 | 20231221104130_wIuV9 | CA000N | 2024-01-06T00:05:50.143Z | 2024-01-06T00:05:50.143Z |
3669370 | 3669370 | 20231216102702_rIyDi | CA000N | 2024-01-06T00:05:34.180Z | 2024-01-06T00:05:34.180Z |
3657496 | 3657496 | 20231215082317_pebHX | CA000N | 2024-01-06T00:05:31.303Z | 2024-01-06T00:05:31.303Z |
3657241 | 3657241 | 20231215081043_m0HhY | CA000N | 2024-01-06T00:05:31.276Z | 2024-01-06T00:05:31.276Z |
3654575 | 3654575 | 20231215055954_KAFeu | CA000N | 2024-01-06T00:05:30.959Z | 2024-01-06T00:05:30.959Z |
3651730 | 3651730 | 20231215034934_4qUrR | CA000N | 2024-01-06T00:05:30.586Z | 2024-01-06T00:05:30.586Z |
3649638 | 3649638 | 20231215021747_MUoKL | CA000N | 2024-01-06T00:05:30.305Z | 2024-01-06T00:05:30.305Z |
3647434 | 3647434 | 20231215002359_dVXod | CA000N | 2024-01-06T00:05:29.988Z | 2024-01-06T00:05:29.988Z |
3630597 | 3630597 | 20231214090530_Jafp0 | CA000N | 2024-01-06T00:05:25.615Z | 2024-01-06T00:05:25.615Z |
3630470 | 3630470 | 20231214090238_3j9W2 | CA000N | 2024-01-06T00:05:25.600Z | 2024-01-06T00:05:25.600Z |
3618201 | 3618201 | 20231214031644_32oGn | CA000N | 2024-01-06T00:05:23.536Z | 2024-01-06T00:05:23.536Z |
3450351 | 3450351 | 20231121103239_gN1yN | CA000N | 2024-01-06T00:04:35.545Z | 2024-01-06T00:04:35.545Z |
3447663 | 3447663 | 20231120234817_wNraA | CA000N | 2024-01-06T00:04:35.201Z | 2024-01-06T00:04:35.201Z |
3409298 | 3409298 | 20231116102438_bMb3r | CA000N | 2024-01-06T00:04:24.572Z | 2024-01-06T00:04:24.572Z |
3409113 | 3409113 | 20231116090854_bowSh | CA000N | 2024-01-06T00:04:24.549Z | 2024-01-06T00:04:24.549Z |
3409023 | 3409023 | 20231116083748_fSoPX | CA000N | 2024-01-06T00:04:24.538Z | 2024-01-06T00:04:24.538Z |
3408952 | 3408952 | 20231116081407_V7BxT | CA000N | 2024-01-06T00:04:24.529Z | 2024-01-06T00:04:24.529Z |
3381757 | 3381757 | 20231113083334_c5OKg | CA000N | 2024-01-06T00:04:17.846Z | 2024-01-06T00:04:17.846Z |
3291789 | 3291789 | 20231031062403_tWCqU | CA000N | 2024-01-06T00:03:36.741Z | 2024-01-06T00:03:36.741Z |
3171891 | 3171891 | 20231015052635_fd533 | CA000N | 2024-01-06T00:02:48.953Z | 2024-01-06T00:02:48.953Z |
3156316 | 3156316 | 20231014084131_dXzul | CA000N | 2024-01-06T00:02:45.865Z | 2024-01-06T00:02:45.865Z |
3155622 | 3155622 | 20231014051928_jQLRe | CA000N | 2024-01-06T00:02:45.791Z | 2024-01-06T00:02:45.791Z |
3092040 | 3092040 | 20231005044815_g9Oii | CA000N | 2024-01-06T00:02:26.209Z | 2024-01-06T00:02:26.209Z |
3091332 | 3091332 | 20231005020945_yUDFV | CA000N | 2024-01-06T00:02:26.120Z | 2024-01-06T00:02:26.120Z |
3088039 | 3088039 | 20231004051210_bblgp | CA000N | 2024-01-06T00:02:24.181Z | 2024-01-06T00:02:24.181Z |
3040574 | 3040574 | 20230922080925_0mOZA | CA000N | 2024-01-06T00:02:03.967Z | 2024-01-06T00:02:03.967Z |
3038669 | 3038669 | 20230922030946_MChaS | CA000N | 2024-01-06T00:02:03.794Z | 2024-01-06T00:02:03.794Z |
3033715 | 3033715 | 20230921082016_GjAlz | CA000N | 2024-01-06T00:02:02.024Z | 2024-01-06T00:02:02.024Z |
3033144 | 3033144 | 20230921054140_UZTk2 | CA000N | 2024-01-06T00:02:01.957Z | 2024-01-06T00:02:01.957Z |
3027238 | 3027238 | 20230920094212_eJxDt | CA000N | 2024-01-06T00:02:00.099Z | 2024-01-06T00:02:00.099Z |
3012838 | 3012838 | 20230917080924_1ZGQh | CA000N | 2024-01-06T00:01:54.680Z | 2024-01-06T00:01:54.680Z |
3012677 | 3012677 | 20230917073257_2BnIw | CA000N | 2024-01-06T00:01:54.661Z | 2024-01-06T00:01:54.661Z |
2999469 | 2999469 | 20230915074553_X3MIr | CA000N | 2024-01-06T00:01:50.704Z | 2024-01-06T00:01:50.704Z |
2992503 | 2992503 | 20230914091217_Fit4l | CA000N | 2024-01-06T00:01:48.734Z | 2024-01-06T00:01:48.734Z |
2940999 | 2940999 | 20230906044915_T02c5 | CA000N | 2024-01-06T00:01:33.658Z | 2024-01-06T00:01:33.658Z |
2934890 | 2934890 | 20230905073704_6y9c7 | CA000N | 2024-01-06T00:01:31.702Z | 2024-01-06T00:01:31.702Z |
2910146 | 2910146 | 20230828061737_SHXDh | CA000N | 2024-01-06T00:01:19.211Z | 2024-01-06T00:01:19.211Z |
2861836 | 2861836 | 20230820081324_7kbnW | CA000N | 2024-01-06T00:01:03.980Z | 2024-01-06T00:01:03.980Z |
2851289 | 2851289 | 20230819010708_LCJBy | CA000N | 2024-01-06T00:01:01.649Z | 2024-01-06T00:01:01.649Z |
2841630 | 2841630 | 20230817024106_BbG9J | CA000N | 2024-01-06T00:00:57.851Z | 2024-01-06T00:00:57.851Z |
2799448 | 2799448 | 20230814080057_n8iKj | CA000N | 2024-01-06T00:00:42.586Z | 2024-01-06T00:00:42.586Z |
2798251 | 2798251 | 20230814042814_MENpU | CA000N | 2024-01-06T00:00:42.411Z | 2024-01-06T00:00:42.411Z |
2798023 | 2798023 | 20230814040238_nUy3C | CA000N | 2024-01-06T00:00:42.377Z | 2024-01-06T00:00:42.377Z |
2795548 | 2795548 | 20230814015423_VlN8P | CA000N | 2024-01-06T00:00:42.041Z | 2024-01-06T00:00:42.041Z |
2742173 | 2742173 | 20230810034828_FIyPe | CA000N | 2024-01-06T00:00:28.871Z | 2024-01-06T00:00:28.871Z |
2730803 | 2730803 | 20230809054234_dxGef | CA000N | 2024-01-06T00:00:26.412Z | 2024-01-06T00:00:26.412Z |
2703405 | 2703405 | 20230806075402_hmnug | CA000N | 2024-01-06T00:00:17.249Z | 2024-01-06T00:00:17.249Z |
2702518 | 2702518 | 20230806030910_vDuJl | CA000N | 2024-01-06T00:00:17.127Z | 2024-01-06T00:00:17.127Z |
2686877 | 2686877 | 20230801075405_egzdM | CA000N | 2024-01-06T00:00:09.107Z | 2024-01-06T00:00:09.107Z |
2678194 | 2678194 | 20230730073837_txTDh | CA000N | 2024-01-06T00:00:05.673Z | 2024-01-06T00:00:05.673Z |
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);