names

89 rows where place_id = 589617

✎ 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
3598187 1867063 1867063 defendant Lorkyn John husbandman 589617 589617 Lorkyn, John, of Dounham, husbandman 3
3602867 1868564 1868564 defendant Bundok Robert pulter 589617 589617 Bundok, Robert, of Dounham, pulter 3
3612241 1871464 1871464 defendant Aleyn John laborer 589617 589617 Aleyn, John, of Dounham, laborer 0
3612243 1871464 1871464 defendant Stutle Thomas   589617 589617 Stutle, Thomas, of Dounham, shepherd 2
3622030 1874432 1874432 defendant Stamer or Stainer Thomas husbandman 589617 589617 Stamer or Stainer, Thomas, of Dounham, husbandman 0
3630258 1904312 1904312 defendant Buntyng Richard husbandman 589617 589617 Buntyng, Richard, of Dounham, husbandman 2
3734455 1937020 1937020 defendant Mareys John husbandman 589617 589617 Mareys, John, of Dounham, husbandman 1
3813916 1962261 1962261 defendant Frost Adam   589617 589617 Frost, Adam, of Dounham, wright 4
3816703 1963130 1963130 defendant Bundok William yeoman 589617 589617 Bundok, William, of Dounham, yeoman 0
4257593 2115514 2115514 defendant Chaunter Anthony gent 589617 589617 Chaunter, Anthony, of Dounham, gent 0
4500446 2200761 2200761 defendant Perisson John   589617 589617 Perisson, John, of Dounham 0
4502122 2201258 2201258 defendant Broeyng Thomas   589617 589617 Broeyng, Thomas, of Dounham 2
4502123 2201258 2201258 defendant Wryghte William   589617 589617 Wryghte, William, of Dounham 3
4543822 2213964 2213964 plaintiff Berton John   589617 589617 Berton, John, of Dounham, parson 4
4556835 2218074 2218074 plaintiff Berton John   589617 589617 Berton, John, of Dounham, parson 1
4556841 2218075 2218075 plaintiff Berton John   589617 589617 Berton, John, of Dounham, parson 2
4604880 2232696 2232696 plaintiff Berton John   589617 589617 Berton, John, of Dounham, parson 2
4613087 2235148 2235148 defendant Grene Thomas   589617 589617 Grene, Thomas, of Dounham 11
4615167 2235750 2235750 defendant Frost John   589617 589617 Frost, John, of Dounham 5
4629485 2240150 2240150 defendant Taillour Robert   589617 589617 Taillour, Robert, of Dounham 0
4630085 2240323 2240323 defendant Michell Nicholas   589617 589617 Michell, Nicholas, of Dounham 1
4640835 2243418 2243418 defendant Couherde William   589617 589617 Couherde, William, of Dounham 3
4653915 2247135 2247135 plaintiff Berton John   589617 589617 Berton, John, of Dounham 0
4662046 2249605 2249605 plaintiff Ferrour or Smith John   589617 589617 Ferrour or Smith, John, of Dounham 0
4678991 2259037 2259037 defendant Whynne William chapman 589617 589617 Whynne, William, of Dounham, chapman 1
4678995 2259038 2259038 defendant Whynne William chapman 589617 589617 Whynne, William, of Dounham, chapman 1
4680327 2259459 2259459 defendant Dounham Thomas yeoman 589617 589617 Dounham, Thomas, of Dounham, yeoman 1
4680331 2259460 2259460 defendant Dounham Thomas yeoman 589617 589617 Dounham, Thomas, of Dounham, yeoman 1
4684829 2260856 2260856 defendant Dounham Thomas husbandman 589617 589617 Dounham, Thomas, of Dounham, husbandman 0
4729643 2274483 2274483 defendant Dounham Thomas   589617 589617 Dounham, Thomas, of Dounham, yeoman, formerly living in Brandon 0
4749916 2280450 2280450 defendant Qyn William yeoman 589617 589617 Qyn, William, of Dounham, yeoman 2
4776014 2288497 2288497 defendant Dounham Thomas gent 589617 589617 Dounham, Thomas, of Dounham, gent 1
4793453 2294060 2294060 defendant Stevenysson Robert husbandman 589617 589617 Stevenysson, Robert, of Dounham, husbandman 0
4799798 2296122 2296122 defendant Martyn Robert laborer 589617 589617 Martyn, Robert, of Dounham, laborer 0
4800820 2296448 2296448 plaintiff West John (legal representative) 589617 589617 West, John, of Dounham, executors of 0
4857173 2313628 2313628 defendant Spencer Thomas yeoman 589617 589617 Spencer, Thomas, of Dounham, yeoman 0
4890734 2323853 2323853 defendant Cok John husbandman 589617 589617 Cok, John, of Dounham, husbandman 0
4890735 2323853 2323853 defendant Rote Robert husbandman 589617 589617 Rote, Robert, of Dounham, husbandman 1
4890736 2323853 2323853 defendant Bukbateman John husbandman 589617 589617 Bukbateman, John, of Dounham, husbandman 2
4932071 2336424 2336424 defendant Broun Richard clerk 589617 589617 Broun, Richard, of Dounham, clerk 0
4956927 2344030 2344030 defendant Castell John yeoman 589617 589617 Castell, John, of Dounham, yeoman 1
5021440 2363180 2363180 plaintiff Powete John   589617 589617 Powete, John, of Dounham 1
5057673 2373860 2373860 defendant Lukas John pedder 589617 589617 Lukas, John, of Dounham, pedder 2
5059019 2374262 2374262 defendant Pore Richard husbandman 589617 589617 Pore, Richard, of Dounham juxta Denver, husbandman 0
5059020 2374262 2374262 defendant Alcok Thomas husbandman 589617 589617 Alcok, Thomas, of Dounham juxta Denver, husbandman 1
5100938 2386687 2386687 defendant Alderych John husbandman 589617 589617 Alderych, John, of Dounham, husbandman 0
5114851 2390756 2390756 defendant Gerlek Geoffrey husbandman 589617 589617 Gerlek, Geoffrey, of Dounham, husbandman 0
5161827 2404567 2404567 defendant Hyhoc Richard laborer 589617 589617 Hyhoc, Richard, of Dounham, laborer 0
5161828 2404567 2404567 defendant Noers Thomas   589617 589617 Noers, Thomas, of Dounham, shepherd 1
5161829 2404567 2404567 defendant Rede John laborer 589617 589617 Rede, John, of Dounham, laborer 2
5161830 2404567 2404567 defendant Curteys John laborer 589617 589617 Curteys, John, of Dounham, laborer 3
5176750 2408885 2408885 defendant Cook James   589617 589617 Cook, James, of Dounham, glove maker 0
5220948 2421823 2421823 defendant Wolballe William laborer 589617 589617 Wolballe, William, of Dounham, laborer 0
5222711 2422358 2422358 defendant Markaunt Robert husbandman 589617 589617 Markaunt, Robert, of Dounham, husbandman 0
5249987 2430109 2430109 plaintiff Walter John clerk 589617 589617 Walter, John, of Dounham, clerk 0
5255526 2431845 2431845 defendant Bevys or Benys Robert husbandman 589617 589617 Bevys or Benys, Robert, of Dounham, husbandman 1
5285609 2440812 2440812 defendant Martyn William husbandman 589617 589617 Martyn, William, of Dounham, husbandman 3
5292119 2442694 2442694 defendant Combland John yeoman 589617 589617 Combland, John, of Dounham, yeoman 3
5292135 2442697 2442697 defendant Ketyll William husbandman 589617 589617 Ketyll, William, of Dounham, husbandman 0
5292136 2442697 2442697 defendant Broun John laborer 589617 589617 Broun, John, of Dounham, laborer 1
5292137 2442697 2442697 defendant Ardeley William herdman 589617 589617 Ardeley, William, of Dounham, herdman 2
5294376 2443330 2443330 defendant Smyth William husbandman 589617 589617 Smyth, William, of Dounham, husbandman 0
5344822 2458542 2458542 defendant Reve John husbandman 589617 589617 Reve, John, of Dounham, husbandman 0
5344823 2458542 2458542 defendant Highe Richard laborer 589617 589617 Highe, Richard, of Dounham, laborer 1
5344824 2458542 2458542 defendant Petyt Richard laborer 589617 589617 Petyt, Richard, of Dounham, laborer 2
5394133 2473383 2473383 plaintiff Vygrous Richard   589617 589617 Vygrous, Richard, of Dounham 0
5402379 2475755 2475755 defendant Ostller John yeoman 589617 589617 Ostller, John, of Dounham, yeoman 2
5407268 2477141 2477141 plaintiff Vynsons Richard clerk 589617 589617 Vynsons, Richard, of Dounham, clerk 0
5415323 2479520 2479520 defendant Ostiller John yeoman 589617 589617 Ostiller, John, of Dounham, yeoman 3
5428573 2483467 2483467 defendant Gauge Richard butcher 589617 589617 Gauge, Richard, of Dounham Marker, butcher 11
5430561 2484073 2484073 defendant James Simon laborer 589617 589617 James, Simon, of Dounham, laborer 1
5447237 2489060 2489060 defendant James Simon laborer 589617 589617 James, Simon, of Dounham, laborer 1
5459703 2492822 2492822 defendant James Simon laborer 589617 589617 James, Simon, of Dounham, laborer 1
5459706 2492823 2492823 defendant James Simon laborer 589617 589617 James, Simon, of Dounham, laborer 1
5480219 2499066 2499066 defendant Poule Thomas mercer 589617 589617 Poule, Thomas, of Dounham, mercer 1
5484795 2500375 2500375 defendant Bundok Robert pulter 589617 589617 Bundok, Robert, of Dounham, pulter 1
5541313 2517398 2517398 defendant Reve Geoffrey   589617 589617 Reve, Geoffrey, of Dounham, shepherd 0
5553889 2521177 2521177 defendant Bundok Robert husbandman 589617 589617 Bundok, Robert, of Dounham, husbandman 1
5553891 2521177 2521177 defendant Camper Edward husbandman 589617 589617 Camper, Edward, of Dounham, husbandman 3
5560843 2523143 2523143 defendant Myllys Robert husbandman 589617 589617 Myllys, Robert, of Dounham, husbandman 0
5567163 2524974 2524974 defendant Smyth William husbandman 589617 589617 Smyth, William, of Dounham, husbandman 6
5579047 2528520 2528520 defendant Camper Edward husbandman 589617 589617 Camper, Edward, of Dounham, husbandman 2
5617241 2549209 2549209 defendant West John   589617 589617 West, John, of Dounham 0
5617244 2549209 2549209 defendant Lyneford Thomas   589617 589617 together with Lyneford, Thomas, of Dounham 3
5625827 2552025 2552025 defendant Wynne William chapman 589617 589617 Wynne, William, of Dounham, chapman 0
5626301 2552189 2552189 defendant Wyn William yeoman 589617 589617 Wyn, William, of Dounham, yeoman 7
5635554 2555084 2555084 plaintiff West John   589617 589617 West, John, of Dounham 0
5635562 2555085 2555085 plaintiff West John   589617 589617 West, John, of Dounham 0
5635570 2555086 2555086 plaintiff West John   589617 589617 West, John, of Dounham 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);