names

50 rows where place_id = 598301

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631899 1904788 1904788 plaintiff Jnyghtley Thomas   598301 598301 Jnyghtley, Thomas, of Inner Temple 1
3645666 1909046 1909046 plaintiff Knyghtley Thomas   598301 598301 Knyghtley, Thomas, of Inner Temple 1
3977925 2016851 2016851 plaintiff Madryn Thomas gent 598301 598301 Madryn, Thomas, of Inner Temple, gent 0
3978688 2017123 2017123 plaintiff Molyns Michael gent 598301 598301 Molyns, Michael, of Inner Temple, gent 0
3980677 2017852 2017852 plaintiff Plumtre Nicholas gent 598301 598301 Plumtre, Nicholas, of Inner Temple, gent 0
3981074 2017991 2017991 plaintiff Prynce Richard gent 598301 598301 Prynce, Richard, of Inner Temple, gent 0
3981757 2018235 2018235 plaintiff Roberd William gent 598301 598301 Roberd, William, of Inner Temple, gent 0
3981762 2018236 2018236 plaintiff Roberd William gent 598301 598301 Roberd, William, of Inner Temple, gent 0
3988653 2020683 2020683 plaintiff Asheby Francis gent 598301 598301 Asheby, Francis, of Inner Temple, gent 0
3989817 2021109 2021109 plaintiff Bawde Thomas esq 598301 598301 Bawde, Thomas, of Inner Temple, esq 0
3991662 2021775 2021775 plaintiff Broke Roger gent 598301 598301 Broke, Roger, of Inner Temple, gent 0
3991716 2021795 2021795 plaintiff Bromley Thomas gent 598301 598301 Bromley, Thomas, of Inner Temple, gent 0
3992720 2022148 2022148 plaintiff Bydell Robert gent 598301 598301 Bydell, Robert, of Inner Temple, gent 0
3994346 2022730 2022730 plaintiff Cocke William gent 598301 598301 Cocke, William, of Inner Temple, gent 0
3994539 2022794 2022794 plaintiff Colepeper Thomas   598301 598301 Colepeper, Thomas, of Inner Temple gent 0
4000904 2025094 2025094 plaintiff Guybon William gent 598301 598301 Guybon, William, of Inner Temple, gent 0
4004738 2026471 2026471 plaintiff Johnson Richard gent 598301 598301 Johnson, Richard, of Inner Temple, gent 0
4011265 2028804 2028804 plaintiff Phillipps John   598301 598301 Phillipps, John, of Inner Temple, gent, clerk of William Whetley, chief prothonotary of the bench 0
4016893 2030741 2030741 plaintiff Sydnam or Sydenham Walter esq 598301 598301 Sydnam or Sydenham, Walter, of Inner Temple, esq 0
4020510 2032060 2032060 plaintiff Willyams Edward gent 598301 598301 Willyams, Edward, of Inner Temple, gent 0
4020536 2032071 2032071 plaintiff Wilson Simon gent 598301 598301 Wilson, Simon, of Inner Temple, gent 0
4025051 2033620 2033620 defendant Stoughton Francis gent 598301 598301 Stoughton, Francis, of Inner Temple, gent 0
4027656 2034541 2034541 plaintiff Clerke Thomas gent 598301 598301 Clerke, Thomas, of Inner Temple, gent 0
4034647 2037070 2037070 defendant Seth Henry gent 598301 598301 Seth, Henry, of Inner Temple, gent 0
4039033 2038583 2038583 plaintiff Lottisham William esq 598301 598301 Lottisham, William, of Inner Temple, esq 0
4039038 2038585 2038585 plaintiff Lottisham Willim   598301 598301 Lottisham, Willim, of Inner Temple esq 0
4039045 2038588 2038588 plaintiff Love or Lone Richard gent 598301 598301 Love or Lone, Richard, of Inner Temple, gent 0
4053878 2043765 2043765 plaintiff Asshebye Francis gent 598301 598301 Asshebye, Francis, of Inner Temple, gent 0
4070201 2049632 2049632 plaintiff Boyes John   598301 598301 Boyes, John, of Inner Temple 2
4071013 2049933 2049933 plaintiff Modlycott Richard   598301 598301 Modlycott, Richard, of Inner Temple, clerk of Richard Live, Prothonotary of the Court 0
4076589 2051927 2051927 plaintiff Skotte William gent 598301 598301 Skotte, William, of Inner Temple, gent 0
4081299 2053622 2053622 plaintiff Whitfeld Thomas gent 598301 598301 Whitfeld, Thomas, of Inner Temple, gent 0
4084106 2054589 2054589 defendant Smythe Henry   598301 598301 Smythe, Henry, of Inner Temple, clerk of John Forde, Chief Prothonotary of the Court 0
4096630 2059122 2059122 defendant Skipwith William (legal representative) 598301 598301 Skipwith, William, of Inner Temple, gent, executors of 0
4104315 2061823 2061823 plaintiff Modlicott Richard   598301 598301 Modlicott, Richard, of Inner Temple, clerk of Richard Love, esq, Prothonotary of the Court 0
4104317 2061824 2061824 plaintiff Modlicott Richard   598301 598301 Modlicott, Richard, of Inner Temple, clerk of Richard Love, esq, Prothonotary of the Court 0
4130606 2071256 2071256 defendant Risden Giles gent 598301 598301 Risden, Giles, of Inner Temple, gent 3
4167017 2083967 2083967 defendant Russell Richard gent 598301 598301 Russell, Richard, of Inner Temple, gent 0
4178676 2088022 2088022 defendant Lewes John gent 598301 598301 Lewes, John, of Inner Temple, gent 0
4197439 2094661 2094661 defendant Medlicott Richard gent 598301 598301 Medlicott, Richard, of Inner Temple, gent 3
4210747 2099315 2099315 defendant Parker John gent 598301 598301 Parker, John, of Inner Temple, gent 0
4221135 2102889 2102889 defendant Morgan Anthony esq 598301 598301 Morgan, Anthony, of Inner Temple, esq 0
4223291 2103639 2103639 defendant Williams Reginald esq 598301 598301 Williams, Reginald, of Inner Temple, esq 0
4233539 2107248 2107248 defendant Smythe Richard gent 598301 598301 Smythe, Richard, of Inner Temple, gent 1
4246990 2111969 2111969 defendant Morgan Anthony esq 598301 598301 Morgan, Anthony, of Inner Temple, esq 1
4315306 2135465 2135465 defendant Clarke Robert gent 598301 598301 Clarke, Robert, of Inner Temple, gent 1
4325287 2138837 2138837 defendant Riggeley Nicholas esq 598301 598301 Riggeley, Nicholas, of Inner Temple, esq 0
4333125 2141367 2141367 defendant Symes William esq 598301 598301 Symes, William, of Inner Temple, esq 0
4351787 2147867 2147867 defendant Godfrey Arthur gent 598301 598301 Godfrey, Arthur, of Inner Temple, gent 2
4404884 2166203 2166203 defendant Commerford Philip esq 598301 598301 Commerford, Philip, of Inner Temple, esq 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);