names

92 rows where place_id = 652704

✎ 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
3925147 1998721 1998721 defendant Gay Osmund gent 652704 652704 Gay, Osmund, of Greys Inn, Middx, gent 1
3926192 1999083 1999083 plaintiff Clyfford George gent 652704 652704 Clyfford, George, of Greys Inn, Middx, gent 0
3945132 2005392 2005392 plaintiff Blakwell Thomas gent 652704 652704 Blakwell, Thomas, of Greys Inn, Middx, gent 0
3946696 2005910 2005910 defendant Rugge William esq 652704 652704 Rugge, William, of Greys Inn, Middx, esq 0
3978940 2017220 2017220 defendant Radcliff Owen gent 652704 652704 Radcliff, Owen, of Greys Inn, Middx, gent 0
3983933 2019022 2019022 defendant Baker Thomas gent 652704 652704 Baker, Thomas, of Greys Inn, Middx, gent 0
3987326 2020216 2020216 defendant Smarte Ralph gent 652704 652704 Smarte, Ralph, of Greys Inn, Middx, gent 0
3994544 2022796 2022796 plaintiff Colepepyr Richard gent 652704 652704 Colepepyr, Richard, of Greys Inn, Middx, gent 0
3995839 2023260 2023260 plaintiff Culpeper Richard gent 652704 652704 Culpeper, Richard, of Greys Inn, Middx, gent 0
3997450 2023835 2023835 defendant Ratckyffe Owen gent 652704 652704 Ratckyffe, Owen, of Greys Inn, Middx, gent 0
3999087 2024433 2024433 defendant Radclyff Owen gent 652704 652704 Radclyff, Owen, of Greys Inn, Middx, gent 0
4000432 2024923 2024923 defendant Patrickson Henry gent 652704 652704 Patrickson, Henry, of Greys Inn, Middx, or of Enerdall, Cumber, gent 1
4003833 2026137 2026137 defendant Twyne Alexander gent 652704 652704 Twyne, Alexander, of Greys Inn, Middx, gent 0
4008871 2027937 2027937 defendant Radclyff Owen gent 652704 652704 Radclyff, Owen, of Greys Inn, Middx, gent 0
4012973 2029372 2029372 defendant Stanhawe Edward gent 652704 652704 Stanhawe, Edward, of Greys Inn, Middx, gent 0
4013285 2029484 2029484 defendant Andrewes Edward gent 652704 652704 Andrewes, Edward, of Greys Inn, Middx, gent 0
4017162 2030842 2030842 defendant Heusey John gent 652704 652704 Heusey, John, of Greys Inn, Middx, gent 1
4017174 2030846 2030846 defendant Husey John gent 652704 652704 Husey, John, of Greys Inn, Middx, gent 1
4033080 2036480 2036480 defendant Leigh William gent 652704 652704 Leigh, William, of Greys Inn, Middx, gent 0
4035737 2037456 2037456 defendant Murton George esq 652704 652704 Murton, George, of Greys Inn, Middx, esq 0
4040247 2039016 2039016 plaintiff Megges Henry gent 652704 652704 Megges, Henry, of Greys Inn, Middx, gent 0
4048694 2041978 2041978 plaintiff Thorpe William gent 652704 652704 Thorpe, William, of Greys Inn, Middx, gent 0
4049929 2042406 2042406 plaintiff Walker John gent 652704 652704 Walker, John, of Greys Inn, Middx, gent 0
4049931 2042407 2042407 plaintiff Walker John gent 652704 652704 Walker, John, of Greys Inn, Middx, gent 0
4052181 2043200 2043200 plaintiff Wyllard John gent 652704 652704 Wyllard, John, of Greys Inn, Middx, gent 0
4052183 2043201 2043201 plaintiff Wyllard John gent 652704 652704 Wyllard, John, of Greys Inn, Middx, gent 0
4054035 2043825 2043825 defendant Wynckfeld Thomas gent 652704 652704 Wynckfeld, Thomas, of Greys Inn, Middx, gent 0
4055893 2044489 2044489 plaintiff Bolton William gent 652704 652704 Bolton, William, of Greys Inn, Middx, gent 0
4058160 2045301 2045301 plaintiff Carye Thomas gent 652704 652704 Carye, Thomas, of Greys Inn, Middx, gent 0
4059633 2045839 2045839 plaintiff Coppynger Ambrose gent 652704 652704 Coppynger, Ambrose, of Greys Inn, Middx, gent 0
4059637 2045841 2045841 plaintiff Copynger Ambrose gent 652704 652704 Copynger, Ambrose, of Greys Inn, Middx, gent 0
4071794 2050209 2050209 defendant Hill John gent 652704 652704 Hill, John, of Greys Inn, Middx, gent 0
4071796 2050210 2050210 defendant Hyll John gent 652704 652704 Hyll, John, of Greys Inn, Middx, gent 0
4072765 2050560 2050560 defendant Botyll William gent 652704 652704 Botyll, William, of Greys Inn, Middx, gent 0
4073980 2050981 2050981 plaintiff Prowde Serlisius gent 652704 652704 Prowde, Serlisius, of Greys Inn, Middx, gent 0
4078493 2052605 2052605 defendant Forsset William gent 652704 652704 Forsset, William, of Greys Inn, Middx, gent 3
4078723 2052686 2052686 plaintiff Thomas David gent 652704 652704 Thomas, David, of Greys Inn, Middx, gent 0
4082171 2053933 2053933 defendant Barrell Henry gent 652704 652704 Barrell, Henry, of Greys Inn, Middx, or of Stotney, Sussex, gent 0
4083451 2054358 2054358 defendant Alcock Robert gent 652704 652704 Alcock, Robert, of Greys Inn, Middx, gent 2
4084067 2054577 2054577 defendant Bacon Edward gent 652704 652704 Bacon, Edward, of Greys Inn, Middx, gent 1
4084605 2054770 2054770 defendant Bowthe George gent 652704 652704 Bowthe, George, of Greys Inn, Middx, gent 0
4100532 2060515 2060515 plaintiff Jones Thomas esq 652704 652704 Jones, Thomas, of Greys Inn, Middx, esq 0
4106434 2062595 2062595 defendant Wyngfeld John gent 652704 652704 Wyngfeld, John, of Greys Inn, Middx, gent 0
4108667 2063355 2063355 defendant Wyngfelde John gent 652704 652704 Wyngfelde, John, of Greys Inn, Middx, gent 0
4114248 2065380 2065380 defendant Ashton Richard gent 652704 652704 Ashton, Richard, of Greys Inn, Middx, gent 0
4123019 2068530 2068530 defendant Salisburie Edward gent 652704 652704 Salisburie, Edward, of Greys Inn, Middx, gent 2
4126582 2069791 2069791 defendant Davyle Thomas gent 652704 652704 Davyle, Thomas, of Greys Inn, Middx, gent 1
4126646 2069815 2069815 defendant Twyne John gent 652704 652704 Twyne, John, of Greys Inn, Middx, gent 0
4127994 2070301 2070301 defendant Forsett William, junior gent 652704 652704 Forsett, William, junior, of Greys Inn, Middx, gent 3
4128775 2070587 2070587 defendant Salusbury Edward, junior gent 652704 652704 Salusbury, Edward, junior, of Greys Inn, Middx, gent 0
4128779 2070588 2070588 defendant Salusbury Edward gent 652704 652704 Salusbury, Edward, of Greys Inn, Middx, gent 1
4128783 2070589 2070589 defendant Salusbury Edward, junior gent 652704 652704 Salusbury, Edward, junior, of Greys Inn, Middx, gent 1
4129578 2070882 2070882 defendant Salusbury Thomas gent 652704 652704 Salusbury, Thomas, of Greys Inn, Middx, gent 1
4130506 2071222 2071222 defendant Whetstones Francis gent 652704 652704 Whetstones, Francis, of Greys Inn, Middx, gent 0
4138026 2073963 2073963 defendant Carterett Hugh gent 652704 652704 Carterett, Hugh, of Greys Inn, Middx, gent 0
4142645 2075595 2075595 defendant Alocke William gent 652704 652704 Alocke, William, of Greys Inn, Middx, gent 0
4143974 2076055 2076055 defendant Burd William gent 652704 652704 Burd, William, of Greys Inn, Middx, or of London, gent 0
4144668 2076294 2076294 defendant Ashton Richard gent 652704 652704 Ashton, Richard, of Greys Inn, Middx, gent 0
4147331 2077205 2077205 plaintiff Cotton Giles gent 652704 652704 Cotton, Giles, of Greys Inn, Middx, gent 0
4151501 2078647 2078647 defendant Dale Robert gent 652704 652704 Dale, Robert, of Greys Inn, Middx, gent 1
4157377 2080649 2080649 defendant Salisbury Edward gent 652704 652704 Salisbury, Edward, of Greys Inn, Middx, gent 0
4158406 2081011 2081011 defendant Younge Edward gent 652704 652704 Younge, Edward, of Greys Inn, Middx, gent 0
4165764 2083525 2083525 defendant Playsted Thomas, junior gent 652704 652704 Playsted, Thomas, junior, of Greys Inn, Middx, gent 0
4177297 2087531 2087531 defendant Barton Thomas gent 652704 652704 Barton, Thomas, of Greys Inn, Middx, gent 0
4190653 2092294 2092294 defendant Prowse Conant gent 652704 652704 Prowse, Conant, of Greys Inn, Middx, gent 1
4192354 2092883 2092883 defendant Burde William gent 652704 652704 Burde, William, of Greys Inn, Middx, gent 0
4192564 2092961 2092961 defendant Boothe George esq 652704 652704 Boothe, George, of Greys Inn, Middx, esq 0
4192922 2093089 2093089 defendant Catalyn Robert gent 652704 652704 Catalyn, Robert, of Greys Inn, Middx, gent 1
4195515 2093975 2093975 defendant Weekes alias Mason Anthony esq 652704 652704 Weekes alias Mason, Anthony, of Greys Inn, Middx, esq 0
4197747 2094768 2094768 defendant Hennage Thomas gent 652704 652704 Hennage, Thomas, of Greys Inn, Middx, gent 3
4197777 2094778 2094778 defendant Birkbacke Thomas gent 652704 652704 Birkbacke, Thomas, of Greys Inn, Middx, gent 0
4198307 2094956 2094956 defendant Buck Nicholas gent 652704 652704 Buck, Nicholas, of Greys Inn, Middx, gent 1
4206302 2097752 2097752 defendant Mychelborne Thomas (legal representative) 652704 652704 Mychelborne, Thomas, of Greys Inn, Middx, esq, executor of 0
4206305 2097753 2097753 defendant Mychelborne Thomas (legal representative) 652704 652704 Mychelborne, Thomas, of Greys Inn, Middx, esq, executor of 0
4208556 2098544 2098544 defendant Pecke Dameon gent 652704 652704 Pecke, Dameon, of Greys Inn, Middx, gent 0
4210114 2099097 2099097 defendant Hagger John gent 652704 652704 Hagger, John, of Greys Inn, Middx, gent 0
4210482 2099222 2099222 defendant Bereford John gent 652704 652704 Bereford, John, of Greys Inn, Middx, gent 0
4222165 2103243 2103243 defendant Brantingham Elias gent 652704 652704 Brantingham, Elias, of Greys Inn, Middx, gent 0
4236693 2108408 2108408 defendant Carewe William, junior gent 652704 652704 Carewe, William, junior, of Greys Inn, Middx, gent 0
4240842 2109921 2109921 defendant Bolton William esq 652704 652704 Bolton, William, of Greys inn, Middx, esq 0
4246316 2111745 2111745 defendant Pynchbacke John gent 652704 652704 Pynchbacke, John, of Greys Inn, Middx, gent 1
4263901 2117585 2117585 defendant Bolton William esq 652704 652704 Bolton, William, of Greys Inn, Middx, esq 0
4269437 2119369 2119369 defendant Carewe William, junior gent 652704 652704 Carewe, William, junior, of Greys Inn, Middx, gent 0
4271450 2120029 2120029 defendant Rowlesley Humphrey gent 652704 652704 Rowlesley, Humphrey, of Greys Inn, Middx, gent 0
4308495 2133126 2133126 plaintiff Vaughan Richard gent 652704 652704 Vaughan, Richard, of Greys Inn, Middx, gent 0
4313292 2134756 2134756 defendant Astell John gent 652704 652704 Astell, John, of Greys Inn, Middx, gent 3
4321720 2137685 2137685 defendant Boulton William esq 652704 652704 Boulton, William, of Greys Inn, Middx, esq 0
4355255 2149059 2149059 defendant Clerke Francis gent 652704 652704 Clerke, Francis, of Greys Inn, Middx, gent 0
4360850 2151047 2151047 defendant Staverton Parr esq 652704 652704 Staverton, Parr, of Greys Inn, Middx, or of London, esq 2
4379302 2157677 2157677 defendant Clerke Francis gent 652704 652704 Clerke, Francis, of Greys Inn, Middx, gent 0
4393382 2162388 2162388 defendant Mountgomery Theophilus gent 652704 652704 Mountgomery, Theophilus, of Greys Inn, Middx, gent 1
4407707 2167144 2167144 defendant Pilkington Robert gent 652704 652704 Pilkington, Robert, of Greys Inn, Middx, 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);