names

60 rows where place_id = 586399

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588621 1864085 1864085 defendant Drake Thomas laborer 586399 586399 Drake, Thomas, of Magna Wychyngham, laborer 0
3588626 1864085 1864085 defendant Myldram Margaret widow 586399 586399 Myldram, Margaret, of Magna Wychyngham, widow 5
3588633 1864088 1864088 defendant Drake Thomas laborer 586399 586399 Drake, Thomas, of Magna Wychyngham, laborer 0
3588638 1864088 1864088 defendant Myldram Margaret widow 586399 586399 Myldram, Margaret, of Magna Wychyngham, widow 5
3616371 1872759 1872759 defendant Dey John husbandman 586399 586399 Dey, John, of Magna Wychyngham, husbandman 1
3757940 1944465 1944465 defendant Fary William   586399 586399 Fary, William, of Magna Wychyngham, worsted weaver 4
3769326 1948063 1948063 defendant Frary John yeoman 586399 586399 Frary, John, of Magna Wychyngham, yeoman 0
3770382 1948412 1948412 defendant Basset John   586399 586399 Basset, John, of Magna Wychyngham, coverlet weaver 1
3782495 1952270 1952270 defendant Frary Richard   586399 586399 Frary, Richard, of Magna Wychyngham, plough wright 0
3867180 1979260 1979260 defendant Smyth Henry husbandman 586399 586399 Smyth, Henry, of Magna Wychyngham, husbandman 0
3867183 1979261 1979261 defendant Frary William   586399 586399 Frary, William, of Magna Wychyngham, worsted weaver 0
3867184 1979261 1979261 defendant Beclys Robert husbandman 586399 586399 Beclys, Robert, of Magna Wychyngham, husbandman 1
3867185 1979261 1979261 defendant Frary Anne widow 586399 586399 Frary, Anne, of Magna Wychyngham, widow 2
3876252 1982299 1982299 defendant Frary Robert husbandman 586399 586399 Frary, Robert, of Magna Wychyngham, husbandman 1
3876253 1982299 1982299 defendant Frary John husbandman 586399 586399 Frary, John, of Magna Wychyngham, husbandman 2
3876254 1982299 1982299 defendant Frary Richard husbandman 586399 586399 Frary, Richard, of Magna Wychyngham, husbandman 3
3876257 1982300 1982300 defendant Frary Robert husbandman 586399 586399 Frary, Robert, of Magna Wychyngham, husbandman 1
3876258 1982300 1982300 defendant Frary John husbandman 586399 586399 Frary, John, of Magna Wychyngham, husbandman 2
3876259 1982300 1982300 defendant Frary Richard husbandman 586399 586399 Frary, Richard, of Magna Wychyngham, husbandman 3
3880787 1983840 1983840 defendant Frary Robert yeoman 586399 586399 Frary, Robert, of Magna Wychyngham, yeoman 0
3880970 1983905 1983905 defendant Frary Anne widow 586399 586399 Frary, Anne, of Magna Wychyngham, widow 2
3880971 1983905 1983905 defendant Frary William husbandman 586399 586399 Frary, William, of Magna Wychyngham, husbandman 3
3883971 1984908 1984908 defendant Frary Richard husbandman 586399 586399 Frary, Richard, of Magna Wychyngham, husbandman 2
3883975 1984909 1984909 defendant Frary Nicholas husbandman 586399 586399 Frary, Nicholas, of Magna Wychyngham, husbandman 2
3886433 1985715 1985715 defendant Rysyng John yeoman 586399 586399 Rysyng, John, of Magna Wychyngham, yeoman 1
3888520 1986417 1986417 defendant Frary Robert yeoman 586399 586399 Frary, Robert, of Magna Wychyngham, yeoman 0
3888521 1986417 1986417 defendant Frary John, senior yeoman 586399 586399 Frary, John, senior, of Magna Wychyngham, yeoman 1
3896138 1988912 1988912 defendant Rysyng John husbandman 586399 586399 Rysyng, John, of Magna Wychyngham, husbandman 2
3898503 1989713 1989713 defendant Frary John husbandman 586399 586399 Frary, John, of Magna Wychyngham, husbandman 0
3898504 1989713 1989713 defendant Frary Robert husbandman 586399 586399 Frary, Robert, of Magna Wychyngham, husbandman 1
3898505 1989713 1989713 defendant Harman Edward husbandman 586399 586399 Harman, Edward, of Magna Wychyngham, husbandman 2
3917824 1996322 1996322 defendant Davy Robert husbandman 586399 586399 Davy, Robert, of Magna Wychyngham, husbandman 0
3917825 1996322 1996322 defendant Frary William husbandman 586399 586399 Frary, William, of Magna Wychyngham, husbandman 1
3922062 1997712 1997712 defendant Davy Robert husbandman 586399 586399 Davy, Robert, of Magna Wychyngham, husbandman 3
3962343 2011413 2011413 defendant Browne Thomas husbandman 586399 586399 Browne, Thomas, of Magna Wychyngham, husbandman 0
3970599 2014305 2014305 defendant Jacobbe William yeoman 586399 586399 Jacobbe, William, of Magna Wychyngham, yeoman 2
3978887 2017200 2017200 defendant Garneham Thomas husbandman 586399 586399 Garneham, Thomas, of Magna Wychyngham, husbandman 0
4096232 2058979 2058979 defendant Leman John butcher 586399 586399 Leman, John, of Magna Wychyngham, butcher 0
4129233 2070758 2070758 defendant Braye Thomas yeoman 586399 586399 Braye, Thomas, of Magna Wychyngham, or of North Tuddenham, yeoman 1
4142938 2075702 2075702 defendant Braye Thomas husbandman 586399 586399 Braye, Thomas, of Magna Wychyngham, husbandman 0
4168565 2084489 2084489 defendant Tyler Henry miller 586399 586399 Tyler, Henry, of Magna Wychyngham, miller 2
4168566 2084489 2084489 defendant Tyler Giles miller 586399 586399 Tyler, Giles, of Magna Wychyngham, miller 3
4790022 2292952 2292952 defendant Miller Lawrence   586399 586399 Miller, Lawrence, of Magna Wychyngham 3
4874399 2318935 2318935 defendant Small Ralph smith 586399 586399 Small, Ralph, of Magna Wychyngham, smith 0
4945030 2340430 2340430 defendant Barboure William yeoman 586399 586399 Barboure, William, of Magna Wychyngham, yeoman 0
5026364 2364599 2364599 defendant Feltwell Richard yeoman 586399 586399 Feltwell, Richard, of Magna Wychyngham, yeoman 0
5026367 2364600 2364600 defendant Feltwell Robert yeoman 586399 586399 Feltwell, Robert, of Magna Wychyngham, yeoman 0
5029645 2365539 2365539 defendant Wegge John husbandman 586399 586399 Wegge, John, of Magna Wychyngham, husbandman 0
5029646 2365539 2365539 defendant Feltewell Robert husbandman 586399 586399 Feltewell, Robert, of Magna Wychyngham, husbandman 1
5035930 2367365 2367365 defendant Berney John esq 586399 586399 Berney, John, of Magna Wychyngham, esq 0
5035931 2367365 2367365 defendant Wysdam Stephen   586399 586399 Wysdam, Stephen, of Magna Wychyngham, shepherd 1
5067563 2376795 2376795 defendant Berney John esq 586399 586399 Berney, John, of Magna Wychyngham, esq 0
5070446 2377653 2377653 defendant Wokkys Thomas yeoman 586399 586399 Wokkys, Thomas, of Magna Wychyngham, yeoman 0
5116099 2391135 2391135 defendant Cleye Richard yeoman 586399 586399 Cleye, Richard, of Magna Wychyngham, yeoman 1
5116100 2391135 2391135 defendant Hoo Bartholomew   586399 586399 Hoo, Bartholomew, of Magna Wychyngham, shepherd 2
5527817 2513269 2513269 defendant Est John husbandman 586399 586399 Est, John, of Magna Wychyngham, husbandman 0
5527818 2513269 2513269 defendant Dey John husbandman 586399 586399 Dey, John, of Magna Wychyngham, husbandman 1
5536042 2515771 2515771 defendant Bevys or Benys John husbandman 586399 586399 Bevys or Benys, John, of Magna Wychyngham, husbandman 2
5567529 2525074 2525074 defendant Frary John husbandman 586399 586399 Frary, John, of Magna Wychyngham, husbandman 4
5597182 2534024 2534024 defendant Bacon William husbandman 586399 586399 Bacon, William, of Magna Wychyngham, 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);