names

48 rows where place_id = 595949

✎ 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
3622490 1874572 1874572 defendant Berkeworth John husbandman 595949 595949 Berkeworth, John, of Belcheford, husbandman 0
3656343 1912229 1912229 defendant Nelson William husbandman 595949 595949 Nelson, William, of Belcheford, husbandman 0
3656347 1912230 1912230 defendant Nelson William husbandman 595949 595949 Nelson, William, of Belcheford, husbandman 0
3683776 1921061 1921061 defendant Neylson William husbandman 595949 595949 Neylson, William, of Belcheford, husbandman 0
3683777 1921061 1921061 defendant Broune Walter husbandman 595949 595949 Broune, Walter, of Belcheford, husbandman 1
3683779 1921061 1921061 defendant Tyndale John yeoman 595949 595949 Tyndale, John, of Belcheford, yeoman 3
3704779 1927785 1927785 defendant Nelson Miles yeoman 595949 595949 Nelson, Miles, of Belcheford, yeoman 1
3709314 1929211 1929211 defendant Dawson Alban smith 595949 595949 Dawson, Alban, of Belcheford, smith 0
3709315 1929211 1929211 defendant Leche Robert chaplain 595949 595949 Leche, Robert, of Belcheford, chaplain 1
3739159 1938459 1938459 defendant Leche Robert husbandman 595949 595949 Leche, Robert, of Belcheford, husbandman 0
3876898 1982515 1982515 defendant Ferfurth Thomas husbandman 595949 595949 Ferfurth, Thomas, of Belcheford, husbandman 0
3917789 1996309 1996309 defendant Harryson Richard husbandman 595949 595949 Harryson, Richard, of Belcheford, husbandman 0
3931293 2000755 2000755 defendant Fereby Barnard laborer 595949 595949 Fereby, Barnard, of Belcheford, laborer 9
3931294 2000755 2000755 defendant Farebarn Joan spinster 595949 595949 Farebarn, Joan, of Belcheford, spinster 10
3931298 2000756 2000756 defendant Ferreby Barnard laborer 595949 595949 Ferreby, Barnard, of Belcheford, laborer 2
3932091 2001037 2001037 defendant Wawson John husbandman 595949 595949 Wawson, John, of Belcheford, husbandman 0
3987547 2020296 2020296 defendant Dawson John husbandman 595949 595949 Dawson, John, of Belcheford, husbandman 2
4177507 2087610 2087610 defendant Barkeworthe Christopher yeoman 595949 595949 Barkeworthe, Christopher, of Belcheford, yeoman 0
4177508 2087610 2087610 defendant Barkeworthe Robert yeoman 595949 595949 Barkeworthe, Robert, of Belcheford, yeoman 1
4621179 2237614 2237614 defendant Burton William de   595949 595949 Burton, William de, of Belcheford 0
4695543 2264090 2264090 defendant Grove John, sen husbandman 595949 595949 Grove, John, sen, of Belcheford, husbandman 1
4738503 2277134 2277134 defendant Grayne William husbandman 595949 595949 Grayne, William, of Belcheford, husbandman 1
4805409 2297896 2297896 defendant Knyght Henry husbandman 595949 595949 Knyght, Henry, of Belcheford, husbandman 3
4815798 2301045 2301045 defendant Vale William clerk 595949 595949 Vale, William, of Belcheford, clerk 0
4820506 2302485 2302485 defendant Grene John husbandman 595949 595949 Grene, John, of Belcheford, husbandman 0
4858521 2314039 2314039 defendant Knygth Henry husbandman 595949 595949 Knygth, Henry, of Belcheford, husbandman 3
4886189 2322542 2322542 defendant Knyght Henry husbandman 595949 595949 Knyght, Henry, of Belcheford, husbandman 0
4895558 2325280 2325280 defendant Knyght Henry husbandman 595949 595949 Knyght, Henry, of Belcheford, husbandman 0
4916828 2331767 2331767 defendant West John husbandman 595949 595949 West, John, of Belcheford, husbandman 3
4928291 2335274 2335274 defendant Morsby William husbandman 595949 595949 Morsby, William, of Belcheford, husbandman 2
4940265 2338981 2338981 defendant S-----sby Thomas husbandman 595949 595949 S-----sby, Thomas, of Belcheford, husbandman 3
4967944 2347356 2347356 defendant Calceby Thomas husbandman 595949 595949 Calceby, Thomas, of Belcheford, husbandman 0
5026228 2364563 2364563 defendant West John husbandman 595949 595949 West, John, of Belcheford, husbandman 3
5090706 2383667 2383667 plaintiff Merycok John   595949 595949 Merycok, John, of Belcheford 0
5098780 2386073 2386073 defendant Boulder Beatrice widow 595949 595949 (Boulder, Beatrice, of Belcheford, widow 1
5115038 2390816 2390816 defendant West John husbandman 595949 595949 West, John, of Belcheford, husbandman 1
5115063 2390823 2390823 plaintiff Merycok John   595949 595949 Merycok, John, of Belcheford 0
5218637 2421179 2421179 plaintiff Grene Thomas husbandman 595949 595949 Grene, Thomas, of Belcheford, husbandman 0
5226212 2423330 2423330 defendant West John husbandman 595949 595949 West, John, of Belcheford, husbandman 3
5302175 2445608 2445608 defendant Aleby Richard husbandman 595949 595949 Aleby, Richard, of Belcheford, husbandman 1
5311353 2448427 2448427 defendant Aleby Richard husbandman 595949 595949 Aleby, Richard, of Belcheford, husbandman 1
5316945 2450147 2450147 defendant Aleby Richard husbandman 595949 595949 Aleby, Richard, of Belcheford, husbandman 0
5344844 2458548 2458548 defendant Leese William husbandman 595949 595949 Leese, William, of Belcheford, husbandman 2
5416442 2479837 2479837 defendant Gye Geoffrey husbandman 595949 595949 Gye, Geoffrey, of Belcheford, husbandman 0
5502451 2505685 2505685 defendant Tyndale Richard yeoman 595949 595949 Tyndale, Richard, of Belcheford, yeoman 2
5515832 2509798 2509798 defendant Barkworth Henry husbandman 595949 595949 Barkworth, Henry, of Belcheford, husbandman 0
5516945 2510125 2510125 defendant Gye Geoffrey yeoman 595949 595949 Gye, Geoffrey, of Belcheford, yeoman 1
5569746 2525721 2525721 defendant Smyth Thomas yeoman 595949 595949 Smyth, Thomas, of Belcheford, yeoman 8

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