names

59 rows where place_id = 598130

✎ 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
3631263 1904592 1904592 defendant Gateward John   598130 598130 Gateward, John, of Saxton 29
3679325 1919594 1919594 defendant Mosse John laborer 598130 598130 Mosse, John, of Saxton, laborer 0
3716608 1931491 1931491 defendant Hungate William esq 598130 598130 Hungate, William, of Saxton, esq 0
3735245 1937257 1937257 defendant Yole Thomas husbandman 598130 598130 Yole, Thomas, of Saxton, husbandman 2
3773714 1949495 1949495 defendant Mosse John laborer 598130 598130 Mosse, John, of Saxton, laborer 2
3786990 1953734 1953734 defendant Hondgaytt William esq 598130 598130 Hondgaytt, William, of Saxton, esq 0
3827905 1966591 1966591 defendant Hungate Thomas gent 598130 598130 Hungate, Thomas, of Saxton, gent 0
3933810 2001602 2001602 defendant Lacok William husbandman 598130 598130 Lacok, William, of Saxton, husbandman 2
3933811 2001602 2001602 defendant Danyell Robert husbandman 598130 598130 Danyell, Robert, of Saxton, husbandman 3
4003781 2026119 2026119 plaintiff Hungaite Thomas esq 598130 598130 Hungaite, Thomas, of Saxton, esq 0
4003789 2026120 2026120 plaintiff Hungaite Thomas esq 598130 598130 Hungaite, Thomas, of Saxton, esq 0
4044301 2040415 2040415 plaintiff Rawlyns John gent 598130 598130 Rawlyns, John, of Saxton, gent 0
4044302 2040415 2040415 defendant Armestrong John husbandman 598130 598130 Armestrong, John, of Saxton, husbandman 0
4048321 2041844 2041844 defendant Calbecke Robert warrener 598130 598130 Calbecke, Robert, of Saxton, warrener 0
4066999 2048494 2048494 plaintiff Hungate William esq 598130 598130 Hungate, William, of Saxton, esq 0
4093029 2057821 2057821 defendant Hungate Robert (legal representative) 598130 598130 Hungate, Robert, of Saxton, gent, executrix of 0
4093030 2057821 2057821 defendant Hungate Margaret widow 598130 598130 Hungate, Margaret, of Saxton, widow 1
4093032 2057822 2057822 defendant Hungate Robert (legal representative) 598130 598130 Hungate, Robert, of Saxton, gent, executrix of 0
4093033 2057822 2057822 defendant Hungate Margaret widow 598130 598130 Hungate, Margaret, of Saxton, widow 1
4099348 2060092 2060092 plaintiff Hungate William esq 598130 598130 Hungate, William, of Saxton, esq 0
4101966 2061013 2061013 defendant Gacton Robert laborer 598130 598130 Gacton, Robert, of Saxton, laborer 0
4101967 2061013 2061013 defendant Sharpins Nicholas laborer 598130 598130 Sharpins, Nicholas, of Saxton, laborer 1
4155277 2079939 2079939 defendant Gayton Robert laborer 598130 598130 Gayton, Robert, of Saxton, laborer 0
4283035 2123965 2123965 defendant Sympson Robert yeoman 598130 598130 Sympson, Robert, of Saxton, yeoman 2
4395768 2163169 2163169 defendant Pott John husbandman 598130 598130 Pott, John, of Saxton, husbandman 0
4459109 2187893 2187893 defendant Bertelot Robert   598130 598130 Bertelot, Robert, of Saxton 2
4459214 2187926 2187926 defendant Bertelott Robert   598130 598130 Bertelott, Robert, of Saxton 2
4504010 2201809 2201809 defendant Basset John   598130 598130 Basset, John, of Saxton 5
4604639 2232614 2232614 defendant Ledes Alexander de   598130 598130 Ledes, Alexander de, of Saxton 0
4610519 2234359 2234359 defendant Colman Nicholas ploughman 598130 598130 Colman, Nicholas, of Saxton, ploughman 5
4632501 2241055 2241055 defendant Ledes Alexander de   598130 598130 Ledes, Alexander de, of Saxton 0
4641535 2243622 2243622 defendant Tomlynson Richard   598130 598130 Tomlynson, Richard, of Saxton 2
4660612 2249145 2249145 defendant Lese or Lefe John husbandman 598130 598130 Lese or Lefe, John, of Saxton, husbandman 0
4660615 2249145 2249145 defendant Grene Henry   598130 598130 Grene, Henry, of Saxton, ploughwright 3
4660616 2249145 2249145 defendant Glovere John carpenter 598130 598130 Glovere, John, of Saxton, carpenter 4
4660617 2249145 2249145 defendant Gateward Robert barker 598130 598130 Gateward, Robert, of Saxton, barker 5
4660620 2249146 2249146 defendant Edlyn John (legal representative) 598130 598130 Edlyn, John, of Saxton, executors of 0
4765964 2285346 2285346 defendant Bedale William laborer 598130 598130 Bedale, William, of Saxton, laborer 2
4765965 2285346 2285346 defendant Belvas Robert husbandman 598130 598130 Belvas, Robert, of Saxton, husbandman 3
4840667 2308622 2308622 defendant Colman Nicholas husbandman 598130 598130 Colman, Nicholas, of Saxton, husbandman 0
4877198 2319827 2319827 defendant Sallay Robert gent 598130 598130 Sallay, Robert, of Saxton, gent 0
4879628 2320553 2320553 defendant Belnas Robard husbandman 598130 598130 Belnas, Robard, of Saxton, husbandman 0
4879629 2320553 2320553 defendant Morley John chaplain 598130 598130 Morley, John, of Saxton, chaplain 1
4939551 2338755 2338755 defendant Percyvall John (legal representative) 598130 598130 Percyvall, John, of Saxton, executors of 4
4989420 2353771 2353771 defendant Aston John yeoman 598130 598130 Aston, John, of Saxton, yeoman 3
5313770 2449145 2449145 defendant Bartlot Thomas husbandman 598130 598130 Bartlot, Thomas, of Saxton, husbandman 0
5313771 2449145 2449145 defendant Gedney John husbandman 598130 598130 Gedney, John, of Saxton, husbandman 1
5363797 2464329 2464329 defendant Bartelot Robert husbandman 598130 598130 Bartelot, Robert, of Saxton, husbandman 1
5379742 2469246 2469246 defendant Yong Baldwin gent 598130 598130 Yong, Baldwin, of Saxton, gent 0
5395372 2473750 2473750 defendant Kebill John yeoman 598130 598130 Kebill, John, of Saxton, yeoman 1
5531318 2514315 2514315 defendant Taury or Tanry John chaplain 598130 598130 Taury or Tanry, John, of Saxton, chaplain 0
5568141 2525229 2525229 defendant Hungate William esq 598130 598130 Hungate, William, of Saxton, esq 2
5582782 2529687 2529687 defendant Hungate William esq 598130 598130 Hungate, William, of Saxton, esq 2
5608199 2537465 2537465 defendant Adam Thomas husbandman 598130 598130 Adam, Thomas, of Saxton, husbandman 7
5608200 2537465 2537465 defendant Lofte or Loste Thomas husbandman 598130 598130 Lofte or Loste, Thomas, of Saxton, husbandman 8
5608201 2537465 2537465 defendant Pare Robert husbandman 598130 598130 Pare, Robert, of Saxton, husbandman 9
5608202 2537465 2537465 defendant Skelton Robert husbandman 598130 598130 Skelton, Robert, of Saxton, husbandman 10
5608203 2537465 2537465 defendant taytt Robert husbandman 598130 598130 taytt, Robert, of Saxton, husbandman 11
5608204 2537465 2537465 defendant Yoyll Robert husbandman 598130 598130 Yoyll, Robert, of Saxton, husbandman 12

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);