names

36 rows where place_id = 592317

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607317 1869950 1869950 defendant Bettys Thomas gent 592317 592317 Bettys, Thomas, of Irmynglond, gent 0
3607320 1869951 1869951 defendant Bettys Thomas gent 592317 592317 Bettys, Thomas, of Irmynglond, gent 0
3623475 1874875 1874875 defendant Bettys Thomas gent 592317 592317 Bettys, Thomas, of Irmynglond, gent 0
3700967 1926552 1926552 plaintiff Bett John gent 592317 592317 Bett, John, of Irmynglond, gent 0
3753158 1942927 1942927 defendant Bette John gent 592317 592317 Bette, John, of Irmynglond, gent 0
3753159 1942927 1942927 defendant Bette Robert gent 592317 592317 Bette, Robert, of Irmynglond, gent 1
3760368 1945247 1945247 defendant Bett Robert gent 592317 592317 Bett, Robert, of Irmynglond, gent 1
3991471 2021702 2021702 defendant Parker Richard yeoman 592317 592317 Parker, Richard, of Irmynglond, yeoman 0
3992189 2021971 2021971 defendant Parker Richard yeoman 592317 592317 Parker, Richard, of Irmynglond, yeoman 0
4024206 2033360 2033360 defendant Parker Richard yeoman 592317 592317 Parker, Richard, of Irmynglond, yeoman 0
4076036 2051724 2051724 defendant Bett John gent 592317 592317 Bett, John, of Irmynglond, gent 7
4452522 2185788 2185788 plaintiff Kempston Richard de   592317 592317 Kempston, Richard de, of Irmynglond 0
4647647 2245365 2245365 defendant Mome Edmund clerk 592317 592317 Mome, Edmund, of Irmynglond, son of William, clerk 4
4760963 2283772 2283772 plaintiff Dennys John smith 592317 592317 Dennys, John, of Irmynglond, smith 0
4856016 2313254 2313254 defendant Bennes John, senior yeoman 592317 592317 Bennes, John, senior, of Irmynglond, yeoman 0
4856017 2313254 2313254 defendant Flaxman William yeoman 592317 592317 Flaxman, William, of Irmynglond, yeoman 1
4876399 2319578 2319578 defendant Bennes John smith 592317 592317 Bennes, John, of Irmynglond, smith 0
4973688 2349083 2349083 defendant Bennys John smith 592317 592317 Bennys, John, of Irmynglond, smith 0
4987629 2353262 2353262 plaintiff Bettys John   592317 592317 Bettys, John, of Irmynglond 0
5091826 2383992 2383992 defendant Bennys John yeoman 592317 592317 Bennys, John, of Irmynglond, yeoman 0
5118580 2391864 2391864 defendant Banys John smith 592317 592317 Banys, John, of Irmynglond, smith 2
5120913 2392546 2392546 defendant Bennes John, senior (legal representative) 592317 592317 Bennes, John, senior, of Irmynglond, yeoman, executor of 4
5120914 2392546 2392546 defendant Bennys John yeoman 592317 592317 Bennys, John, of Irmynglond, yeoman 5
5126087 2394112 2394112 defendant Bon-- John (legal representative) 592317 592317 Bon--, John, of Irmynglond, yeoman, executor of 4
5158535 2403616 2403616 defendant Mayn John laborer 592317 592317 Mayn, John, of Irmynglond, laborer 1
5208753 2418282 2418282 defendant Mayn John laborer 592317 592317 Mayn, John, of irmynglond, laborer 1
5231190 2424721 2424721 plaintiff Bettys Thomas   592317 592317 Bettys, Thomas, of Irmynglond 0
5330481 2454198 2454198 plaintiff Bettys Thomas   592317 592317 Bettys, Thomas, of Irmynglond 0
5347606 2459407 2459407 plaintiff Bettes Thomas gent 592317 592317 Bettes, Thomas, of Irmynglond, gent 0
5544041 2518244 2518244 defendant Bettys John gent 592317 592317 Bettys, John, of Irmynglond, gent 4
5549203 2519814 2519814 plaintiff Bettys Thomas (legal representative) 592317 592317 Bettys, Thomas, of Irmynglond, executor of 0
5554431 2521331 2521331 defendant Bettys John gent 592317 592317 Bettys, John, of Irmynglond, gent 2
5579742 2528743 2528743 defendant Bettys John gent 592317 592317 Bettys, John, of Irmynglond, gent 0
5579746 2528744 2528744 defendant Bettys John gent 592317 592317 Bettys, John, of Irmynglond, gent 0
5585603 2530567 2530567 defendant Bettys John gent 592317 592317 Bettys, John, of Irmynglond, gent 1
5595327 2533486 2533486 defendant Bettys John gent 592317 592317 Bettys, John, of Irmynglond, gent 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);