names

102 rows where place_id = 595090

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3618861 1873511 1873511 defendant Bromflet Ricdhard clerk 595090 595090 Bromflet, Ricdhard, of St Martin in the Fields,Middx, clerk 2
3626644 1903183 1903183 defendant Turnour Humphrey brewer 595090 595090 Turnour, Humphrey, of St Martin in the Fields, Middx, brewer 0
3631270 1904594 1904594 defendant Crosse Henry clerk 595090 595090 Crosse, Henry, of St Martin in the Fields, Middx, or of Hasseldam, clerk 0
3679903 1919780 1919780 defendant Mannyng Thomas brewer 595090 595090 Mannyng, Thomas, of St Martin in the Fields, Middx, brewer 2
3679907 1919781 1919781 defendant Mannyng Thomas brewer 595090 595090 Mannyng, Thomas, of St Martin in the Fields, Middx, brewer 2
3735623 1937374 1937374 defendant More John gent 595090 595090 More, John, of St Martin in the Fields, Middx, gent 1
3771152 1948666 1948666 defendant Rawlyn John saddler 595090 595090 (Rawlyn, John, of St Martin in the Fields, Middx, saddler 2
3772885 1949216 1949216 defendant Swalowe John brewer 595090 595090 Swalowe, John, of St Martin in the Fields, Middx, brewer 1
3823244 1965185 1965185 defendant Hemmyng Robert butcher 595090 595090 Hemmyng, Robert, of St Martin in the Fields, Middx, butcher 0
3912475 1994502 1994502 defendant Wylson Robert pinner 595090 595090 Wylson, Robert, of St Martin in the Fields, Middx, pinner 0
3920619 1997243 1997243 defendant Smyth Agnes widow 595090 595090 Smyth, Agnes, of St Martin in the Fields, Middx, widow 3
3935863 2002306 2002306 plaintiff Lee Roger baker 595090 595090 Lee, Roger, of St Martin in the Fields, Middx, baker 0
3958123 2009912 2009912 plaintiff Reade Alice keeper of the Kingä wife 595090 595090 Reade, Alice, of St Martin in the Fields, Middx, widow, executrix of Reade, John, of St Martin in the Fields, gent, keeper of the Kingä wife 0
3966517 2012923 2012923 defendant Fowke Adam yeoman 595090 595090 Fowke, Adam, of St Martin in the Fields, Middx, yeoman 2
3988713 2020707 2020707 defendant Weston Andrew joiner 595090 595090 Weston, Andrew, of St Martin in the Fields, Middx, joiner 0
3988791 2020740 2020740 plaintiff Auncell James gent 595090 595090 Auncell, James, of St Martin in the Fields, Middx, gent 0
3990325 2021296 2021296 plaintiff Beste Robert gent 595090 595090 Beste, Robert, of St Martin in the Fields, Middx, gent 0
3991442 2021692 2021692 defendant Batnard John haberdasher 595090 595090 Batnard, John, of St Martin in the Fields, Middx, haberdasher 2
3994709 2022859 2022859 defendant Whitney Henry   595090 595090 Whitney, Henry, of St Martin in the Fields, Middx, gent, servant unto Nicholas, Bacon, knight, Lord Keeper of the Great Seal 0
3996271 2023416 2023416 plaintiff Darlowe or Dorley Richard innholder 595090 595090 Darlowe or Dorley, Richard, of St Martin in the Fields, Middx, innholder 0
3996273 2023417 2023417 plaintiff Darlowe or Dorley Richard innholder 595090 595090 Darlowe or Dorley, Richard, of St Martin in the Fields, Middx, innholder 0
3997998 2024042 2024042 defendant Hyll John ironmonger 595090 595090 Hyll, John, of St Martin in the Fields, Middx, ironmonger 0
4008899 2027947 2027947 defendant Hygham Roger yeoman 595090 595090 Hygham, Roger, of St Martin in the Fields, Middx, yeoman 0
4018296 2031270 2031270 defendant Lewys Joan spinster 595090 595090 Lewys, Joan, of St Martin in the Fields, Middx, spinster 1
4023045 2032961 2032961 defendant Arnold John tailor 595090 595090 Arnold, John, of St Martin in the Fields, Middx, tailor 3
4023050 2032962 2032962 defendant Arnold John tailor 595090 595090 Arnold, John, of St Martin in the Fields, Middx, tailor 3
4030875 2035709 2035709 defendant Jones Robert yeoman 595090 595090 Jones, Robert, of St Martin in the Fields, Middx, yeoman 0
4030893 2035714 2035714 defendant Jones Robert yeoman 595090 595090 Jones, Robert, of St Martin in the Fields, Middx, yeoman 0
4032973 2036441 2036441 plaintiff Godfrey Cornelius tailor 595090 595090 Godfrey, Cornelius, of St Martin in the Fields, Middx, tailor 0
4041840 2039563 2039563 defendant Lizarde William painter 595090 595090 Lizarde, William, of St Martin in the Fields, Middx, gent, painter 1
4069133 2049252 2049252 defendant Weston Andrew joiner 595090 595090 Weston, Andrew, of St Martin in the Fields, Middx, joiner 0
4071381 2050063 2050063 defendant Vandebeck alias Venere Reginald shoemaker 595090 595090 (Vandebeck alias Venere, Reginald, of St Martin in the Fields, Middx, shoemaker 1
4072233 2050369 2050369 defendant Nyghtingale Nicholas gent 595090 595090 Nyghtingale, Nicholas, of St Martin in the Fields, Middx, gent 1
4075753 2051633 2051633 defendant Byngham Harold baker 595090 595090 Byngham, Harold, of St Martin in the Fields, Middx, baker 0
4080525 2053348 2053348 defendant Canke or Cauke Roger tailor 595090 595090 (Canke or Cauke, Roger, of St Martin in the Fields, Middx, tailor 4
4090481 2056878 2056878 defendant Goodlad Henry tailor 595090 595090 Goodlad, Henry, of St Martin in the Fields, Middx, tailor 1
4103110 2061402 2061402 defendant Nightingall Richard gent 595090 595090 Nightingall, Richard, of St Martin in the Fields, Middx, gent 0
4103132 2061408 2061408 defendant Nytingale Richard yeoman 595090 595090 Nytingale, Richard, of St Martin in the Fields, Middx, yeoman 0
4108056 2063156 2063156 defendant Belay David goldsmith 595090 595090 Belay, David, of St Martin in the Fields, Middx, goldsmith 0
4123447 2068689 2068689 defendant Fenner William gent 595090 595090 Fenner, William, of St Martin in the Fields, Middx, gent 0
4125414 2069372 2069372 defendant Fortescue George gent 595090 595090 Fortescue, George, of St Martin in the Fields, Middx, gent 1
4129446 2070834 2070834 defendant Tether Richard tailor 595090 595090 Tether, Richard, of St Martin in the Fields, Middx, tailor 3
4131148 2071458 2071458 plaintiff Kyngston Edward (legal representative) 595090 595090 Kyngston, Edward, of St Martin in the Fields, Middx, brick maker, administratrix of 0
4131232 2071491 2071491 defendant Daprye James tailor 595090 595090 Daprye, James, of St Martin in the Fields, Middx, tailor 3
4132747 2072037 2072037 defendant Price David woodmonger 595090 595090 Price, David, of St Martin in the Fields, Middx, woodmonger 0
4137280 2073681 2073681 defendant Heigham Arthur gent 595090 595090 Heigham, Arthur, of St Martin in the Fields, Middx, gent 0
4140121 2074713 2074713 defendant Pemerton John innholder 595090 595090 Pemerton, John, of St Martin in the Fields, Middx, innholder 0
4140123 2074714 2074714 defendant Pemerton John innholder 595090 595090 Pemerton, John, of St Martin in the Fields, Middx, innholder 0
4141724 2075271 2075271 defendant Conway Philip yeoman 595090 595090 Conway, Philip, of St Martin in the Fields, Middx, yeoman 0
4142452 2075532 2075532 defendant Byngham Harold baker 595090 595090 Byngham, Harold, of St Martin in the Fields, Middx, baker 0
4142932 2075699 2075699 defendant Byngham Harrold baker 595090 595090 Byngham, Harrold, of St Martin in the Fields, Middx, baker 0
4152524 2078995 2078995 defendant Russewell William tailor 595090 595090 Russewell, William, of St Martin in the Fields, Middx, tailor 1
4156457 2080335 2080335 defendant Cowper Margaret widow 595090 595090 Cowper, Margaret, of St Martin in the Fields, Middx, widow 1
4161674 2082151 2082151 defendant Heygham Arthur gent 595090 595090 Heygham, Arthur, of St Martin in the Fields, Middx, gent 2
4169469 2084823 2084823 defendant Lewes Richard yeoman 595090 595090 Lewes, Richard, of St Martin in the Fields, Middx, yeoman 1
4175432 2086878 2086878 defendant Jones Hugh carpenter 595090 595090 Jones, Hugh, of St Martin in the Fields, Middx, carpenter 1
4179160 2088186 2088186 plaintiff Kyngeston Edward (legal representative) 595090 595090 Kyngeston, Edward, of St Martin in the Fields, Middx, brick maker, administrator of 0
4186416 2090735 2090735 defendant Damelstone Alexander tailor 595090 595090 Damelstone, Alexander, of St Martin in the Fields, Middx, tailor 1
4187720 2091207 2091207 defendant Ryce William tailor 595090 595090 Ryce, William, of St Martin in the Fields, Middx, tailor 0
4204147 2097003 2097003 defendant Brigg Andrew yeoman 595090 595090 Brigg, Andrew, of St Martin in the Fields, Middx, yeoman 0
4204986 2097286 2097286 defendant Wilkinson William baker 595090 595090 Wilkinson, William, of St Martin in the Fields, Middx, baker 1
4211289 2099501 2099501 defendant Childe John yeoman 595090 595090 Childe, John, of St Martin in the Fields, Middx, yeoman 0
4215757 2101008 2101008 defendant Oldesworth Arnold gent 595090 595090 Oldesworth, Arnold, of St Martin in the Fields, Middx, gent 1
4219205 2102213 2102213 defendant Rinnegar John yeoman 595090 595090 Rinnegar, John, of St Martin in the Fields, Middx, yeoman 1
4239535 2109453 2109453 defendant Jesper William joiner 595090 595090 Jesper, William, of St Martin in the Fields, Middx, joiner 0
4259016 2115986 2115986 defendant Streyker Philip tailor 595090 595090 Streyker, Philip, of St Martin in the Fields, Middx, tailor 0
4261207 2116716 2116716 defendant Leedes Abraham cutler 595090 595090 Leedes, Abraham, of St Martin in the Fields, Middx, cutler 0
4268791 2119156 2119156 defendant Perry William gent 595090 595090 Perry, William, of St Martin in the Fields, Middx, gent 3
4269570 2119411 2119411 defendant Lever John gent 595090 595090 Lever, John, of St Martin in the Fields, Middx, gent 1
4270805 2119810 2119810 defendant Streyker Philip tailor 595090 595090 Streyker, Philip, of St Martin in the Fields, Middx, tailor 0
4272315 2120315 2120315 defendant Leedes Abraham cutler 595090 595090 Leedes, Abraham, of St Martin in the Fields, Middx, cutler 0
4288484 2125928 2125928 defendant Hellyng Richard baker 595090 595090 Hellyng, Richard, of St Martin in the Fields, Middx, baker 3
4288570 2125964 2125964 defendant Spencer John victualer 595090 595090 Spencer, John, of St Martin in the Fields, Middx, victualer 0
4288572 2125965 2125965 defendant Wilkynson John baker 595090 595090 Wilkynson, John, of St Martin in the Fields, Middx, baker 0
4317950 2136390 2136390 defendant Mychell Francis gent 595090 595090 Mychell, Francis, of St Martin in the Fields, Middx, or of London, gent 0
4324013 2138442 2138442 defendant Occleston Robert innholder 595090 595090 Occleston, Robert, of St Martin in the Fields, Middx, innholder 0
4329941 2140314 2140314 defendant Spencer John victualer 595090 595090 Spencer, John, of St Martin in the Fields, Middx, victualer 0
4329943 2140315 2140315 defendant Wylkynson John baker 595090 595090 Wylkynson, John, of St Martin in the Fields, Middx, baker 0
4330536 2140510 2140510 defendant Baldon Thomas gent 595090 595090 Baldon, Thomas, of St Martin in the Fields, Middx, gent 1
4335951 2142307 2142307 defendant Ocleson Robert innholder 595090 595090 Ocleson, Robert, of St Martin in the Fields, Middx, innholder 0
4336965 2142655 2142655 defendant Mathewe Thomas yeoman 595090 595090 Mathewe, Thomas, of St Martin in the Fields, Middx, yeoman 0
4344607 2145394 2145394 defendant Shepye or Sheppey Richard   595090 595090 Shepye or Sheppey, Richard, of St Martin in the Fields, Middx, gun maker 0
4349884 2147221 2147221 defendant Comport John gent 595090 595090 Comport, John, of St Martin in the Fields, Middx, gent 0
4354267 2148723 2148723 defendant Lever John gent 595090 595090 Lever, John, of St Martin in the Fields, Middx, or of London, gent 1
4357109 2149713 2149713 defendant Mackwillyams Henry esq 595090 595090 Mackwillyams, Henry, of St Martin in the Fields, Middx, esq 3
4378373 2157338 2157338 defendant Lever John gent 595090 595090 Lever, John, of St Martin in the Fields, Middx, or of London, gent 1
4401589 2165128 2165128 defendant Breton or Brittaigne Eleanor spinster 595090 595090 Breton or Brittaigne, Eleanor, of St Martin in the Fields, Middx, spinster 0
4401591 2165129 2165129 defendant Breton or Brittaigne Thomas gent 595090 595090 Breton or Brittaigne, Thomas, of St Martin in the Fields, Middx, gent 0
4925941 2334545 2334545 defendant Crosdale John barber 595090 595090 Crosdale, John, of St Martin in the fields, Middx, barber 0
5335326 2455635 2455635 defendant Nevill Katherine widow 595090 595090 Nevill, Katherine, of St Martin in the Fields, Middx, Duchess of Norfolk, widow 1
5374376 2467588 2467588 defendant Cowele Walter   595090 595090 Cowele, Walter, of St Martin in the Fields, Middx, hat maker 0
5391090 2472524 2472524 defendant Cowele Walter   595090 595090 Cowele, Walter, of St Martin in the Fields, Middx, hat maker 0
5421687 2481424 2481424 defendant Cowelyng Stephen clerk 595090 595090 Cowelyng, Stephen, of St Martin in the Fields, Middx, clerk 1
5422918 2481809 2481809 defendant Russell John laborer 595090 595090 Russell, John, of St Martin in the Fields, Middx, laborer 1
5441553 2487394 2487394 defendant Cowelyng Stephen clerk 595090 595090 Cowelyng, Stephen, of St Martin in the Fields, Middx, clerk 1
5454324 2491202 2491202 defendant Cowelyng Stephen clerk 595090 595090 Cowelyng, Stephen, of St Martin in the fields, Middx, clerk 1
5514722 2509446 2509446 defendant Bromfeld Richard clerk 595090 595090 Bromfeld, Richard, of St Martin in the Fields, Middx, clerk 3
5514728 2509447 2509447 defendant Bromfeld Richard clerk 595090 595090 Bromfeld, Richard, of St Martin in the Fields, Middx, clerk 3
5540422 2517136 2517136 defendant Breneflet Richard clerk 595090 595090 Breneflet, Richard, of St Martin in the Fields, Middx, clerk 0
5580363 2528940 2528940 defendant Turnour Humphrey yeoman 595090 595090 Turnour, Humphrey, of St Martin in the Fields, Middx, yeoman 0

Next page

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);