names

74 rows where place_id = 591240

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603829 1868870 1868870 defendant Hoppyng John yeoman 591240 591240 Hoppyng, John, of Oterton, yeoman 0
3604541 1869085 1869085 defendant Smyth William husbandman 591240 591240 Smyth, William, of Oterton, husbandman 0
3607993 1870152 1870152 defendant Gryndell William   591240 591240 Gryndell, William, of Oterton, ship wright 0
3637981 1906698 1906698 defendant Clappe Thomas butcher 591240 591240 Clappe, Thomas, of Oterton, butcher 5
3637982 1906698 1906698 defendant Kygges John butcher 591240 591240 Kygges, John, of Oterton, butcher 6
3710441 1929584 1929584 defendant Cowke John, junior yeoman 591240 591240 Cowke, John, junior, of Oterton, yeoman 0
3746324 1940766 1940766 defendant Axe Robert yeoman 591240 591240 Axe, Robert, of Oterton, yeoman 0
3765564 1946891 1946891 defendant Bonvyle Humphrey gent 591240 591240 Bonvyle, Humphrey, of Oterton, gent 0
3770332 1948394 1948394 defendant Buckyngham Michael yeoman 591240 591240 Buckyngham, Michael, of Oterton, yeoman 0
3773077 1949283 1949283 defendant Bukyngham Michael husbandman 591240 591240 Bukyngham, Michael, of Oterton, husbandman 0
3773078 1949283 1949283 defendant Newcombe William   591240 591240 Newcombe, William, of Oterton 1
3773079 1949283 1949283 defendant Swayn Richard husbandman 591240 591240 Swayn, Richard, of Oterton, husbandman 2
3773080 1949283 1949283 defendant Strete John husbandman 591240 591240 Strete, John, of Oterton, husbandman 3
3773081 1949283 1949283 defendant Wyllyams John husbandman 591240 591240 Wyllyams, John, of Oterton, husbandman 4
3783597 1952629 1952629 defendant Bonbyle Humphrey gent 591240 591240 Bonbyle, Humphrey, of Oterton, gent 0
3846011 1972310 1972310 defendant Wheton William yeoman 591240 591240 Wheton, William, of Oterton, yeoman 0
4526443 2208549 2208549 defendant Hoke Celia   591240 591240 Hoke, Celia, of Oterton 1
4526444 2208549 2208549 defendant Leche Richard   591240 591240 Leche, Richard, of Oterton 2
4646219 2244966 2244966 defendant Payne John   591240 591240 Payne, John, of Oterton 0
4658335 2248493 2248493 defendant Payn Richard yeoman 591240 591240 Payn, Richard, of Oterton, yeoman 0
4658336 2248493 2248493 defendant Shirwynd William husbandman 591240 591240 Shirwynd, William, of Oterton, husbandman 1
4705248 2267010 2267010 defendant Boure Richard husbandman 591240 591240 Boure, Richard, of Oterton, husbandman 1
4861148 2314846 2314846 defendant Clerk John butcher 591240 591240 Clerk, John, of Oterton, butcher 0
5034573 2366972 2366972 defendant Persay John, junior husbandman 591240 591240 Persay, John, junior, of Oterton, husbandman 0
5048804 2371278 2371278 defendant Dollyng John   591240 591240 Dollyng, John, of Oterton husbandman 0
5070090 2377548 2377548 defendant Harlewyn John gent 591240 591240 Harlewyn, John, of Oterton, gent 0
5081146 2380863 2380863 defendant Fregan John shoemaker 591240 591240 Fregan, John, of Oterton, shoemaker 3
5081147 2380863 2380863 defendant Chevale or Chenale Walter husbandman 591240 591240 Chevale or Chenale, Walter, of Oterton, husbandman 4
5085123 2382053 2382053 defendant Lyleaux Robert husbandman 591240 591240 Lyleaux, Robert, of Oterton, husbandman 2
5089307 2383239 2383239 defendant Dollyng John husbandman 591240 591240 Dollyng, John, of Oterton, husbandman 4
5105949 2388178 2388178 defendant Chevale Walter husbandman 591240 591240 Chevale, Walter, of Oterton, husbandman 2
5106111 2388224 2388224 defendant Flegan John shoemaker 591240 591240 Flegan, John, of Oterton, shoemaker 1
5128073 2394684 2394684 defendant Trent John clerk 591240 591240 Trent, John, of Oterton, clerk 0
5134287 2396524 2396524 defendant Dollyng John husbandman 591240 591240 Dollyng, John, of Oterton, husbandman 0
5138817 2397853 2397853 defendant Harlewyn John, junior gent 591240 591240 Harlewyn, John, junior, of Oterton, gent 0
5147183 2400314 2400314 defendant Trent John clerk 591240 591240 Trent, John, of Oterton, clerk 0
5154190 2402382 2402382 defendant Dollyng John husbandman 591240 591240 Dollyng, John, of Oterton, husbandman 0
5154192 2402383 2402383 defendant Dollyng John husbandman 591240 591240 Dollyng, John, of Oterton, husbandman 0
5171340 2407343 2407343 defendant Dollyng John husbandman 591240 591240 Dollyng, John, of Oterton, husbandman 0
5215147 2420152 2420152 defendant Trente John clerk 591240 591240 Trente, John, of Oterton, clerk 1
5219190 2421336 2421336 defendant Patrak Nicholas husbandman 591240 591240 Patrak, Nicholas, of Oterton, husbandman 0
5221329 2421937 2421937 defendant Dollyng John husbandman 591240 591240 Dollyng, John, of Oterton, husbandman 0
5264100 2434529 2434529 defendant Frygon Roger carpenter 591240 591240 Frygon, Roger, of Oterton, carpenter 2
5288025 2441512 2441512 defendant Grendell William husbandman 591240 591240 Grendell, William, of Oterton, husbandman 0
5322775 2451889 2451889 defendant Snellyng William cordwainer 591240 591240 Snellyng, William, of Oterton, cordwainer 0
5379409 2469151 2469151 defendant Gonayre Richard husbandman 591240 591240 Gonayre, Richard, of Oterton, husbandman 0
5379552 2469193 2469193 defendant Dollyng John yeoman 591240 591240 Dollyng, John, of Oterton, yeoman 0
5379553 2469193 2469193 defendant Hoppyn John husbandman 591240 591240 Hoppyn, John, of Oterton, husbandman 1
5384365 2470616 2470616 defendant Hopyng John husbandman 591240 591240 Hopyng, John, of Oterton, husbandman 1
5396170 2473992 2473992 defendant Hoppyng John, junior   591240 591240 Hoppyng, John, junior, of Oterton husbandman 0
5404282 2476301 2476301 defendant Scorche John baker 591240 591240 Scorche, John, of Oterton, baker 1
5407265 2477140 2477140 defendant Hoppyng John, junior husbandman 591240 591240 Hoppyng, John, junior, of Oterton, husbandman 1
5447251 2489066 2489066 defendant Brace William husbandman 591240 591240 Brace, William, of Oterton, husbandman 0
5459730 2492831 2492831 defendant Brace William husbandman 591240 591240 Brace, William, of Oterton, husbandman 0
5471429 2496399 2496399 defendant Brace William husbandman 591240 591240 Brace, William, of Oterton, husbandman 0
5474412 2497327 2497327 defendant Pyne William husbandman 591240 591240 Pyne, William, of Oterton, husbandman 1
5482726 2499777 2499777 defendant Brace William husbandman 591240 591240 Brace, William, of Oterton, husbandman 0
5523103 2512053 2512053 defendant Drake John, senior   591240 591240 Drake, John, senior, of Oterton, franklin 0
5532673 2514765 2514765 defendant Scotte Maurice husbandman 591240 591240 Scotte, Maurice, of Oterton, husbandman 0
5537343 2516172 2516172 defendant Gryndell John   591240 591240 Gryndell, John, of Oterton, shipwright 0
5538171 2516426 2516426 defendant Archeboll Thomas husbandman 591240 591240 Archeboll, Thomas, of Oterton, husbandman 0
5538172 2516426 2516426 defendant Skutte Andrew husbandman 591240 591240 Skutte, Andrew, of Oterton, husbandman 1
5538173 2516426 2516426 defendant Fregyn John husbandman 591240 591240 Fregyn, John, of Oterton, husbandman 2
5538174 2516426 2516426 defendant Fregyn John, junior laborer 591240 591240 Fregyn, John, junior, of Oterton, laborer 3
5538175 2516426 2516426 defendant Kyng John husbandman 591240 591240 Kyng, John, of Oterton, husbandman 4
5538176 2516426 2516426 defendant Payng William husbandman 591240 591240 Payng, William, of Oterton, husbandman 5
5538177 2516426 2516426 defendant Wenman John, junior laborer 591240 591240 Wenman, John, junior, of Oterton, laborer 6
5544034 2518243 2518243 defendant Taillour Henry (legal representative) 591240 591240 Taillour, Henry, of Oterton, husbandman, executrix of 0
5544035 2518243 2518243 defendant Taillour Agnes widow 591240 591240 Taillour, Agnes, of Oterton, widow 1
5564345 2524184 2524184 defendant Enderby John clerk 591240 591240 Enderby, John, of Oterton, clerk 0
5583985 2530064 2530064 plaintiff Grendell William   591240 591240 Grendell, William, of Oterton, ship carpenter 0
5583988 2530065 2530065 plaintiff Grendell William   591240 591240 Grendell, William, of Oterton, ship carpenter 0
5589975 2531848 2531848 defendant Clappe John shoemaker 591240 591240 Clappe, John, of Oterton, shoemaker 0
5599474 2534727 2534727 plaintiff Grendell William   591240 591240 Grendell, William, of Oterton, ship carpenter 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);