names

37 rows where place_id = 600628

✎ 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
3641840 1907898 1907898 defendant Sharpe alias Mason Robert mercer 600628 600628 Sharpe alias Mason, Robert, of Stannford, mercer 0
3678097 1919198 1919198 defendant Parson Robert butcher 600628 600628 Parson, Robert, of Stannford, butcher 0
3679534 1919669 1919669 plaintiff Philip Thomas (legal representative) 600628 600628 Philip, Thomas, of Stannford, administrator of 0
3679536 1919669 1919669 defendant Whytwell Thomas grocer 600628 600628 Whytwell, Thomas, of Stannford, grocer 0
3697686 1925499 1925499 plaintiff Thomas John   600628 600628 Thomas, John, of Stannford 0
3715928 1931268 1931268 plaintiff Cave Richard gent 600628 600628 Cave, Richard, of Stannford, gent 0
3715943 1931274 1931274 plaintiff Cecill David   600628 600628 Cecill, David, of Stannford 0
3715966 1931281 1931281 defendant Parsons Robert butcher 600628 600628 Parsons, Robert, of Stannford, butcher 0
3759169 1944856 1944856 defendant Cecill David gent 600628 600628 Cecill, David, of Stannford, gent 0
3759173 1944857 1944857 defendant Cecill David gent 600628 600628 Cecill, David, of Stannford, gent 0
3779432 1951291 1951291 defendant Rycheman John   600628 600628 Rycheman, John, of Stannford, wax chandler 0
3782998 1952433 1952433 plaintiff Johnson Maurice   600628 600628 Johnson, Maurice, of Stannford 0
3783001 1952434 1952434 plaintiff Johnson Maurice   600628 600628 Johnson, Maurice, of Stannford 0
3787322 1953826 1953826 defendant Tales Robert barber 600628 600628 Tales, Robert, of Stannford, barber 0
3791602 1955213 1955213 plaintiff Wytton Mathew glover 600628 600628 Wytton, Mathew, of Stannford, glover 0
3811734 1961566 1961566 defendant Hawes Robert tanner 600628 600628 Hawes, Robert, of Stannford, tanner 0
3819569 1963997 1963997 defendant Wytton Mathew glover 600628 600628 Wytton, Mathew, of Stannford, glover 0
3842595 1971211 1971211 defendant Wytton William yeoman 600628 600628 Wytton, William, of Stannford, yeoman 1
3853352 1974672 1974672 defendant Davy John clerk 600628 600628 Davy, John, of Stannford, clerk 0
3855683 1975415 1975415 defendant (not given) Thomas vicar of Webster 600628 600628 Webster, Thomas, of Stannford, vicar of Baston 0
3862413 1977622 1977622 defendant Watson Thomas tanner 600628 600628 Watson, Thomas, of Stannford, tanner 0
3872229 1980939 1980939 defendant Brygge John yeoman 600628 600628 Brygge, John, of Stannford, yeoman 3
3872230 1980939 1980939 defendant Miles William yeoman 600628 600628 Miles, William, of Stannford, yeoman 4
3883434 1984729 1984729 defendant Johnes William sherman 600628 600628 Johnes, William, of Stannford, sherman 0
5129515 2395120 2395120 defendant Knotte Roger yeoman 600628 600628 Knotte, Roger, of Stannford, yeoman 0
5140806 2398426 2398426 defendant Parker John yeoman 600628 600628 Parker, John, of Stannford, yeoman 2
5141993 2398778 2398778 plaintiff Weldon Joan widow 600628 600628 Weldon, Joan, of Stannford, widow 0
5240892 2427541 2427541 defendant Bryan John chaplain 600628 600628 Bryan, John, of Stannford, chaplain 0
5242938 2428136 2428136 plaintiff Mylkton John   600628 600628 Mylkton, John, of Stannford 0
5246999 2429285 2429285 defendant Basse John   600628 600628 Basse, John, of Stannford, parish clerk 2
5250622 2430303 2430303 defendant Sabyne William   600628 600628 Sabyne, William, of Stannford 0
5299385 2444794 2444794 plaintiff Broune William merchant 600628 600628 Broune, William, of Stannford, merchant 0
5368185 2465674 2465674 defendant Bartelot William husbandman 600628 600628 Bartelot, William, of Stannford, husbandman 2
5397420 2474347 2474347 defendant Gaywode William glover 600628 600628 Gaywode, William, of Stannford, glover 1
5397421 2474347 2474347 defendant Folby Robert goldsmith 600628 600628 Folby, Robert, of Stannford, goldsmith 2
5558525 2522445 2522445 plaintiff Philip Thomas   600628 600628 Philip, Thomas, of Stannford 0
5558528 2522446 2522446 plaintiff Philip Thomas draper 600628 600628 Philip, Thomas, of Stannford, draper 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);