names

81 rows where place_id = 598487

✎ 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
3632740 1905053 1905053 defendant Ramesey John husbandman 598487 598487 Ramesey, John, of Marum, husbandman 0
3632741 1905053 1905053 defendant Sawyer Matilda widow 598487 598487 Sawyer, Matilda, of Marum, widow 1
3632742 1905053 1905053 defendant Wylson John husbandman 598487 598487 Wylson, John, of Marum, husbandman 2
3711081 1929777 1929777 defendant Bracebryg Robert, senior husbandman 598487 598487 Bracebryg, Robert, senior, of Marum, husbandman 0
3711082 1929777 1929777 defendant Adam Christopher husbandman 598487 598487 Adam, Christopher, of Marum, husbandman 1
3807074 1960105 1960105 defendant Thewston John husbandman 598487 598487 Thewston, John, of Marum, husbandman 0
3861888 1977435 1977435 defendant Wylberd William butcher 598487 598487 Wylberd, William, of Marum, butcher 2
3951085 2007446 2007446 plaintiff Gray William glover 598487 598487 Gray, William, of Marum, glover 0
4449737 2184868 2184868 defendant Close- John clerk 598487 598487 Close-, John, of Marum, clerk 0
4468645 2190865 2190865 defendant Foston Robert de   598487 598487 Foston, Robert de, of Marum 0
4468646 2190865 2190865 defendant Skynner William   598487 598487 Skynner, William, of Marum 1
4468647 2190865 2190865 defendant Wright Robert   598487 598487 with Wright, Robert, of Marum 2
4479234 2194160 2194160 defendant Penne William   598487 598487 Penne, William, of Marum 0
4482096 2195112 2195112 defendant Felton Robert   598487 598487 Felton, Robert, of Marum 0
4484288 2195787 2195787 defendant Bare Robert   598487 598487 Bare, Robert, of Marum 0
4489961 2197569 2197569 defendant Hardy William   598487 598487 Hardy, William, of Marum 0
4489962 2197569 2197569 defendant Penne John   598487 598487 Penne, John, of Marum 1
4500917 2200907 2200907 defendant Pynder William   598487 598487 Pynder, William, of Marum 1
4505705 2202293 2202293 defendant Walker William   598487 598487 Walker, William, of Marum 0
4516224 2205482 2205482 defendant Bothe Rober de   598487 598487 Bothe, Rober de, of Marum 1
4531477 2210121 2210121 plaintiff Penne William   598487 598487 Penne, William, of Marum 0
4531478 2210121 2210121 defendant Toft William   598487 598487 Toft, William, of marum 0
4541202 2213145 2213145 defendant tote Walter weaver 598487 598487 tote, Walter, of Marum, weaver 0
4541498 2213236 2213236 defendant Whyttop Simon   598487 598487 Whyttop, Simon, of Marum 0
4549825 2215879 2215879 plaintiff Couton John   598487 598487 Couton, John, of Marum 0
4553798 2217113 2217113 defendant Tote Walter   598487 598487 Tote, Walter, of Marum 0
4554675 2217389 2217389 defendant Blisset Richard   598487 598487 Blisset, Richard, of Marum 1
4557179 2218180 2218180 defendant Henker William   598487 598487 Henker, William, of Marum 0
4557180 2218180 2218180 defendant Pynder William   598487 598487 Pynder, William, of Marum 1
4559586 2218950 2218950 defendant Walker William   598487 598487 Walker, William, of Marum 1
4583231 2226179 2226179 defendant Canwyk William   598487 598487 Canwyk, William, of Marum 0
4583233 2226180 2226180 defendant Culton John   598487 598487 Culton, John, of Marum 0
4587285 2227430 2227430 defendant Blissot Richard   598487 598487 Blissot, Richard, of Marum 0
4657867 2248347 2248347 defendant Sturme John husbandman 598487 598487 Sturme, John, of Marum, husbandman 0
4657868 2248347 2248347 defendant Marsshall Richard husbandman 598487 598487 Marsshall, Richard, of Marum, husbandman 1
4657869 2248347 2248347 defendant Smyth Peter husbandman 598487 598487 Smyth, Peter, of Marum, husbandman 2
4660372 2249072 2249072 defendant de Kelsey Peter husbandman 598487 598487 de Kelsey, Peter, of Marum, husbandman 0
4688801 2262052 2262052 defendant Moise Walter husbandman 598487 598487 (Moise, Walter, of Marum, husbandman 1
4688802 2262052 2262052 defendant Crede Thomas husbandman 598487 598487 Crede, Thomas, of Marum, husbandman 2
4690700 2262638 2262638 defendant Kelsey Peter de husbandman 598487 598487 Kelsey, Peter de, of Marum, husbandman 0
4712579 2269252 2269252 defendant Chese William smith 598487 598487 Chese, William, of Marum, smith 2
4729505 2274440 2274440 defendant Ede Robert laborer 598487 598487 Ede, Robert, of Marum, laborer 1
4751786 2281014 2281014 defendant Toft Walter shoemaker 598487 598487 Toft, Walter, of Marum, shoemaker 0
4758224 2282946 2282946 defendant Colyn Thomas husbandman 598487 598487 Colyn, Thomas, of Marum, husbandman 0
4778897 2289375 2289375 defendant Grose Adam smith 598487 598487 Grose, Adam, of Marum, smith 0
4780431 2289878 2289878 defendant Colyn Thomas husbandman 598487 598487 Colyn, Thomas, of Marum, husbandman 0
4872897 2318476 2318476 defendant Douver or Donver Richard husbandman 598487 598487 Douver or Donver, Richard, of Marum, husbandman 1
4872899 2318477 2318477 defendant Webster William husbandman 598487 598487 Webster, William, of Marum, husbandman 0
4872900 2318477 2318477 defendant Mekenes Thomas husbandman 598487 598487 Mekenes, Thomas, of Marum, husbandman 1
4874691 2319028 2319028 defendant Harry Robert husbandman 598487 598487 Harry, Robert, of Marum, husbandman 3
4879491 2320513 2320513 defendant Cokson Walter husbandman 598487 598487 Cokson, Walter, of Marum, husbandman 8
4900045 2326644 2326644 defendant Tuly William husbandman 598487 598487 Tuly, William, of Marum, husbandman 2
4900729 2326867 2326867 defendant Pynder John husbandman 598487 598487 Pynder, John, of Marum, husbandman 0
4923585 2333811 2333811 defendant Foston Wakelin husbandman 598487 598487 Foston, Wakelin, of Marum, husbandman 0
4973729 2349096 2349096 defendant Hudson Robert yeoman 598487 598487 Hudson, Robert, of Marum, yeoman 4
5183638 2410948 2410948 defendant Grouse John baker 598487 598487 Grouse, John, of Marum, baker 0
5194832 2414230 2414230 defendant Fole William laborer 598487 598487 Fole, William, of Marum, laborer 0
5217211 2420769 2420769 defendant Walker William husbandman 598487 598487 Walker, William, of Marum, husbandman 2
5224871 2422945 2422945 defendant Est John husbandman 598487 598487 Est, John, of Marum, husbandman 0
5224874 2422946 2422946 defendant Est John husbandman 598487 598487 Est, John, of Marum, husbandman 0
5236433 2426249 2426249 defendant Grouse John husbandman 598487 598487 Grouse, John, of Marum, husbandman 2
5245622 2428878 2428878 defendant Foston Wakelin yeoman 598487 598487 Foston, Wakelin, of Marum, yeoman 1
5245683 2428896 2428896 defendant Groce Robert husbandman 598487 598487 Groce, Robert, of Marum, husbandman 0
5245685 2428897 2428897 defendant Walker William butcher 598487 598487 Walker, William, of Marum, butcher 0
5256979 2432314 2432314 defendant Grouse John husbandman 598487 598487 Grouse, John, of Marum, husbandman 2
5257389 2432433 2432433 defendant Robynson John husbandman 598487 598487 Robynson, John, of Marum, husbandman 1
5263722 2434403 2434403 defendant Blisset Robert butcher 598487 598487 Blisset, Robert, of Marum, butcher 0
5263733 2434407 2434407 defendant Est John husbandman 598487 598487 Est, John, of Marum, husbandman 0
5263735 2434408 2434408 defendant Est John husbandman 598487 598487 Est, John, of Marum, husbandman 0
5263737 2434409 2434409 defendant Est John husbandman 598487 598487 Est, John, of Marum, husbandman 0
5275684 2437954 2437954 plaintiff Stokes William chaplain 598487 598487 Stokes, William, of Marum, chaplain 0
5313697 2449127 2449127 defendant Tyler Philip husbandman 598487 598487 Tyler, Philip, of Marum, husbandman 1
5313698 2449127 2449127 defendant Bokette Robert husbandman 598487 598487 Bokette, Robert, of Marum, husbandman 2
5313699 2449127 2449127 defendant Cokes John husbandman 598487 598487 Cokes, John, of Marum, husbandman 3
5313700 2449127 2449127 defendant Est John husbandman 598487 598487 Est, John, of Marum, husbandman 4
5324481 2452408 2452408 defendant Bower Thomas yeoman 598487 598487 Bower, Thomas, of Marum, yeoman 0
5336516 2455993 2455993 defendant Williamson Henry gent 598487 598487 Williamson, Henry, of Marum, gent 0
5336517 2455993 2455993 defendant Bassenet William weaver 598487 598487 Bassenet, William, of Marum, weaver 1
5620018 2550122 2550122 defendant Goselyng John   598487 598487 Goselyng, John, of Marum 0
5631460 2553847 2553847 defendant de Kele John smith 598487 598487 de Kele, John, of Marum, smith 1
5633802 2554568 2554568 defendant Duse Robert husbandman 598487 598487 Duse, Robert, of Marum, husbandman 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);