names

35 rows where place_id = 593393

✎ 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
3600033 1867664 1867664 defendant Hardy John   593393 593393 Hardy, John, of Holborne St Andrew, tallow chandler 3
3611629 1871307 1871307 defendant Trentham John laborer 593393 593393 Trentham, John, of Holborne St Andrew, laborer 0
3611630 1871307 1871307 defendant Whyte Philip costermonger 593393 593393 Whyte, Philip, of Holborne St Andrew, costermonger 1
3611631 1871307 1871307 defendant Lewes Thomas baker 593393 593393 Lewes, Thomas, of Holborne St Andrew, baker 2
3611632 1871307 1871307 defendant Aylmer John sherman 593393 593393 Aylmer, John, of Holborne St Andrew, sherman 3
3611633 1871307 1871307 defendant Bykerton Henry brewer 593393 593393 Bykerton, Henry, of Holborne St Andrew, brewer 4
3679224 1919570 1919570 defendant A More Robert tailor 593393 593393 A More, Robert, of Holborne St Andrew, tailor 0
3721861 1933107 1933107 defendant Nicolson Robert   593393 593393 Nicolson, Robert, of Holborne St Andrew 1
3794760 1956239 1956239 defendant De Arnold baker 593393 593393 De, Arnold, of Holborne St Andrew, baker 3
3892036 1987587 1987587 defendant Moreton Robert, senior esq 593393 593393 Moreton, Robert, senior, of Holborne St Andrew, esq 0
4007837 2027584 2027584 plaintiff Mathyson John   593393 593393 Mathyson, John, of Holborne St Andrew, administrators of 0
4007841 2027585 2027585 plaintiff Mathyson John   593393 593393 Mathyson, John, of Holborne St Andrew, administrators of 0
4127883 2070261 2070261 defendant Harte Stephen gardener 593393 593393 Harte, Stephen, of Holborne St Andrew, gardener 2
4228637 2105499 2105499 defendant Forest John gent 593393 593393 Forest, John, of Holborne St Andrew, gent 1
4245755 2111557 2111557 defendant Forest John gent 593393 593393 Forest, John, of Holborne St Andrew, gent 2
4273834 2120794 2120794 defendant Wolfierston Robert gent 593393 593393 Wolfierston, Robert, of Holborne St Andrew, or of Grays inn, gent 1
4295081 2128323 2128323 defendant Tinsen Samuel cordwainer 593393 593393 Tinsen, Samuel, of Holborne St Andrew, cordwainer 0
4303518 2131358 2131358 defendant Gathelde alias Garfeylde Thomas tailor 593393 593393 Gathelde alias Garfeylde, Thomas, of Holborne St Andrew, tailor 1
4337931 2143012 2143012 plaintiff Browne Anne widow 593393 593393 Anne his wife, formerly Anne Hardinge, of Holborne St Andrew, widow 1
4340376 2143897 2143897 defendant Taylor Faith fletcher 593393 593393 Taylor, Faith, of Holborne St Andrew, fletcher 0
4340863 2144077 2144077 defendant Symond Robert (legal representative) 593393 593393 Symond, Robert, of Holborne St Andrew, or of London, haberdasher, executrix of 0
4348057 2146567 2146567 defendant Wyndome   widow 593393 593393 Wyndome, , of Holborne St Andrew, widow 1
4348092 2146580 2146580 defendant Lydcott John esq 593393 593393 Lydcott, John, of Holborne St Andrew, esq 0
4348093 2146580 2146580 defendant Lydcott Christopher gent 593393 593393 Lydcott, Christopher, of Holborne St Andrew, gent 1
4348094 2146580 2146580 defendant Robynson Leonard yeoman 593393 593393 Robynson, Leonard, of Holborne St Andrew, yeoman 2
4354000 2148625 2148625 defendant Snowden Roger fletcher 593393 593393 Snowden, Roger, of Holborne St Andrew, fletcher 3
4373452 2155574 2155574 defendant Streete Peter tailor 593393 593393 Streete, Peter, of Holborne St Andrew, tailor 0
4402581 2165449 2165449 defendant Grymshawe Richard tailor 593393 593393 Grymshawe, Richard, of Holborne St Andrew, tailor 3
5108572 2388947 2388947 defendant Darre John baker 593393 593393 Darre, John, of Holborne St Andrew, baker 0
5108573 2388947 2388947 defendant Lyndley John brewer 593393 593393 Lyndley, John, of Holborne St Andrew, brewer 1
5108575 2388948 2388948 defendant Darre John baker 593393 593393 Darre, John, of Holborne St Andrew, baker 0
5108576 2388948 2388948 defendant Lyndley John brewer 593393 593393 Lyndley, John, of Holborne St Andrew, brewer 1
5334796 2455475 2455475 defendant Glyn John gent 593393 593393 Glyn, John, of Holborne St Andrew, gent 0
5518325 2510558 2510558 defendant Rewe John gardener 593393 593393 Rewe, John, of Holborne St Andrew, gardener 2
5531577 2514407 2514407 defendant Smale John brewer 593393 593393 Smale, John, of Holborne St Andrew, brewer 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);