names

89 rows where place_id = 589742

✎ 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
3598593 1867185 1867185 defendant Yon John yeoman 589742 589742 Yon, John, of Rampton, yeoman 0
3600075 1867672 1867672 defendant Yon John yeoman 589742 589742 Yon, John, of Rampton, yeoman 0
3612258 1871469 1871469 defendant Jun John, junior yeoman 589742 589742 Jun, John, junior, of Rampton, yeoman 0
3612259 1871469 1871469 defendant Pudsey Richard yeoman 589742 589742 Pudsey, Richard, of Rampton, yeoman 1
3612516 1871546 1871546 defendant Jon John junior yeoman 589742 589742 Jon John, junior, of Rampton, yeoman 0
3612517 1871546 1871546 defendant Broun John husbandman 589742 589742 Broun, John, of Rampton, husbandman 1
3612518 1871546 1871546 defendant Porter William laborer 589742 589742 Porter, William, of Rampton, laborer 2
3685415 1921591 1921591 defendant Ludlam John chaplain 589742 589742 Ludlam, John, of Rampton, chaplain 0
3697372 1925397 1925397 defendant Both Robert   589742 589742 Both, Robert, of Rampton, cartwright 1
3703812 1927471 1927471 defendant Mate William yeoman 589742 589742 Mate, William, of Rampton, yeoman 1
3730749 1935843 1935843 defendant Brown John yeoman 589742 589742 Brown, John, of Rampton, yeoman 0
3731327 1936020 1936020 defendant Aedinstewe or Areydinstewe John yeoman 589742 589742 Aedinstewe or Areydinstewe, John, of Rampton, yeoman 0
3755865 1943786 1943786 defendant Ludlam John clerk 589742 589742 Ludlam, John, of Rampton, clerk 1
3776340 1950348 1950348 defendant Cowper John husbandman 589742 589742 Cowper, John, of Rampton, husbandman 0
3807210 1960151 1960151 defendant Cowode Thomas husbandman 589742 589742 Cowode, Thomas, of Rampton, husbandman 1
3807211 1960151 1960151 defendant Suttell Alexander laborer 589742 589742 Suttell, Alexander, of Rampton, laborer 2
3817890 1963512 1963512 defendant Foster William husbandman 589742 589742 Foster, William, of Rampton, husbandman 0
3820209 1964202 1964202 defendant Cowper John husbandman 589742 589742 Cowper, John, of Rampton, husbandman 0
3820210 1964202 1964202 defendant Cuttell John husbandman 589742 589742 Cuttell, John, of Rampton, husbandman 1
3834565 1968744 1968744 defendant Hogeson Richard husbandman 589742 589742 Hogeson, Richard, of Rampton, husbandman 0
3834566 1968744 1968744 defendant Broune Christopher husbandman 589742 589742 Broune, Christopher, of Rampton, husbandman 1
3834567 1968744 1968744 defendant Jakson Richard husbandman 589742 589742 Jakson, Richard, of Rampton, husbandman 2
3834568 1968744 1968744 defendant Cottun Richard husbandman 589742 589742 Cottun, Richard, of Rampton, husbandman 3
3834569 1968744 1968744 defendant Browne William laborer 589742 589742 Browne, William, of Rampton, laborer 4
3834570 1968744 1968744 defendant Benson William laborer 589742 589742 Benson, William, of Rampton, laborer 5
3849028 1973291 1973291 defendant Legatt William husbandman 589742 589742 Legatt, William, of Rampton, husbandman 0
3855512 1975367 1975367 defendant Babyngton John esq 589742 589742 Babyngton, John, of Rampton, esq 0
3855513 1975367 1975367 defendant Belyoll or Bebyoll Thomas yeoman 589742 589742 Belyoll or Bebyoll, Thomas, of Rampton, yeoman 1
3888504 1986414 1986414 defendant Eton George gent 589742 589742 Eton, George, of Rampton, gent 2
3888512 1986415 1986415 defendant Eton George gent 589742 589742 Eton, George, of Rampton, gent 2
3894585 1988398 1988398 defendant Thekker Thomas husbandman 589742 589742 Thekker, Thomas, of Rampton, husbandman 2
3902579 1991095 1991095 defendant Babyngton John esq 589742 589742 Babyngton, John, of Rampton, esq 1
3914003 1995027 1995027 defendant Hawson William butcher 589742 589742 Hawson, William, of Rampton, butcher 0
3965377 2012506 2012506 defendant Jackson George gent 589742 589742 Jackson, George, of Rampton, gent 0
3965378 2012506 2012506 defendant Beckett Alexander yeoman 589742 589742 Beckett, Alexander, of Rampton, yeoman 1
4085205 2054993 2054993 defendant Jackson George gent 589742 589742 Jackson, George, of Rampton, gent 0
4085206 2054993 2054993 defendant Cowper Lawrence husbandman 589742 589742 Cowper, Lawrence, of Rampton, husbandman 1
4111692 2064430 2064430 defendant Isaake John husbandman 589742 589742 Isaake, John, of Rampton, yeoman, or of Henlowe, Beds, husbandman 0
4216512 2101267 2101267 defendant Barmbie William yeoman 589742 589742 Barmbie, William, of Rampton, yeoman 1
4225649 2104436 2104436 defendant Barmbie William yeoman 589742 589742 Barmbie, William, of Rampton, yeoman 1
4306986 2132585 2132585 defendant Whyteside William yeoman 589742 589742 Whyteside, William, of Rampton, yeoman 0
4306987 2132585 2132585 defendant Browne John yeoman 589742 589742 Browne, John, of Rampton, yeoman 1
4338774 2143314 2143314 defendant Twyser Robert yeoman 589742 589742 Twyser, Robert, of Rampton, yeoman 0
4380498 2158138 2158138 defendant Twyford Robert yeoman 589742 589742 Twyford, Robert, of Rampton, yeoman 0
4404500 2166073 2166073 defendant Bingley Thomas laborer 589742 589742 Bingley, Thomas, of Rampton, laborer 0
4475063 2192871 2192871 plaintiff Ely John   589742 589742 Ely,. John, of Rampton, parson, on his own account 0
4528458 2209179 2209179 defendant Maunsyll Thomas   589742 589742 Maunsyll, Thomas, of Rampton 2
4609252 2233997 2233997 defendant Page Henry   589742 589742 Page, Henry, of Rampton 0
4619055 2236952 2236952 defendant Sodlomb James   589742 589742 Sodlomb, James, of Rampton 1
4640286 2243275 2243275 defendant Bocher Robert   589742 589742 Bocher, Robert, of Rampton 1
4645476 2244745 2244745 defendant Bocher Robert   589742 589742 Bocher, Robert, of Rampton 4
4645478 2244745 2244745 defendant More William   589742 589742 More, William, of Rampton 6
4690048 2262440 2262440 defendant Sodelomb James husbandman 589742 589742 Sodelomb, James, of Rampton, husbandman 0
4723920 2272779 2272779 defendant Stanhop Richard   589742 589742 Stanhop, Richard, of Rampton, knight 0
4724958 2273100 2273100 plaintiff Flete John (legal representative) 589742 589742 Flete, John, of Rampton, executors of 0
4741940 2278139 2278139 defendant Baxstere John   589742 589742 Baxstere, John, of Rampton, parson & clerk 0
4791136 2293326 2293326 defendant de Calverley Christopher husbandman 589742 589742 de Calverley, Christopher, of Rampton, husbandman 2
4821736 2302874 2302874 plaintiff Salman Thomas   589742 589742 Salman, Thomas, of Rampton, on his own account 0
4902660 2327452 2327452 defendant Wryght John   589742 589742 Wryght, John, of Rampton, wright 0
4902661 2327452 2327452 defendant Coton William husbandman 589742 589742 Coton, William, of Rampton, husbandman 1
4911780 2330186 2330186 defendant Hagworth William   589742 589742 Hagworth, William, of Rampton, servant 0
4918202 2332213 2332213 plaintiff Grey William Master & clerk 589742 589742 Grey, William, of Rampton, Master & clerk 0
4918204 2332213 2332213 defendant Stannop Richard (legal representative) 589742 589742 Stannop, Richard, of Rampton, knight, executors of 0
4918207 2332213 2332213 defendant Stanhope James esq 589742 589742 Stanhope, James, of Rampton, esq 3
4943877 2340047 2340047 defendant Stanhope Richard (legal representative) 589742 589742 Stanhope, Richard, of Rampton, knight, executors of 0
4943879 2340047 2340047 defendant Stanhope Thomas   589742 589742 Stanhope, Thomas, of Rampton, knight 2
4944812 2340366 2340366 defendant Wryght John   589742 589742 Wryght, John, of Rampton, wright 0
4944813 2340366 2340366 defendant de Cotom William husbandman 589742 589742 de Cotom, William, of Rampton, husbandman 1
4954486 2343308 2343308 defendant Rasyn John husbandman 589742 589742 Rasyn, John, of Rampton, husbandman 0
4961063 2345272 2345272 defendant Carter John clerk 589742 589742 Carter, John, of Rampton, clerk 0
5002205 2357550 2357550 defendant Aylmer William husbandman 589742 589742 Aylmer, William, of Rampton, husbandman 4
5066827 2376607 2376607 defendant More William husbandman 589742 589742 More, William, of Rampton, husbandman 2
5115821 2391052 2391052 defendant Cotun William husbandman 589742 589742 Cotun, William, of Rampton, husbandman 2
5243180 2428206 2428206 defendant Saunderson Richard diker 589742 589742 Saunderson, Richard, of Rampton, diker 0
5343474 2458148 2458148 plaintiff Stanhop John esq 589742 589742 Stanhop, John, of Rampton, esq 0
5504603 2506360 2506360 defendant Weldys John yeoman 589742 589742 Weldys, John, of Rampton, yeoman 0
5542883 2517890 2517890 defendant Coton Ralph husbandman 589742 589742 Coton, Ralph, of Rampton, husbandman 3
5547814 2519378 2519378 defendant Yon Thomas yeoman 589742 589742 Yon, Thomas, of Rampton, yeoman 0
5553060 2520933 2520933 defendant Yon Thomas yeoman 589742 589742 Yon, Thomas, of Rampton, yeoman 0
5585509 2530534 2530534 defendant Bothe Humphrey gent 589742 589742 Bothe, Humphrey, of Rampton, gent 1
5594434 2533238 2533238 defendant Godley Richard husbandman 589742 589742 Godley, Richard, of Rampton, husbandman 2
5605582 2536627 2536627 defendant Balton William husbandman 589742 589742 Balton, William, of Rampton, husbandman 0
5616365 2548911 2548911 defendant Stanhop John de   589742 589742 Stanhop, John de, of Rampton 0
5617606 2549332 2549332 defendant Stanop Richard   589742 589742 Stanop, Richard, of Rampton 0
5617607 2549332 2549332 defendant Jors William   589742 589742 Jors, William, of Rampton 1
5617608 2549332 2549332 defendant Michel Robert   589742 589742 Michel, Robert, of Rampton 2
5618368 2549567 2549567 defendant Stanhop John de   589742 589742 Stanhop, John de, of Rampton 0
5621271 2550540 2550540 plaintiff Stannop John de   589742 589742 Stannop, John de, of Rampton 0
5626988 2552412 2552412 defendant Normanton John   589742 589742 Normanton, John, of Rampton, cartwright 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);