names

46 rows where place_id = 593312

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611308 1871211 1871211 defendant Dubbert Richard yeoman 593312 593312 Dubbert, Richard, of Seford, yeoman 0
3611309 1871211 1871211 defendant Pupper Thomas husbandman 593312 593312 Pupper, Thomas, of Seford, husbandman 1
3611310 1871211 1871211 defendant Seman Nicholas husbandman 593312 593312 Seman, Nicholas, of Seford, husbandman 2
3611311 1871211 1871211 defendant Randley John husbandman 593312 593312 Randley, John, of Seford, husbandman 3
3611312 1871211 1871211 defendant Facy Robert husbandman 593312 593312 Facy, Robert, of Seford, husbandman 4
3611313 1871211 1871211 defendant Seman William husbandman 593312 593312 Seman, William, of Seford, husbandman 5
3611314 1871211 1871211 defendant Halle John husbandman 593312 593312 Halle, John, of Seford, husbandman 6
3718104 1931951 1931951 defendant Tyseherst Hamond yeoman 593312 593312 Tyseherst, Hamond, of Seford, yeoman 4
3772929 1949234 1949234 defendant Gratewyk Nicholas yeoman 593312 593312 Gratewyk, Nicholas, of Seford, yeoman 0
3790580 1954877 1954877 defendant Okynden John yeoman 593312 593312 Okynden, John, of Seford, yeoman 0
4426965 2173257 2173257 defendant Taverner Simon le   593312 593312 Taverner, Simon le, of Seford 1
4451964 2185596 2185596 defendant Clevere John passeger 593312 593312 Clevere, John, of Seford, passeger 1
4454051 2186281 2186281 defendant Selkedenne Robert   593312 593312 Selkedenne, Robert, of Seford 0
4509644 2203494 2203494 defendant Horcombe Robert   593312 593312 Horcombe, Robert, of Seford 0
4544011 2214037 2214037 defendant Lawusleneye John   593312 593312 Lawusleneye, John, of Seford 2
4544012 2214037 2214037 defendant Hogg John   593312 593312 Hogg, John, of Seford 3
4544013 2214037 2214037 defendant Fowhyll Richard   593312 593312 Fowhyll, Richard, of Seford 4
4555182 2217555 2217555 defendant Slegh Thomas   593312 593312 Slegh, Thomas, of Seford 0
4571574 2222688 2222688 defendant atte Grene William   593312 593312 atte Grene, William, of Seford 1
4571575 2222688 2222688 defendant Clerk William   593312 593312 Clerk, William, of Seford 2
4663956 2250210 2250210 defendant Melward John husbandman 593312 593312 Melward, John, of Seford, husbandman 0
4663957 2250210 2250210 defendant Dreye John laborer 593312 593312 Dreye, John, of Seford, laborer 1
4665715 2250749 2250749 defendant Boteman David shipman 593312 593312 Boteman, David, of Seford, shipman 2
4665716 2250749 2250749 defendant Clever Simon boatman 593312 593312 Clever, Simon, of Seford, boatman 3
4708169 2267933 2267933 defendant Lyecestre JOhn tailor 593312 593312 Lyecestre, JOhn, of Seford, tailor 0
4721800 2272151 2272151 defendant Averay John husbandman 593312 593312 Averay, John, of Seford, husbandman 1
4725254 2273190 2273190 defendant Noble John laborer 593312 593312 Noble, John, of Seford, laborer 0
4725255 2273190 2273190 defendant Man Thomas shipman 593312 593312 Man, Thomas, of Seford, shipman 1
4725256 2273190 2273190 defendant Baker Walter shipman 593312 593312 Baker, Walter, of Seford, shipman 2
4744767 2278985 2278985 defendant Averay John husbandman 593312 593312 Averay, John, of Seford, husbandman 0
4744768 2278985 2278985 defendant Eseman John husbandman 593312 593312 Eseman, John, of Seford, husbandman 1
4744769 2278985 2278985 defendant Hothere John   593312 593312 Hothere, John, of Seford, mason 2
4750606 2280663 2280663 defendant Baker Walter shipman 593312 593312 Baker, Walter, of Seford, shipman 0
4787356 2292116 2292116 defendant Dreye Philip   593312 593312 Dreye, Philip, of Seford, shepherd 3
4787362 2292117 2292117 defendant Dreys Philip   593312 593312 Dreys, Philip, of Seford, shepherd 3
4791093 2293312 2293312 defendant Ryche John laborer 593312 593312 Ryche, John, of Seford, laborer 0
4866205 2316401 2316401 defendant Whyte William husbandman 593312 593312 Whyte, William, of Seford, husbandman 1
4916046 2331520 2331520 defendant Fycas or Fytas John shipman 593312 593312 Fycas or Fytas, John, of Seford, shipman 1
5013112 2360665 2360665 defendant Bernevale Simon husbandman 593312 593312 Bernevale, Simon, of Seford, husbandman 0
5013113 2360665 2360665 defendant Crowelyng John shipman 593312 593312 Crowelyng, John, of Seford, shipman 1
5102297 2387089 2387089 defendant Walkelyn John husbandman 593312 593312 Walkelyn, John, of Seford, husbandman 0
5113205 2390258 2390258 defendant atte Wode Robert husbandman 593312 593312 atte Wode, Robert, of Seford, husbandman 4
5302746 2445804 2445804 defendant Holbem John husbandman 593312 593312 Holbem, John, of Seford, husbandman 0
5472921 2496857 2496857 defendant Seman Nicholas husbandman 593312 593312 Seman, Nicholas, of Seford, husbandman 0
5612816 2547765 2547765 defendant Chapman John   593312 593312 Chapman, John, of Seford 0
5617724 2549372 2549372 defendant Seweden Robert   593312 593312 Seweden, Robert, of Seford 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);