names

44 rows where place_id = 586374

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588545 1864060 1864060 defendant Grene John, junior merchant 586374 586374 Grene, John, junior, of Melcombe Regis, Dorset, merchant 1
3601896 1868248 1868248 defendant Michell Richard merchant 586374 586374 Michell, Richard, of Melcombe Regis, Dorset, merchant 1
3952438 2007921 2007921 defendant Reynold Lancelot merchant 586374 586374 Reynold, Lancelot, of Melcombe Regis, Dorset, merchant 0
3955824 2009111 2009111 defendant Jurden Thomas, senior merchant 586374 586374 Jurden, Thomas, senior, of Melcombe Regis, Dorset, merchant 0
3960402 2010736 2010736 defendant Raynold Lancelot merchant 586374 586374 Raynold, Lancelot, of Melcombe Regis, Dorset, merchant 0
3967933 2013413 2013413 defendant Gregorye Robert merchant 586374 586374 Gregorye, Robert, of Melcombe Regis, Dorset, merchant 0
3978160 2016941 2016941 defendant Seller John yeoman 586374 586374 Seller, John, of Melcombe Regis, Dorset, yeoman 1
3980395 2017758 2017758 defendant Major Barnard merchant 586374 586374 Major, Barnard, of Melcombe Regis, Dorset, merchant 0
3980397 2017759 2017759 defendant Major Barnard merchant 586374 586374 Major, Barnard, of Melcombe Regis, Dorset, merchant 0
3981440 2018128 2018128 defendant Reignoldes Lancelot merchant 586374 586374 Reignoldes, Lancelot, of Melcombe Regis, Dorset, merchant 0
3986011 2019764 2019764 defendant Bagge George merchant 586374 586374 Bagge, George, of Melcombe Regis, Dorset, merchant 0
3989180 2020868 2020868 defendant Reynold Lancelot merchant 586374 586374 Reynold, Lancelot, of Melcombe Regis, Dorset, merchant 0
3990201 2021251 2021251 defendant Gregory Robert merchant 586374 586374 Gregory, Robert, of Melcombe Regis, Dorset, merchant 0
3994651 2022839 2022839 defendant Seller John merchant 586374 586374 Seller, John, of Melcombe Regis, Dorset, merchant 0
4005345 2026691 2026691 defendant Gregorye Robert merchant 586374 586374 Gregorye, Robert, of Melcombe Regis, Dorset, merchant 0
4011152 2028755 2028755 defendant Bagge George   586374 586374 Bagge, George, of Melcombe Regis, Dorset, mercgant 0
4011188 2028772 2028772 defendant Major Barnard merchant 586374 586374 Major, Barnard, of Melcombe Regis, Dorset, merchant 0
4014136 2029785 2029785 defendant Reynoldes Owen merchant 586374 586374 Reynoldes, Owen, of Melcombe Regis, Dorset, merchant 0
4073421 2050780 2050780 defendant Gregorie Robert merchant 586374 586374 Gregorie, Robert, of Melcombe Regis, Dorset, merchant 0
4131273 2071505 2071505 defendant Samwayes Thomas merchant 586374 586374 Samwayes, Thomas, of Melcombe Regis, Dorset, merchant 0
4184481 2090081 2090081 defendant Browne John   586374 586374 Browne, John, of Melcombe Regis, Dorset, "searcher" or customs inspector 0
4272378 2120334 2120334 defendant Reynold Luke gent 586374 586374 Reynold, Luke, of Melcombe Regis, Dorset, or of New Inn, Middx, gent 0
4364877 2152490 2152490 defendant Hardy Thomas gent 586374 586374 Hardy, Thomas, of Melcombe Regis, Dorset, gent 0
4719508 2271444 2271444 defendant Cauxeman John merchant 586374 586374 Cauxeman, John, of Melcombe Regis, Dorset, merchant 0
4756907 2282527 2282527 defendant Walssh John shipman 586374 586374 Walssh, John, of Melcombe Regis, Dorset, shipman 2
4935905 2337621 2337621 defendant Cauxseman John merchant 586374 586374 Cauxseman, John, of Melcombe Regis, Dorset, merchant 0
4943253 2339861 2339861 defendant Abbot Robert merchant 586374 586374 Abbot, Robert, of Melcombe Regis, Dorset, merchant 1
4965912 2346737 2346737 defendant Corffe John merchant 586374 586374 Corffe, John, of Melcombe Regis, Dorset, merchant 4
4977210 2350141 2350141 defendant Hunte Robert merchant 586374 586374 Hunte, Robert, of Melcombe Regis, Dorset, merchant 0
5000693 2357077 2357077 defendant Abbot Robert merchant 586374 586374 Abbot, Robert, of Melcombe Regis, Dorset, merchant 0
5000760 2357099 2357099 defendant Corff John merchant 586374 586374 Corff, John, of Melcombe Regis, Dorset, merchant 1
5003536 2357929 2357929 defendant Grene John yeoman 586374 586374 Grene, John, of Melcombe Regis, Dorset, yeoman 0
5003538 2357930 2357930 defendant Grene John yeoman 586374 586374 Grene, John, of Melcombe Regis, Dorset, yeoman 0
5023611 2363815 2363815 defendant Corfe John merchant 586374 586374 Corfe, John, of Melcombe Regis, Dorset, merchant 3
5060316 2374659 2374659 defendant Corfe John merchant 586374 586374 Corfe, John, of Melcombe Regis, Dorset, merchant 3
5068736 2377145 2377145 defendant Eustas or Enstas Richard merchant 586374 586374 Eustas or Enstas, Richard, of Melcombe Regis, Dorset, merchant 1
5218130 2421038 2421038 defendant More Oto merchant 586374 586374 More, Oto, of Melcombe Regis, Dorset, merchant 3
5251302 2430509 2430509 defendant Corff John merchant 586374 586374 Corff, John, of Melcombe Regis, Dorset, merchant 3
5251307 2430510 2430510 defendant Corff John   586374 586374 Corff, John, of Melcombe Regis, Dorset 3
5421849 2481471 2481471 defendant Grene John merchant 586374 586374 Grene, John, of Melcombe Regis, Dorset, merchant 0
5564158 2524129 2524129 defendant Horne Richard merchant 586374 586374 Horne, Richard, of Melcombe Regis, Dorset, merchant 1
5564163 2524130 2524130 defendant Horne Richard merchant 586374 586374 Horne, Richard, of Melcombe Regis, Dorset, merchant 1
5574535 2527117 2527117 defendant Horne Richard merchant 586374 586374 Horne, Richard, of Melcombe Regis, Dorset, merchant 0
5574538 2527118 2527118 defendant Horne Richard merchant 586374 586374 Horne, Richard, of Melcombe Regis, Dorset, merchant 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);