names

52 rows where place_id = 596210

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623696 1874943 1874943 defendant Swelwyn Thomas gent 596210 596210 Swelwyn, Thomas, of Selmeston, gent 0
3917690 1996274 1996274 defendant Austen Simon husbandman 596210 596210 Austen, Simon, of Selmeston, husbandman 0
3917691 1996274 1996274 defendant Thaccher Robert husbandman 596210 596210 Thaccher, Robert, of Selmeston, husbandman 1
3917692 1996274 1996274 defendant Blaker John husbandman 596210 596210 Blaker, John, of Selmeston, husbandman 2
3917694 1996274 1996274 defendant Martyn Robert chaplain 596210 596210 Martyn, Robert, of Selmeston, chaplain 4
3917695 1996274 1996274 defendant Rolfe John husbandman 596210 596210 Rolfe, John, of Selmeston, husbandman 5
4013756 2029651 2029651 defendant Parrysshe Peter clerk 596210 596210 Parrysshe, Peter, of Selmeston, clerk 1
4013757 2029651 2029651 defendant Jones John husbandman 596210 596210 Jones, John, of Selmeston, husbandman 2
4066463 2048298 2048298 defendant Russell John yeoman 596210 596210 Russell, John, of Selmeston, yeoman 5
4069722 2049455 2049455 defendant Cooke John   596210 596210 Cooke, John, of Selmeston, or of Lewes, gent, servant of Queen's chamber 0
4069724 2049456 2049456 defendant Cooke John   596210 596210 Cooke, John, of Selmeston, or of Lewes, gent, servant of the Queen's chamber 0
4074311 2051112 2051112 defendant Jones Richard husbandman 596210 596210 Jones, Richard, of Selmeston, husbandman 0
4108654 2063350 2063350 defendant Jones Richard husbandman 596210 596210 Jones, Richard, of Selmeston, husbandman 0
4123937 2068861 2068861 defendant Gratwyke Richard yeoman 596210 596210 Gratwyke, Richard, of Selmeston, yeoman 0
4130908 2071368 2071368 defendant Curle Thomas husbandman 596210 596210 Curle, Thomas, of Selmeston, husbandman 1
4133732 2072396 2072396 defendant Sellen Edward husbandman 596210 596210 Sellen, Edward, of Selmeston, husbandman 2
4166999 2083960 2083960 defendant Abrooke William yeoman 596210 596210 Abrooke, William, of Selmeston, yeoman 0
4173633 2086232 2086232 defendant Gower John husbandman 596210 596210 Gower, John, of Selmeston, husbandman 2
4176954 2087413 2087413 defendant Gratwycke Rochard gent 596210 596210 Gratwycke, Rochard, of Selmeston, or of Blechyngton, gent 0
4186028 2090601 2090601 defendant Gratwicke Richard yeoman 596210 596210 Gratwicke, Richard, of Selmeston, yeoman 0
4186147 2090643 2090643 defendant Gower John husbandman 596210 596210 Gower, John, of Selmeston, husbandman 0
4186149 2090643 2090643 defendant Brooke William husbandman 596210 596210 Brooke, William, of Selmeston, husbandman 2
4202047 2096260 2096260 defendant Gratwyke Richard yeoman 596210 596210 Gratwyke, Richard, of Selmeston, yeoman 0
4202192 2096310 2096310 defendant Courle Thomas yeoman 596210 596210 Courle, Thomas, of Selmeston, yeoman 0
4209825 2098996 2098996 defendant Wenham Thomas gent 596210 596210 Wenham, Thomas, of Selmeston, gent 1
4219234 2102222 2102222 defendant Curle Thomas yeoman 596210 596210 Curle, Thomas, of Selmeston, yeoman 0
4227784 2105199 2105199 defendant Curle Thomas yeoman 596210 596210 Curle, Thomas, of Selmeston, yeoman 1
4313382 2134788 2134788 defendant Leedes Edward gent 596210 596210 Leedes, Edward, of Selmeston, gent 0
4543647 2213909 2213909 plaintiff atte Wode John   596210 596210 atte Wode, John, of Selmeston 0
4559310 2218863 2218863 plaintiff May William   596210 596210 May, William, of Selmeston 0
4574230 2223468 2223468 defendant May William   596210 596210 May, William, of Selmeston 0
4635876 2242058 2242058 defendant Hocchere William carpenter 596210 596210 Hocchere, William, of Selmeston, carpenter 10
4771555 2287081 2287081 plaintiff Selewyne Nicholas (legal representative) 596210 596210 Selewyne, Nicholas, of Selmeston, executors of 0
4777269 2288879 2288879 plaintiff atte Sonde Richard gent 596210 596210 atte Sonde, Richard, of Selmeston, gent 0
4796619 2295093 2295093 plaintiff Selewyne Nicholas (legal representative) 596210 596210 Selewyne, Nicholas, of Selmeston, executors of 0
4843334 2309432 2309432 defendant Smyth Philip husbandman 596210 596210 Smyth, Philip, of Selmeston, husbandman 1
4843335 2309432 2309432 defendant Sleywryte Martin husbandman 596210 596210 Sleywryte, Martin, of Selmeston, husbandman 2
4976986 2350071 2350071 defendant Roper William husbandman 596210 596210 Roper, William, of Selmeston, husbandman 0
4976987 2350071 2350071 defendant Roper Nicholas husbandman 596210 596210 Roper, Nicholas, of Selmeston, husbandman 1
4976988 2350071 2350071 defendant Carpenter John husbandman 596210 596210 Carpenter, John, of Selmeston, husbandman 2
4979987 2350969 2350969 defendant Roper William husbandman 596210 596210 Roper, William, of Selmeston, husbandman 0
4979988 2350969 2350969 defendant Carpenter John husbandman 596210 596210 Carpenter, John, of Selmeston, husbandman 1
4979989 2350969 2350969 defendant Roper Nicholas husbandman 596210 596210 Roper, Nicholas, of Selmeston, husbandman 2
5017269 2361934 2361934 defendant Smyth Philip husbandman 596210 596210 Smyth, Philip, of Selmeston, husbandman 0
5049736 2371546 2371546 defendant Smyth Philip husbandman 596210 596210 Smyth, Philip, of Selmeston, husbandman 0
5071775 2378051 2378051 defendant Smyth Philip husbandman 596210 596210 Smyth, Philip, of Selmeston, husbandman 0
5113202 2390258 2390258 defendant Smyth Philip husbandman 596210 596210 Smyth, Philip, of Selmeston, husbandman 1
5120606 2392453 2392453 defendant Smyth Philip husbandman 596210 596210 Smyth, Philip, of Selmeston, husbandman 0
5140233 2398243 2398243 defendant Smyth Philip laborer 596210 596210 Smyth, Philip, of Selmeston, laborer 0
5161339 2404410 2404410 defendant Smyth Philip laborer 596210 596210 Smyth, Philip, of Selmeston, laborer 0
5175765 2408594 2408594 defendant Smyth Philip laborer 596210 596210 Smyth, Philip, of Selmeston, laborer 0
5248032 2429560 2429560 defendant Smyth Philip husbandman 596210 596210 Smyth, Philip, of Selmeston, 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);