names

44 rows where place_id = 594238

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615211 1872403 1872403 defendant Neweman John tanner 594238 594238 Neweman, John, of Byrlyng, tanner 2
3683989 1921124 1921124 defendant Myles Walter gent 594238 594238 Myles, Walter, of Byrlyng, gent 2
3689451 1922859 1922859 defendant Wesshnes John yeoman 594238 594238 Wesshnes, John, of Byrlyng, yeoman 0
3702006 1926883 1926883 plaintiff Bysshop William   594238 594238 Bysshop, William, of Byrlyng 0
3708314 1928895 1928895 defendant Ingler William yeoman 594238 594238 Ingler, William, of Byrlyng, yeoman 0
3715692 1931199 1931199 plaintiff Bysshopp William   594238 594238 Bysshopp, William, of Byrlyng 0
3717990 1931923 1931923 defendant Wesshnes John yeoman 594238 594238 Wesshnes, John, of Byrlyng, yeoman 0
3717992 1931923 1931923 defendant Wesshnes Thomas yeoman 594238 594238 Wesshnes, Thomas, of Byrlyng, yeoman 2
3717993 1931923 1931923 defendant Hamar John laborer 594238 594238 Hamar, John, of Byrlyng, laborer 3
3731143 1935965 1935965 plaintiff Bysshop William   594238 594238 Bysshop, William, of Byrlyng 0
3733822 1936832 1936832 defendant Escott Robert yeoman 594238 594238 Escott, Robert, of Byrlyng, yeoman 0
3733823 1936832 1936832 defendant Mascall William yeoman 594238 594238 Mascall, William, of Byrlyng, yeoman 1
3733824 1936832 1936832 defendant Hopper John yeoman 594238 594238 Hopper, John, of Byrlyng, yeoman 2
3747744 1941217 1941217 defendant Estet Robert yeoman 594238 594238 Estet, Robert, of Byrlyng, yeoman 0
3747745 1941217 1941217 defendant Marshall William yeoman 594238 594238 Marshall, William, of Byrlyng, yeoman 1
3747746 1941217 1941217 defendant Hopper John husbandman 594238 594238 Hopper, John, of Byrlyng, husbandman 2
3761605 1945644 1945644 defendant Escott Robert yeoman 594238 594238 Escott, Robert, of Byrlyng, yeoman 0
3761606 1945644 1945644 defendant Mascall William yeoman 594238 594238 Mascall, William, of Byrlyng, yeoman 1
3761607 1945644 1945644 defendant Hopper Philip yeoman 594238 594238 Hopper, Philip, of Byrlyng, yeoman 2
3773973 1949575 1949575 defendant Hamond Agnes widow 594238 594238 Hamond, Agnes, of Byrlyng, widow 0
3779801 1951414 1951414 defendant Escott Robert yeoman 594238 594238 Escott, Robert, of Byrlyng, yeoman 0
3779802 1951414 1951414 defendant Mascall William yeoman 594238 594238 Mascall, William, of Byrlyng, yeoman 1
3779803 1951414 1951414 defendant Hopper John yeoman 594238 594238 Hopper, John, of Byrlyng, yeoman 2
3794165 1956045 1956045 plaintiff Bysshopp William   594238 594238 Bysshopp, William, of Byrlyng 0
3864875 1978454 1978454 defendant Cotes Thomas husbandman 594238 594238 Cotes, Thomas, of Byrlyng, husbandman 0
3864876 1978454 1978454 defendant Bedell Edward husbandman 594238 594238 Bedell, Edward, of Byrlyng, husbandman 1
3912782 1994606 1994606 defendant Skate Leticia widow 594238 594238 Skate, Leticia, of Byrlyng, widow 2
4010208 2028416 2028416 defendant Ede Richard husbandman 594238 594238 Ede, Richard, of Byrlyng, husbandman 0
5059740 2374476 2374476 defendant Reynold William laborer 594238 594238 Reynold, William, of Byrlyng, laborer 0
5068854 2377183 2377183 defendant Nevill Edward   594238 594238 Nevill, Edward, of Byrlyng, knight 0
5073101 2378440 2378440 defendant Lorkyn Thomas carpenter 594238 594238 Lorkyn, Thomas, of Byrlyng, carpenter 1
5123187 2393218 2393218 defendant Nevyll Edward   594238 594238 Nevyll, Edward, of Byrlyng, knight 0
5217885 2420962 2420962 defendant Danke Simon husbandman 594238 594238 Danke, Simon, of Byrlyng, or of Leybourn, Kent, husbandman 0
5238562 2426869 2426869 defendant Claygate Robert husbandman 594238 594238 Claygate, Robert, of Byrlyng, husbandman 2
5280669 2439420 2439420 defendant Dangke Simon husbandman 594238 594238 Dangke, Simon, of Byrlyng, husbandman 1
5345139 2458643 2458643 defendant Meryman Geoffrey yeoman 594238 594238 Meryman, Geoffrey, of Byrlyng, yeoman 0
5351379 2460530 2460530 defendant Bedyll Henry carpenter 594238 594238 Bedyll, Henry, of Byrlyng, carpenter 0
5351380 2460530 2460530 defendant Bedyll Edward carpenter 594238 594238 Bedyll, Edward, of Byrlyng, carpenter 1
5360554 2463332 2463332 defendant Wodeward John   594238 594238 Wodeward, John, of Byrlyng, administrators of 0
5360557 2463332 2463332 defendant Wodeward John gent 594238 594238 Wodeward, John, of Byrlyng, gent 3
5489555 2501759 2501759 defendant Benette Thomas, senior husbandman 594238 594238 Benette, Thomas, senior, of Byrlyng, husbandman 1
5489556 2501759 2501759 defendant Benette Richard laborer 594238 594238 Benette, Richard, of Byrlyng, laborer 2
5528073 2513344 2513344 defendant Alam Hugh laborer 594238 594238 Alam, Hugh, of Byrlyng, laborer 3
5542059 2517646 2517646 defendant Neweman John husbandman 594238 594238 Neweman, John, of Byrlyng, husbandman 4

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