participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,368 rows where station_code = "NZ004C" 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 |
---|---|---|---|---|---|
5569437 | 5569437 | 20241121153007_33ryN | NZ004C | 2024-11-22T14:10:52.861Z | 2024-11-22T14:10:52.861Z |
5569314 | 5569314 | 20241121150747_L50kL | NZ004C | 2024-11-22T14:10:45.190Z | 2024-11-22T14:10:45.190Z |
5569261 | 5569261 | 20241121150045_0EYL3 | NZ004C | 2024-11-22T14:10:42.436Z | 2024-11-22T14:10:42.436Z |
5569242 | 5569242 | 20241121145804_HftF0 | NZ004C | 2024-11-22T14:10:41.400Z | 2024-11-22T14:10:41.400Z |
5569232 | 5569232 | 20241121145418_BayuD | NZ004C | 2024-11-22T14:10:40.940Z | 2024-11-22T14:10:40.940Z |
5569127 | 5569127 | 20241121143853_Oow1L | NZ004C | 2024-11-22T14:10:22.715Z | 2024-11-22T14:10:22.715Z |
5569096 | 5569096 | 20241121143252_Ijx12 | NZ004C | 2024-11-22T14:10:20.378Z | 2024-11-22T14:10:20.378Z |
5568810 | 5568810 | 20241121134209_Ex54S | NZ004C | 2024-11-22T14:09:47.424Z | 2024-11-22T14:09:47.424Z |
5568649 | 5568649 | 20241121131739_wFohc | NZ004C | 2024-11-22T14:09:30.144Z | 2024-11-22T14:09:30.144Z |
5568529 | 5568529 | 20241121125504_bDa73 | NZ004C | 2024-11-22T14:09:16.372Z | 2024-11-22T14:09:16.372Z |
5568359 | 5568359 | 20241121123058_SQbAC | NZ004C | 2024-11-22T14:08:47.897Z | 2024-11-22T14:08:47.897Z |
5568319 | 5568319 | 20241121122334_LMI62 | NZ004C | 2024-11-22T14:08:42.258Z | 2024-11-22T14:08:42.258Z |
5568200 | 5568200 | 20241121120438_QWylZ | NZ004C | 2024-11-22T14:08:24.298Z | 2024-11-22T14:08:24.298Z |
5567979 | 5567979 | 20241121113718_2D53Y | NZ004C | 2024-11-22T14:07:53.075Z | 2024-11-22T14:07:53.075Z |
5567927 | 5567927 | 20241121113152_TzOHW | NZ004C | 2024-11-22T14:07:44.368Z | 2024-11-22T14:07:44.368Z |
5567743 | 5567743 | 20241121105832_c4aBO | NZ004C | 2024-11-22T14:07:10.577Z | 2024-11-22T14:07:10.577Z |
5567494 | 5567494 | 20241121102838_SXGDI | NZ004C | 2024-11-22T14:06:24.118Z | 2024-11-22T14:06:24.118Z |
5567484 | 5567484 | 20241121102636_HtEO5 | NZ004C | 2024-11-22T14:06:23.053Z | 2024-11-22T14:06:23.053Z |
5567296 | 5567296 | 20241121095944_7b2q2 | NZ004C | 2024-11-22T14:05:47.844Z | 2024-11-22T14:05:47.844Z |
5567148 | 5567148 | 20241121093304_DDfkw | NZ004C | 2024-11-22T14:05:27.085Z | 2024-11-22T14:05:27.085Z |
5560532 | 5560532 | 20241120130755_nC7Qw | NZ004C | 2024-11-21T14:09:02.907Z | 2024-11-22T14:19:21.681Z |
5560482 | 5560482 | 20241120125525_FsPec | NZ004C | 2024-11-21T14:08:56.298Z | 2024-11-22T14:19:21.667Z |
5560432 | 5560432 | 20241120125119_FOVg1 | NZ004C | 2024-11-21T14:08:50.538Z | 2024-11-22T14:19:21.657Z |
5559958 | 5559958 | 20241120113858_DBKMm | NZ004C | 2024-11-21T14:07:41.313Z | 2024-11-22T14:19:21.557Z |
5559891 | 5559891 | 20241120113029_MKXDy | NZ004C | 2024-11-21T14:07:28.899Z | 2024-11-22T14:19:21.544Z |
5559775 | 5559775 | 20241120111642_3xSIm | NZ004C | 2024-11-21T14:07:10.218Z | 2024-11-22T14:19:21.522Z |
5555430 | 5555430 | 20241119131057_Zr2Gp | NZ004C | 2024-11-20T14:05:36.361Z | 2024-11-22T14:20:05.945Z |
5555343 | 5555343 | 20241119125044_6EPs2 | NZ004C | 2024-11-20T14:05:14.841Z | 2024-11-22T14:20:04.475Z |
5547332 | 5547332 | 20241117154224_HiEj5 | NZ004C | 2024-11-18T14:05:31.754Z | 2024-11-22T14:22:39.006Z |
5547296 | 5547296 | 20241117152757_8plme | NZ004C | 2024-11-18T14:05:26.303Z | 2024-11-22T14:22:38.371Z |
5547150 | 5547150 | 20241117145906_QNFGY | NZ004C | 2024-11-18T14:05:11.083Z | 2024-11-22T14:22:37.700Z |
5546981 | 5546981 | 20241117135242_vvi3A | NZ004C | 2024-11-18T14:04:37.373Z | 2024-11-22T14:22:36.007Z |
5546958 | 5546958 | 20241117133826_4Uw32 | NZ004C | 2024-11-18T14:04:33.286Z | 2024-11-22T14:22:35.716Z |
5546944 | 5546944 | 20241117133234_04zSv | NZ004C | 2024-11-18T14:04:31.127Z | 2024-11-22T14:22:35.638Z |
5546875 | 5546875 | 20241117131058_dCd2t | NZ004C | 2024-11-18T14:04:23.352Z | 2024-11-22T14:22:35.242Z |
5546863 | 5546863 | 20241117130655_juvfY | NZ004C | 2024-11-18T14:04:22.319Z | 2024-11-22T14:22:35.099Z |
5546848 | 5546848 | 20241117130200_zO0UG | NZ004C | 2024-11-18T14:04:20.908Z | 2024-11-22T14:22:34.985Z |
5546786 | 5546786 | 20241117124308_l3P58 | NZ004C | 2024-11-18T14:04:13.883Z | 2024-11-22T14:22:34.610Z |
5546771 | 5546771 | 20241117124012_Zl3zX | NZ004C | 2024-11-18T14:04:12.312Z | 2024-11-22T14:22:34.572Z |
5546647 | 5546647 | 20241117120255_0FUJR | NZ004C | 2024-11-18T14:03:43.930Z | 2024-11-22T14:22:33.635Z |
5546645 | 5546645 | 20241117120254_4t9Re | NZ004C | 2024-11-18T14:03:43.531Z | 2024-11-22T14:22:33.629Z |
5546531 | 5546531 | 20241117112539_bVVDc | NZ004C | 2024-11-18T14:03:21.208Z | 2024-11-22T14:22:32.432Z |
5546370 | 5546370 | 20241117103437_brNx6 | NZ004C | 2024-11-18T14:02:56.768Z | 2024-11-22T14:22:31.491Z |
5546355 | 5546355 | 20241117103120_v2mKm | NZ004C | 2024-11-18T14:02:54.888Z | 2024-11-22T14:22:31.320Z |
5546256 | 5546256 | 20241117100613_jdZq5 | NZ004C | 2024-11-18T14:02:35.354Z | 2024-11-22T14:22:30.602Z |
5544705 | 5544705 | 20241116143138_mHX1y | NZ004C | 2024-11-17T14:01:52.917Z | 2024-11-22T14:23:05.867Z |
5544695 | 5544695 | 20241116142937_yud2v | NZ004C | 2024-11-17T14:01:52.378Z | 2024-11-22T14:23:05.796Z |
5544675 | 5544675 | 20241116141423_yMris | NZ004C | 2024-11-17T14:01:49.912Z | 2024-11-22T14:23:05.378Z |
5544650 | 5544650 | 20241116134403_2OXA8 | NZ004C | 2024-11-17T14:01:45.530Z | 2024-11-22T14:23:05.221Z |
5544634 | 5544634 | 20241116132702_A6c5I | NZ004C | 2024-11-17T14:01:44.006Z | 2024-11-22T14:23:05.126Z |
5544351 | 5544351 | 20241116101613_FrBFJ | NZ004C | 2024-11-17T14:00:55.671Z | 2024-11-22T14:23:01.859Z |
5544287 | 5544287 | 20241116093452_fqxJX | NZ004C | 2024-11-17T14:00:45.707Z | 2024-11-22T14:23:01.343Z |
5544282 | 5544282 | 20241116093327_jsIxf | NZ004C | 2024-11-17T14:00:44.943Z | 2024-11-22T14:23:01.288Z |
5542889 | 5542889 | 20241115154319_MhtPQ | NZ004C | 2024-11-16T14:02:55.130Z | 2024-11-22T14:23:32.325Z |
5542855 | 5542855 | 20241115144628_9oA8F | NZ004C | 2024-11-16T14:02:46.876Z | 2024-11-22T14:23:31.862Z |
5542843 | 5542843 | 20241115140839_mOZW2 | NZ004C | 2024-11-16T14:02:44.799Z | 2024-11-22T14:23:31.674Z |
5542834 | 5542834 | 20241115131448_QZqoZ | NZ004C | 2024-11-16T14:02:42.864Z | 2024-11-22T14:23:31.606Z |
5536144 | 5536144 | 20241112154908_gOHar | NZ004C | 2024-11-14T14:09:14.763Z | 2024-11-21T14:25:56.990Z |
5536130 | 5536130 | 20241112154546_0PakV | NZ004C | 2024-11-14T14:09:13.019Z | 2024-11-21T14:25:56.916Z |
5536107 | 5536107 | 20241112154033_3gB8T | NZ004C | 2024-11-14T14:09:11.870Z | 2024-11-21T14:25:56.725Z |
5536061 | 5536061 | 20241112153201_zqGnX | NZ004C | 2024-11-14T14:09:09.432Z | 2024-11-21T14:25:56.447Z |
5535782 | 5535782 | 20241112142046_E8qWN | NZ004C | 2024-11-14T14:08:49.341Z | 2024-11-21T14:25:53.335Z |
5535730 | 5535730 | 20241112140057_pXQs8 | NZ004C | 2024-11-14T14:08:36.060Z | 2024-11-21T14:25:52.743Z |
5535700 | 5535700 | 20241112134858_iCnyi | NZ004C | 2024-11-14T14:08:26.277Z | 2024-11-21T14:25:51.351Z |
5535660 | 5535660 | 20241112133056_xfdz9 | NZ004C | 2024-11-14T14:08:17.054Z | 2024-11-21T14:25:50.874Z |
5535633 | 5535633 | 20241112131657_dUQBh | NZ004C | 2024-11-14T14:08:11.973Z | 2024-11-21T14:25:50.760Z |
5535454 | 5535454 | 20241112123154_iiuTH | NZ004C | 2024-11-14T14:07:57.338Z | 2024-11-21T14:25:48.442Z |
5535386 | 5535386 | 20241112122204_2VeT6 | NZ004C | 2024-11-14T14:07:52.849Z | 2024-11-21T14:25:46.863Z |
5535346 | 5535346 | 20241112121711_kSO6k | NZ004C | 2024-11-14T14:07:50.219Z | 2024-11-21T14:25:46.523Z |
5533967 | 5533967 | 20241113103216_ZFM5s | NZ004C | 2024-11-14T14:03:21.584Z | 2024-11-22T14:24:11.840Z |
5520313 | 5520313 | 20241111151819_J8Lwv | NZ004C | 2024-11-12T14:06:08.071Z | 2024-11-20T14:25:06.736Z |
5520305 | 5520305 | 20241111151658_uvnyc | NZ004C | 2024-11-12T14:06:07.485Z | 2024-11-20T14:25:06.636Z |
5520301 | 5520301 | 20241111151540_7Fz4U | NZ004C | 2024-11-12T14:06:07.146Z | 2024-11-20T14:25:06.633Z |
5520289 | 5520289 | 20241111151333_Qsrpf | NZ004C | 2024-11-12T14:06:05.531Z | 2024-11-20T14:25:06.451Z |
5520208 | 5520208 | 20241111145828_lyhDh | NZ004C | 2024-11-12T14:05:58.017Z | 2024-11-20T14:25:05.818Z |
5520117 | 5520117 | 20241111143819_hsX5Y | NZ004C | 2024-11-12T14:05:38.782Z | 2024-11-20T14:25:04.085Z |
5519812 | 5519812 | 20241111131033_QPiPY | NZ004C | 2024-11-12T14:05:04.353Z | 2024-11-20T14:24:58.219Z |
5519782 | 5519782 | 20241111125923_o6E2S | NZ004C | 2024-11-12T14:04:58.574Z | 2024-11-20T14:24:57.810Z |
5519762 | 5519762 | 20241111125629_BO2wu | NZ004C | 2024-11-12T14:04:56.293Z | 2024-11-20T14:24:57.379Z |
5519682 | 5519682 | 20241111122851_FoL5q | NZ004C | 2024-11-12T14:04:45.145Z | 2024-11-20T14:24:55.534Z |
5519394 | 5519394 | 20241111111639_MNam2 | NZ004C | 2024-11-12T14:03:55.550Z | 2024-11-20T14:24:48.815Z |
5519360 | 5519360 | 20241111110834_TderS | NZ004C | 2024-11-12T14:03:50.903Z | 2024-11-20T14:24:48.303Z |
5519311 | 5519311 | 20241111105722_k0Xtu | NZ004C | 2024-11-12T14:03:43.934Z | 2024-11-20T14:24:47.338Z |
5514343 | 5514343 | 20241110153158_5ibde | NZ004C | 2024-11-11T14:06:30.879Z | 2024-11-19T14:21:46.419Z |
5514334 | 5514334 | 20241110153125_R5iAn | NZ004C | 2024-11-11T14:06:30.136Z | 2024-11-19T14:21:46.398Z |
5514325 | 5514325 | 20241110153033_g1N32 | NZ004C | 2024-11-11T14:06:29.258Z | 2024-11-19T14:21:46.343Z |
5514293 | 5514293 | 20241110152644_IpeM8 | NZ004C | 2024-11-11T14:06:26.489Z | 2024-11-19T14:21:45.723Z |
5514255 | 5514255 | 20241110151846_ABWIf | NZ004C | 2024-11-11T14:06:23.870Z | 2024-11-19T14:21:45.474Z |
5514225 | 5514225 | 20241110151412_nzPHH | NZ004C | 2024-11-11T14:06:22.248Z | 2024-11-19T14:21:45.202Z |
5514164 | 5514164 | 20241110145203_qIq04 | NZ004C | 2024-11-11T14:06:17.105Z | 2024-11-19T14:21:44.367Z |
5512820 | 5512820 | 20241110095339_CblEY | NZ004C | 2024-11-11T14:03:13.734Z | 2024-11-19T14:21:28.765Z |
5508303 | 5508303 | 20241109155855_4octd | NZ004C | 2024-11-10T14:07:25.173Z | 2024-11-18T14:26:21.028Z |
5508255 | 5508255 | 20241109153148_6OIxu | NZ004C | 2024-11-10T14:07:19.593Z | 2024-11-18T14:26:20.420Z |
5508231 | 5508231 | 20241109151622_d5525 | NZ004C | 2024-11-10T14:07:17.265Z | 2024-11-18T14:26:20.165Z |
5508224 | 5508224 | 20241109151531_4WmUn | NZ004C | 2024-11-10T14:07:16.609Z | 2024-11-18T14:26:20.129Z |
5508190 | 5508190 | 20241109150439_T2jeX | NZ004C | 2024-11-10T14:07:13.769Z | 2024-11-18T14:26:19.824Z |
5508188 | 5508188 | 20241109150248_3T1uM | NZ004C | 2024-11-10T14:07:13.536Z | 2024-11-18T14:26:19.794Z |
5508177 | 5508177 | 20241109145846_oXKrp | NZ004C | 2024-11-10T14:07:12.762Z | 2024-11-18T14:26:19.771Z |
5508159 | 5508159 | 20241109144849_imsvi | NZ004C | 2024-11-10T14:07:11.026Z | 2024-11-18T14:26:19.608Z |
5508138 | 5508138 | 20241109144247_vcHGj | NZ004C | 2024-11-10T14:07:08.491Z | 2024-11-18T14:26:19.227Z |
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);