names

85 rows where place_id = 592913

✎ 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
3609368 1870589 1870589 defendant Ingram Richard husbandman 592913 592913 Ingram, Richard, of Hoggesthorp, husbandman 1
3798536 1957445 1957445 defendant Halden John husbandman 592913 592913 Halden, John, of Hoggesthorp, husbandman 1
3845622 1972172 1972172 defendant Besowthen Thomas husbandman 592913 592913 Besowthen, Thomas, of Hoggesthorp, husbandman 1
3910625 1993871 1993871 defendant Legett William husbandman 592913 592913 Legett, William, of Hoggesthorp, husbandman 0
3958826 2010167 2010167 defendant Kele Nicholas yeoman 592913 592913 Kele, Nicholas, of Hoggesthorp, yeoman 0
3978061 2016902 2016902 defendant Crofte Giles laborer 592913 592913 Crofte, Giles, of Hoggesthorp, laborer 1
4035572 2037394 2037394 defendant Blades Thomas husbandman 592913 592913 Blades, Thomas, of Hoggesthorp, husbandman 0
4149688 2078016 2078016 defendant Randesley Thomas miller 592913 592913 Randesley, Thomas, of Hoggesthorp, miller 0
4149689 2078016 2078016 defendant Caymell John husbandman 592913 592913 Caymell, John, of Hoggesthorp, husbandman 1
4413018 2168945 2168945 defendant Smyth Eudo   592913 592913 Smyth, Eudo, of Hoggesthorp 2
4413020 2168945 2168945 defendant Merwyn Thomas   592913 592913 Merwyn, Thomas, of Hoggesthorp 4
4428998 2173873 2173873 plaintiff Tours Stephen   592913 592913 Tours, Stephen, of Hoggesthorp 0
4437032 2176328 2176328 plaintiff Tours Stephen   592913 592913 Tours, Stephen, of Hoggesthorp 0
4446524 2183825 2183825 plaintiff Baxter Philip   592913 592913 (Baxter, Philip, of Hoggesthorp 1
4463082 2189156 2189156 plaintiff Tours Hugh   592913 592913 Tours, Hugh, of Hoggesthorp 0
4508090 2203003 2203003 defendant West Thomas   592913 592913 West, Thomas, of Hoggesthorp 0
4509744 2203531 2203531 defendant atte Welles Robert   592913 592913 atte Welles, Robert, of Hoggesthorp 1
4540353 2212882 2212882 defendant Watteson Philip   592913 592913 Watteson, Philip, of Hoggesthorp 0
4659070 2248706 2248706 defendant Gamull Alan miller 592913 592913 Gamull, Alan, of Hoggesthorp, miller 1
4722389 2272321 2272321 defendant Cobbe Hugh husbandman 592913 592913 Cobbe, Hugh, of Hoggesthorp, husbandman 1
4743592 2278653 2278653 defendant atte Welle Robert yeoman 592913 592913 atte Welle, Robert, of Hoggesthorp, yeoman 0
4753812 2281567 2281567 defendant Justice John husbandman 592913 592913 Justice, John, of Hoggesthorp, husbandman 0
4786056 2291677 2291677 defendant atte Welle Robert husbandman 592913 592913 atte Welle, Robert, of Hoggesthorp, husbandman 0
4800338 2296284 2296284 defendant Rape Robert husbandman 592913 592913 Rape, Robert, of Hoggesthorp, husbandman 0
4800889 2296464 2296464 defendant Chaumberleyn Robert husbandman 592913 592913 Chaumberleyn, Robert, of Hoggesthorp, husbandman 0
4835886 2307206 2307206 defendant Cracrofte William gent 592913 592913 Cracrofte, William, of Hoggesthorp, gent 0
4843521 2309494 2309494 defendant Heryng William husbandman 592913 592913 Heryng, William, of Hoggesthorp, husbandman 0
4863220 2315472 2315472 defendant Cracroft William gent 592913 592913 Cracroft, William, of Hoggesthorp, gent 0
4887772 2323008 2323008 defendant Cracroft William gent 592913 592913 Cracroft, William, of Hoggesthorp, gent 0
4887786 2323010 2323010 plaintiff atte Welle Robert husbandman 592913 592913 atte Welle, Robert, of Hoggesthorp, husbandman 0
4887823 2323021 2323021 defendant Bek William butcher 592913 592913 Bek, William, of Hoggesthorp, butcher 0
4887824 2323021 2323021 defendant Rust William husbandman 592913 592913 Rust, William, of Hoggesthorp, husbandman 1
4897054 2325733 2325733 plaintiff de Welle Robert   592913 592913 de Welle, Robert, of Hoggesthorp 0
4902400 2327366 2327366 defendant atte Welle Robert husbandman 592913 592913 atte Welle, Robert, of Hoggesthorp, husbandman 0
4920817 2333025 2333025 defendant Morton Walter gent 592913 592913 Morton, Walter, of Hoggesthorp, gent 0
4924476 2334093 2334093 defendant Heryng William shoemaker 592913 592913 Heryng, William, of Hoggesthorp, shoemaker 0
4926575 2334730 2334730 plaintiff Rape Robert   592913 592913 Rape, Robert, of Hoggesthorp 0
4926576 2334730 2334730 defendant Cracroft William esq 592913 592913 Cracroft, William, of Hoggesthorp, esq 0
4927801 2335130 2335130 defendant Goderd Anne widow 592913 592913 Goderd, Anne, of Hoggesthorp, widow 0
4936438 2337787 2337787 defendant Sparke Thomas husbandman 592913 592913 Sparke, Thomas, of Hoggesthorp, husbandman 0
4940232 2338975 2338975 defendant Heryng William "coser or cofer" 592913 592913 Heryng, William, of Hoggesthorp, "coser or cofer" 0
4950149 2342013 2342013 defendant Pynder Richard husbandman 592913 592913 Pynder, Richard, of Hoggesthorp, husbandman 0
4959018 2344664 2344664 defendant Archer Robert husbandman 592913 592913 Archer, Robert, of Hoggesthorp, husbandman 0
4965692 2346663 2346663 defendant Spark Thomas husbandman 592913 592913 Spark, Thomas, of Hoggesthorp, husbandman 2
4979133 2350716 2350716 defendant Godard Anne widow 592913 592913 Godard, Anne, of Hoggesthorp, widow 0
5014910 2361237 2361237 defendant Cracroft William gent 592913 592913 Cracroft, William, of Hoggesthorp, gent 0
5039527 2368471 2368471 defendant Cracroft William gent 592913 592913 Cracroft, William, of Hoggesthorp, gent 2
5051231 2371983 2371983 defendant Morton Walter gent 592913 592913 Morton, Walter, of Hoggesthorp, gent 0
5083200 2381472 2381472 defendant Bough Walter husbandman 592913 592913 Bough, Walter, of Hoggesthorp, husbandman 2
5084908 2381994 2381994 defendant Cheles William husbandman 592913 592913 Cheles, William, of Hoggesthorp, husbandman 0
5108161 2388822 2388822 defendant Bough Walter husbandman 592913 592913 Bough, Walter, of Hoggesthorp, husbandman 7
5110406 2389446 2389446 defendant Skrevyn William weaver 592913 592913 Skrevyn, William, of Hoggesthorp, weaver 0
5110407 2389446 2389446 defendant Cheles William husbandman 592913 592913 Cheles, William, of Hoggesthorp, husbandman 1
5110408 2389446 2389446 defendant Sik Richard husbandman 592913 592913 Sik, Richard, of Hoggesthorp, husbandman 2
5116333 2391208 2391208 defendant Skrevyn William weaver 592913 592913 Skrevyn, William, of Hoggesthorp, weaver 0
5116334 2391208 2391208 defendant Cheles William husbandman 592913 592913 Cheles, William, of Hoggesthorp, husbandman 1
5116335 2391208 2391208 defendant Sik Richard husbandman 592913 592913 Sik, Richard, of Hoggesthorp, husbandman 2
5191938 2413374 2413374 defendant Sheles William husbandman 592913 592913 Sheles, William, of Hoggesthorp, husbandman 0
5196328 2414676 2414676 defendant Cracrofte John gent 592913 592913 Cracrofte, John, of Hoggesthorp, gent 0
5209593 2418546 2418546 defendant Cracrofte John gent 592913 592913 Cracrofte, John, of Hoggesthorp, gent 0
5230420 2424512 2424512 defendant Merewyn John husbandman 592913 592913 Merewyn, John, of Hoggesthorp, husbandman 0
5253468 2431186 2431186 defendant Bocher Robert butcher 592913 592913 Bocher, Robert, of Hoggesthorp, butcher 1
5261875 2433823 2433823 defendant Cheles William husbandman 592913 592913 Cheles, William, of Hoggesthorp, husbandman 0
5272089 2436918 2436918 defendant Cheles William husbandman 592913 592913 Cheles, William, of Hoggesthorp, husbandman 1
5281774 2439743 2439743 plaintiff Cracroft John   592913 592913 Cracroft, John, of Hoggesthorp 0
5294198 2443274 2443274 defendant Gracroft John gent 592913 592913 Gracroft, John, of Hoggesthorp, gent 5
5294208 2443275 2443275 defendant Gracroft John gent 592913 592913 Gracroft, John, of Hoggesthorp, gent 5
5326344 2452967 2452967 defendant Cracroft John gent 592913 592913 Cracroft, John, of Hoggesthorp, gent 6
5326354 2452968 2452968 defendant Cracroft John gent 592913 592913 Cracroft, John, of Hoggesthorp, gent 6
5337852 2456403 2456403 defendant More Simon butcher 592913 592913 More, Simon, of Hoggesthorp, butcher 0
5337853 2456403 2456403 defendant More William laborer 592913 592913 More, William, of Hoggesthorp, laborer 1
5345353 2458720 2458720 defendant Faremanseven Thomas husbandman 592913 592913 Faremanseven, Thomas, of Hoggesthorp, husbandman 0
5353749 2461239 2461239 defendant Chubbe William laborer 592913 592913 Chubbe, William, of Hoggesthorp, laborer 0
5379261 2469108 2469108 defendant Kyrkeman Thomas husbandman 592913 592913 Kyrkeman, Thomas, of Hoggesthorp, husbandman 0
5445765 2488620 2488620 defendant Cheles Christopher yeoman 592913 592913 Cheles, Christopher, of Hoggesthorp, yeoman 0
5458503 2492436 2492436 defendant Cheles Christopher yeoman 592913 592913 Cheles, Christopher, of Hoggesthorp, yeoman 0
5470143 2495986 2495986 defendant Cheles Christopher yeoman 592913 592913 Cheles, Christopher, of Hoggesthorp, yeoman 0
5484429 2500260 2500260 defendant Cheles William husbandman 592913 592913 Cheles, William, of Hoggesthorp, husbandman 0
5484432 2500260 2500260 defendant Cheles Christopher husbandman 592913 592913 Cheles, Christopher, of Hoggesthorp, husbandman 3
5530252 2513970 2513970 defendant Kyrhman Richard husbandman 592913 592913 Kyrhman, Richard, of Hoggesthorp, husbandman 2
5530255 2513970 2513970 defendant Calffe Walter husbandman 592913 592913 Calffe, Walter, of Hoggesthorp, husbandman 5
5600743 2535119 2535119 defendant Cracroft Richard yeoman 592913 592913 Cracroft, Richard, of Hoggesthorp, yeoman 1
5606042 2536778 2536778 defendant Mekylbarough Robert glasier 592913 592913 Mekylbarough, Robert, of Hoggesthorp, glasier 1
5622113 2550829 2550829 plaintiff Tours Hugh   592913 592913 Tours, Hugh, of Hoggesthorp 0
5622114 2550829 2550829 defendant Blaykester William chaplain 592913 592913 Blaykester, William, of Hoggesthorp, chaplain 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);